[SERVER-29883] "|" in query string occur into a full index scan, slow query Created: 28/Jun/17 Updated: 29/Jul/17 Resolved: 28/Jun/17 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | Querying |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major - P3 |
| Reporter: | dancer | Assignee: | Kelsey Schubert |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Attachments: |
|
||||||||||||
| Issue Links: |
|
||||||||||||
| Operating System: | ALL | ||||||||||||
| Participants: | |||||||||||||
| Description |
|
db.wd_data.find({"path":{"$in":[/^\/PersonalWx\/Wx3001\/A李鑫老师助理6965号刘赫楠\/WxTxl\/三119扫单D!nG先生Super7李先生\//]}} vs db.wd_data.find({"path":{"$in":[/^\/PersonalWx\/Wx3001\/A李鑫老师助理6965号刘赫楠\/WxTxl\/三119扫单D!nG|先生Super7李先生\//]}} the difference is the first one has no "|" in the query string, the second one does. |
| Comments |
| Comment by dancer [ 05/Jul/17 ] |
|
Since the issue is not fixed,I suggest user who want to match prefix to use "$gte + $lt" instead of regex. |
| Comment by Kelsey Schubert [ 28/Jun/17 ] |
|
Hi dancer, Thanks for the clarification. After review, we are going to continue to track this work in SERVER-16622. For additional context, please see David Storch's comment clarifies this decision:
Kind regards, |
| Comment by dancer [ 28/Jun/17 ] |
|
I have viewed the previous issue, But I don't think it is a duplicated issue. |
| Comment by Kelsey Schubert [ 28/Jun/17 ] |
|
Hi dancer, Thank you for reporting this issue. The work to improve this behavior is tracked in SERVER-16622. Please feel free to vote for SERVER-16622 and watch it for updates. Kind regards, |