[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 Location: https://docs.mongodb.org/manual/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 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! |