-
Type: Bug
-
Resolution: Duplicate
-
Priority: Major - P3
-
None
-
Affects Version/s: None
-
Component/s: Querying
-
None
-
ALL
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.
I will attach the explain() info, they show the difference
- duplicates
-
SERVER-20432 $regex prefix search with escaped "|" should use tighter index bounds
- Closed
-
SERVER-16622 RegEx query predicates using the | (vertical bar) character cannot use tight index bounds
- Backlog