[SERVER-70929] cover_null_queries.js returns unexpected output for CQF passthrough Created: 28/Oct/22  Updated: 05/Dec/22  Resolved: 28/Oct/22

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

Type: Bug Priority: Major - P3
Reporter: Alya Berciu 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-67506 [CQF] Dotted path equality to null in... Open
Assigned Teams:
Query Optimization
Operating System: ALL
Participants:

 Description   

It looks like some cases in jstests/core/cover_null_queries.js (once the PR for SERVER-70436 is merged) return incorrect output on CQF passthroughs.

Specifically, the command coll.find({"a.b": null}, {_id: 1}) matches the following documents, which are not matched in the classic engine:
{_id: 14, a: [1, 2, 3]},
{_id: 16, a: [null]},
 
Note that the only index is

{"a.b": 1, _id: 1}

.


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