[SERVER-68093] [CQF] match with $ne is ignoring non literal values (and null) Created: 15/Jul/22  Updated: 05/Dec/22  Resolved: 04/Oct/22

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

Type: Task Priority: Major - P3
Reporter: Ruslan Abdulkhalikov (Inactive) Assignee: Backlog - Query Optimization
Resolution: Duplicate Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Duplicate
duplicates SERVER-68095 [CQF] Add $not to supported expressio... Closed
Assigned Teams:
Query Optimization
Participants:

 Description   

db.test.insert({"_id": 1, x:1})
db.test.insert({"_id": 2, x:{y:1}})
db.test.insert({"_id": 3, x:2})
db.test.insert({"_id": 4, x:null})
assert.sameMembers(db.test.aggregate([{$match: {x: {$ne: 1}}}]).toArray(),
 [
    {"_id": 1, x:1},
    {"_id": 2, x:{y:1}},
    {"_id": 3, x:2},
 ])
 

it returns only 

 { "_id" : 3, "x" : 2 } 


Generated at Thu Feb 08 06:09:51 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.