Loading...

XML

Word

Printable

JSON

Operating System:
ALL
Steps To Reproduce:

Hide

1.create text index for "a"

2.create nomral index for "b"

3.execute

db.getCollection('xxx').find({
"$or" :
[
{ "$text" : { "$search" : "xx"}},
{"b" : "xx"}
]
}
).collation({"locale":"en", "numericOrdering":true})

4.get error

"planner returned error :: caused by :: Failed to produce a solution for TEXT under OR - other non-TEXT clauses under OR have to be indexed as well.",

Show
1.create text index for "a" 2.create nomral index for "b" 3.execute db.getCollection('xxx').find({ "$or" : [ { "$text" : { "$search" : "xx"}}, {"b" : "xx"} ] } ).collation({"locale":"en", "numericOrdering":true}) 4.get error "planner returned error :: caused by :: Failed to produce a solution for TEXT under OR - other non-TEXT clauses under OR have to be indexed as well.",

An error occurred when using &or and adding collation({"locale":"en", "numericOrdering":true}) for query with text index