Details
-
Bug
-
Status: Closed
-
Major - P3
-
Resolution: Fixed
-
2.6.1, 2.7.0
-
None
-
version 2.6.0
gitVersion 1c1c76aeca21c5983dc178920f5052c298db616c
targetMinOS Windows 7/Windows Server 2008 R2
OpenSSLVersion
sysInfo windows sys.getwindowsversion(major=6, minor=1, build=7601, platform=2, service_pack='Service Pack 1') BOOST_LIB_VERSION=1_49
loaderFlags /nologo /DEBUG /INCREMENTAL:NO /LARGEADDRESSAWARE
compilerFlags /TP /nologo /EHsc /W3 /wd4355 /wd4800 /wd4267 /wd4244 /wd4290 /we4099 /Z7 /errorReport:none /MT /O2 /Oy-
allocator system
versionArray [2,6,0,0]
javascriptEngine V8
bits 64
debug FALSE
maxBsonObjectSize 16777216version 2.6.0 gitVersion 1c1c76aeca21c5983dc178920f5052c298db616c targetMinOS Windows 7/Windows Server 2008 R2 OpenSSLVersion sysInfo windows sys.getwindowsversion(major=6, minor=1, build=7601, platform=2, service_pack='Service Pack 1') BOOST_LIB_VERSION=1_49 loaderFlags /nologo /DEBUG /INCREMENTAL:NO /LARGEADDRESSAWARE compilerFlags /TP /nologo /EHsc /W3 /wd4355 /wd4800 /wd4267 /wd4244 /wd4290 /we4099 /Z7 /errorReport:none /MT /O2 /Oy- allocator system versionArray [2,6,0,0] javascriptEngine V8 bits 64 debug FALSE maxBsonObjectSize 16777216
-
-
Server 2.7.1
Description
ISSUE SUMMARY
When the query planner is picking an index for a whole index scan solution (to provide a sort), it considers the index's sparseness flag but doesn't consider whether or not the index is of a special index type. Thus the wrong index may be used and results won't be what the user expects. This is a regression from 2.4.
USER IMPACT
Incorrectly using a hashed index for a sort will generate results out of order. Incorrectly using a text or geo index for a sort will similarly generate results out of order, and additionally can cause results to be missing from the result set.
WORKAROUNDS
On a query-by-query basis, users may work around this issue by employing the hint() feature or index filter feature to force the query planner to choose a non-offending index. There is no workaround that can be employed server-wide.
AFFECTED VERSIONS
MongoDB production versions 2.6.0 and 2.6.1 are affected by this issue.
FIX VERSION
The fix is included in the 2.6.2 production release.
RESOLUTION DETAILS
Use indexes of a special index type to provide a sort only when the query predicate can be used to guarantee the sort order and that all documents to be returned are indexed.
Original description
If a particular field is defined as a hashed index, when sorting the result set is not in the expected order. When using a non-hashed (normal) index or no index at all on the specific String field, the result set's order is correct when sorting. This can be reproduced in the MongoDB shell, Node.js driver, and PHP driver, so I'm assuming this is a problem with the core server.
The steps to reproduce show only how to reproduce the problem, but the following code illustrates the effect:
use test;
|
|
|
db.sorthashed.insert([
|
{str:'bravo'}, |
{str:'alpha'}, |
{str:'tango'}, |
{str:'charlie'} |
]); // intentionally inserted out of alpha order, field in question is `str` |
db.sorthashed.find({}).sort({str:1}).pretty(); // shows in order |
|
|
db.sorthashed.ensureIndex({str:'hashed'},{background:false}); |
db.sorthashed.find({}).sort({str:1}).pretty(); // shows out of order |
|
|
db.sorthashed.dropIndex('str_hashed'); |
db.sorthashed.find({}).sort({str:1}).pretty(); // shows in order |
|
|
db.sorthashed.ensureIndex({str:-1},{background:false}); // using desc index order as an example |
db.sorthashed.find({}).sort({str:1}).pretty(); // shows in order |
Attachments
Issue Links
- is duplicated by
-
-
- Closed
-
- related to
-
SERVER-10801 Allow compound geo indexes to be able to provide sort
-
- Backlog
-