Loading...

XML

Word

Printable

JSON

Operating System:
ALL
Steps To Reproduce:
Hide

I have a simple array of strings within a document, which is indexed, next I do this:

db.listings.find({ $and: [ {suggestion: /^Mercedes/}, {suggestion: /^Ser/} ] }, { suggestion: 1}).explain()

On the explain I get this:

"indexBounds" : { "suggestion" : [ [ "Mercedes", "Mercedet" ], [ /^Mercedes/, /^Mercedes/ ] ] },

but if I put the $or instead of $and I get this:

"indexBounds" : { "suggestion" : [ [ "Mercedes", "Mercedet" ], [ "Ser", "Ses" ], [ /^Mercedes/, /^Mercedes/ ], [ /^Ser/, /^Ser/ ] ] }

Im querying the same document and the same array on both cases
Show
I have a simple array of strings within a document, which is indexed, next I do this: db.listings.find({ $and: [ {suggestion: /^Mercedes/}, {suggestion: /^Ser/} ] }, { suggestion: 1}).explain() On the explain I get this: "indexBounds" : { "suggestion" : [ [ "Mercedes", "Mercedet" ], [ /^Mercedes/, /^Mercedes/ ] ] }, but if I put the $or instead of $and I get this: "indexBounds" : { "suggestion" : [ [ "Mercedes", "Mercedet" ], [ "Ser", "Ses" ], [ /^Mercedes/, /^Mercedes/ ], [ /^Ser/, /^Ser/ ] ] } Im querying the same document and the same array on both cases
Confidence Status:
None
Work Order:
3

Hello,

not sure if this is an issue, but I didn't found anything useful on the docs...

can I query same field using regex and $and operator? when I add the explain() I dont see the second regex shown there