Loading...

XML

Word

Printable

JSON

Operating System:
ALL
Steps To Reproduce:
Hide

The query:

{ "Keys.Queryables" : { "$in" : [/^PostType\|ArticlePost\|en_GB_/] }, "Keys.SortId" : { "$lt" : ObjectId("56d061a36afc7d277434ca87") } }

The sorting order:

{"Keys.Queryables": -1}

or

{"Keys.Queryables": 1}

Notice that the documents are returned in the same order regardless of requesting ascending or descending.

See the documents and indexes in the attached Word document.
Show
The query: { "Keys.Queryables" : { "$in" : [/^PostType\|ArticlePost\|en_GB_/] }, "Keys.SortId" : { "$lt" : ObjectId("56d061a36afc7d277434ca87") } } The sorting order: {"Keys.Queryables": -1} or {"Keys.Queryables": 1} Notice that the documents are returned in the same order regardless of requesting ascending or descending. See the documents and indexes in the attached Word document.

I query on a collection with three documents, expecting to get documents back ordered by the "Keys.Queryables" field.

This works as expected in 2.6.1, but in 3.2.3 the documents are always returned in ascending order.

Query Bug.docx
Feb 26 2016 03:11:13 PM UTC
22 kB
ITWEBTF SAXOBANK
Query Bug with no pipe symbol.docx
Mar 01 2016 03:41:23 PM UTC
27 kB
ITWEBTF SAXOBANK

is related to

SERVER-15235 Regex query returns incorrect results when index is present

SERVER-16622 RegEx query predicates using the | (vertical bar) character cannot use tight index bounds

SERVER-19402 Change semantics of sorting by array fields in find and aggregate

related to

SERVER-22890 3.2.3 performance regression