Details
-
Improvement
-
Status: Backlog
-
Major - P3
-
Resolution: Unresolved
-
2.8.0-rc1
-
None
-
None
-
Query Optimization
Description
The mongodb regex parser cannot create accurate bounds to allow indexed lookups when the regex includes the "|" character. This was allowed previously, but could lead to incorrect results.
Original Description
I've got a database with 14 mio rows representing an imaginary "file system". There are (amongst others) the fields "type" (only "folder" or "file"), "folder" and "filename".
I now try this:
{
|
type:'folder',
|
folder:/^example1/
|
}
|
|
|
Very fast. No results - as expected. In fact, no rows even start with "example".
|
|
|
I now try this:
|
|
|
{
|
type:'folder',
|
folder:/^example2/
|
}
|
Very fast, too. No results again - as expected.
Now, I try this:
|
|
{
|
type:'folder',
|
folder:/^example(1|2)/
|
}
|
This query never returns. The whole database becomes horribly slow to the point of being unusable. I cannot even run any other queries. This used to work on 2.4.x. Why? 
Attachments
Issue Links
- is duplicated by
-
SERVER-22939 A regular expression with an escaped pipe '|' character is treated as non-simple
-
- Closed
-
-
-
- Closed
-
-
-
- Closed
-
-
-
- Closed
-
- is related to
-
-
- Closed
-
- related to
-
-
- Closed
-
-
-
- Closed
-
-
-
- Closed
-
-
-
- Closed
-