[DOCS-7338] MongoDB full text search negation broken no ignore for special characters Created: 03/Mar/16  Updated: 30/Oct/23  Resolved: 01/Nov/22

Status: Closed
Project: Documentation
Component/s: Server
Affects Version/s: None
Fix Version/s: Server_Docs_20231030

Type: Bug Priority: Major - P3
Reporter: Docs Collector User (Inactive) Assignee: Unassigned
Resolution: Won't Fix Votes: 0
Labels: collector-298ba4e7
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

windows 7 64 bit 16gb ram, intel i5
mongodb v3.2

Location: https://docs.mongodb.org/manual/reference/operator/query/text/
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/48.0.2564.103 Safari/537.36
Referrer: https://www.google.com/
Screen Resolution: 1920 x 1080
repo: docs
source: reference/operator/query/text


Participants:
Days since reply: 1 year, 14 weeks, 1 day ago
Epic Link: DOCSP-1769

 Description   

i am searching for codes such as "250.00" in a rather large database. the phrasing controls are working properly here so "\"250.00\"" in the execution stats is 250.00 which is exactly what i want to search for.

The problem here is that terms is showing "[250, 00 ]" the term "00" is breaking the mongodb and causing it to search all records. In my database which is upwards of 1.5 million records its not responding for over a minute with results. I tested a "control" situation and searched just by "00" which took over a minute to respond. Then I searched by "250" and got the expected under 1/2 second response.

I even took the time to do "250.00 -00" but the negation does not seem to be working either and it still searches by "00" in the table.

I also tries "250\.00" as well as "250
.00" such that the escape would exist in the string when it reached mongo through the driver, and continues to produce the same results.

This is very alarming when developing in a windows environment. It does not seem to be broken in *nix environments.

Please take a look at how to implement possibly escaping punctuation, or marking search terms as exact string matches.

Also look into the negation list not negating terms.

Let me know any useful information you can provide about this or if it is in the road-map to be fixed. If you can't reproduce the result, please feel free to contact me.



 Comments   
Comment by Education Bot [ 01/Nov/22 ]

Hello! This ticket has been closed due to inactivity. If you believe this ticket is still important, please reopen it and leave a comment to explain why. Thank you!

Generated at Thu Feb 08 07:54:05 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.