[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? |