[SERVER-13511] $and and $nin does not work well together Created: 08/Apr/14  Updated: 10/Dec/14  Resolved: 08/Apr/14

Status: Closed
Project: Core Server
Component/s: Querying
Affects Version/s: 2.4.9
Fix Version/s: None

Type: Bug Priority: Major - P3
Reporter: NOVALUE Mitar Assignee: Unassigned
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Operating System: ALL
Steps To Reproduce:

Run the query above. Query should not return any document. It returns a document if _id exists.

Participants:

 Description   

The following query still returns a document, despite logically it should not:

{ '$and': [

{ _id: 'qSEhNMGPv38AY4gCR' }

, {_in: { '$nin': [ 'qSEhNMGPv38AY4gCR' ] }}] }



 Comments   
Comment by NOVALUE Mitar [ 08/Apr/14 ]

Oh, my bad. No, I was really testing with this. Sorry for the noise! Feel free to close the ticket.

Comment by Eliot Horowitz (Inactive) [ 08/Apr/14 ]

Is the _in rather than _id as the field for the $nin a typo?

Generated at Thu Feb 08 03:31:57 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.