[DOCS-2718] OR queries involving TEXT have to be fully indexed. (also doc or and geo) Created: 13/Feb/14  Updated: 03/Mar/14  Resolved: 03/Mar/14

Status: Closed
Project: Documentation
Component/s: manual
Affects Version/s: None
Fix Version/s: v1.3.2, mongodb-2.6

Type: Improvement Priority: Major - P3
Reporter: Benety Goh Assignee: Kay Kim (Inactive)
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Related
related to SERVER-12592 error message unclear for OR with tex... Closed
Participants:
Days since reply: 9 years, 50 weeks, 2 days ago

 Description   

consider

{ $or : [
 {$text: {$search: "findme"}},
{ a : {$gt: 12345} },
] }

Both clauses of the OR need to be indexed. We cannot have $text clause be satisfied by a text index and {a: {$gt...} be executed with a collection scan.

add blurb about $or and geo SERVER-3984



 Comments   
Comment by Githook User [ 03/Mar/14 ]

Author:

{u'username': u'kay-kim', u'name': u'kay', u'email': u'kay.kim@10gen.com'}

Message: DOCS-2718 or and text and geo
Branch: master
https://github.com/mongodb/docs/commit/455671c30eb0263673ef9d803eeed68f0b3bdada

Generated at Thu Feb 08 07:44:05 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.