[SERVER-11725] incorrect index bounds union Created: 15/Nov/13  Updated: 11/Jul/16  Resolved: 19/Nov/13

Status: Closed
Project: Core Server
Component/s: Querying
Affects Version/s: 2.5.3
Fix Version/s: 2.5.5

Type: Bug Priority: Major - P3
Reporter: Benety Goh Assignee: Benety Goh
Resolution: Done Votes: 0
Labels: query_triage
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: File server11725.js    
Operating System: ALL
Participants:

 Description   

When we have a $or query with two clauses on the same field:

0 < a < 5
 
or
 
5 <  a < 10

the query optimizer is generating the following index bounds:

0 < a < 10

which is incorrect (5 should not be in bounds).



 Comments   
Comment by Githook User [ 19/Nov/13 ]

Author:

{u'username': u'benety', u'name': u'Benety Goh', u'email': u'benety@mongodb.com'}

Message: SERVER-11725 fixed interval comparison for INTERVAL_PRECEDES_COULD_UNION
Branch: master
https://github.com/mongodb/mongo/commit/31e272af4f900964997af2ce8b2e44013ea40187

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