[SERVER-16487] Regex not working properly on indexed fields.. Created: 10/Dec/14  Updated: 10/Dec/14  Resolved: 10/Dec/14

Status: Closed
Project: Core Server
Component/s: Querying
Affects Version/s: 2.6.6
Fix Version/s: None

Type: Bug Priority: Major - P3
Reporter: Jagdish Idhate [X] Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Duplicate
duplicates SERVER-5290 fail to insert docs with fields too l... Closed
Operating System: Linux
Steps To Reproduce:

db.test.insert({"path" : ",547958676a67b77b149b7c64,547958686a67b77b149b7c6e,547958686a67b77b149b7c6f,547958686a67b77b149b7c71,547958686a67b77b149b7c74,547958686a67b77b149b7c77,547958686a67b77b149b7c7a,547958686a67b77b149b7c7d,547958686a67b77b149b7c80,547958686a67b77b149b7c83,547958686a67b77b149b7c86,547958686a67b77b149b7c89,547958686a67b77b149b7c8c,547958686a67b77b149b7c8f,547958686a67b77b149b7c92,547958686a67b77b149b7c95,547958686a67b77b149b7c98,547958686a67b77b149b7c9b,547958686a67b77b149b7c9e,547958686a67b77b149b7ca1,547958686a67b77b149b7ca4,547958686a67b77b149b7ca7,547958686a67b77b149b7caa,547958686a67b77b149b7cad,547958686a67b77b149b7cb0,547958686a67b77b149b7cb3,547958686a67b77b149b7cb6,547958686a67b77b149b7cb9,547958686a67b77b149b7cbc,547958686a67b77b149b7cbf,547958686a67b77b149b7cc2,547958686a67b77b149b7cc5,547958686a67b77b149b7cc8,547958686a67b77b149b7ccb,547958686a67b77b149b7cce,547958686a67b77b149b7cd1,547958686a67b77b149b7cd4,547958686a67b77b149b7cd7,547958686a67b77b149b7cda",})
db.test.insert({"path" : ",547958676a67b77b149b7c64,547958686a67b77b149b7c6e,547958686a67b77b149b7c6f,547958686a67b77b149b7c71,547958686a67b77b149b7c74,547958686a67b77b149b7c77,547958686a67b77b149b7c7a,547958686a67b77b149b7c7d,547958686a67b77b149b7c80,547958686a67b77b149b7c83,547958686a67b77b149b7c86,547958686a67b77b149b7c89,547958686a67b77b149b7c8c,547958686a67b77b149b7c8f,547958686a67b77b149b7c92,547958686a67b77b149b7c95,547958686a67b77b149b7c98,547958686a67b77b149b7c9b,547958686a67b77b149b7c9e,547958686a67b77b149b7ca1,547958686a67b77b149b7ca4,547958686a67b77b149b7ca7,547958686a67b77b149b7caa,547958686a67b77b149b7cad,547958686a67b77b149b7cb0,547958686a67b77b149b7cb3,547958686a67b77b149b7cb6,547958686a67b77b149b7cb9,547958686a67b77b149b7cbc,547958686a67b77b149b7cbf,547958686a67b77b149b7cc2,547958686a67b77b149b7cc5,547958686a67b77b149b7cc8,547958686a67b77b149b7ccb,547958686a67b77b149b7cce,547958686a67b77b149b7cd1,547958686a67b77b149b7cd4,547958686a67b77b149b7cd7,547958686a67b77b149b7cda,547958686a67b77b149b7cdd", })
db.test.insert({"path" : ",547958676a67b77b149b7c64,547958686a67b77b149b7c6e,547958686a67b77b149b7c6f,547958686a67b77b149b7c71,547958686a67b77b149b7c74,547958686a67b77b149b7c77,547958686a67b77b149b7c7a,547958686a67b77b149b7c7d,547958686a67b77b149b7c80,547958686a67b77b149b7c83,547958686a67b77b149b7c86,547958686a67b77b149b7c89,547958686a67b77b149b7c8c,547958686a67b77b149b7c8f,547958686a67b77b149b7c92,547958686a67b77b149b7c95,547958686a67b77b149b7c98,547958686a67b77b149b7c9b,547958686a67b77b149b7c9e,547958686a67b77b149b7ca1,547958686a67b77b149b7ca4,547958686a67b77b149b7ca7,547958686a67b77b149b7caa,547958686a67b77b149b7cad,547958686a67b77b149b7cb0,547958686a67b77b149b7cb3,547958686a67b77b149b7cb6,547958686a67b77b149b7cb9,547958686a67b77b149b7cbc,547958686a67b77b149b7cbf,547958686a67b77b149b7cc2,547958686a67b77b149b7cc5,547958686a67b77b149b7cc8,547958686a67b77b149b7ccb,547958686a67b77b149b7cce,547958686a67b77b149b7cd1,547958686a67b77b149b7cd4,547958686a67b77b149b7cd7,547958686a67b77b149b7cda,547958686a67b77b149b7cdd,547958686a67b77b149b7ce0", })
db.test.ensureIndex( { path: 1 } )
db.test.find({path:{$regex:',547958676a67b77b149b7c64'}})

Participants:

 Description   

Please follow steps to reproduce bug.
If i remove index on path field then it gives proper result count 3
else it gives result count 2



 Comments   
Comment by Jagdish Idhate [X] [ 10/Dec/14 ]

Thanks Ramon,
mongodb team is awesome..

On Wed, Dec 10, 2014 at 7:40 PM, Ramon Fernandez (JIRA) <jira@mongodb.org>

Regards,

Jagdish Idhate| Lead Software Engineer

Ez-XBRL Solutions **| **Simplifying XBRL

US Phone: 703-372-6482

703, Mayuresh Chambers, Sector 11, CBD Belapur, Navi Mumbai – 400614 |
INDIA |* Web:* www.ez-xbrl.com

Comment by Jagdish Idhate [X] [ 10/Dec/14 ]

Thanks Ramon,
mongodb team is awesome..

On Wed, Dec 10, 2014 at 7:40 PM, Ramon Fernandez (JIRA) <jira@mongodb.org>

Regards,

Jagdish Idhate| Lead Software Engineer

Ez-XBRL Solutions **| **Simplifying XBRL

US Phone: 703-372-6482

703, Mayuresh Chambers, Sector 11, CBD Belapur, Navi Mumbai – 400614 |
INDIA |* Web:* www.ez-xbrl.com

Comment by Ramon Fernandez Marina [ 10/Dec/14 ]

Jagdish, the third document in your example contains a key that's too long to be indexed, so when your query uses an index it will not be returned. You're probably running with failIndexKeyTooLong set to false, otherwise the indexing operation complains about this issue.

Please take a look at SERVER-5290, where the general behavior with long keys is explained.

Regards,
Ramón.

Generated at Thu Feb 08 03:41:12 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.