[SERVER-83147] [CQF] Support constant folding of NaN comparisons to query parameters Created: 10/Nov/23  Updated: 27/Nov/23  Resolved: 21/Nov/23

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

Type: Improvement Priority: Major - P3
Reporter: Ben Shteinfeld Assignee: Lynne Wang
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
depends on SERVER-82148 [CQF] Use parameter type information ... Closed
is depended on by SERVER-81958 M4. Meet Performance Targets Closed
is depended on by SERVER-79622 [CQF] Improve intersectDNFIntervals b... Open
Assigned Teams:
Query Optimization
Backwards Compatibility: Fully Compatible
Sprint: QO 2023-11-27
Participants:

 Description   

Since we know that we will never parameterize NaN constants, when we encounter a comparison between a parameter and NaN, we should be able to take advantage of the type of the parameter to constant fold the expression. This is follow up work to SERVER-82148.

We frequently encounter expressions with comparisons to NaN because of type bracketing comparisons generated during ABT translation. For example, {a: {$gt: 5, $lt: 10}}.



 Comments   
Comment by Githook User [ 21/Nov/23 ]

Author:

{'name': 'Lynne Wang', 'email': 'lynne.wang@mongodb.com', 'username': 'lynne-wang'}

Message: SERVER-83147 Support constant folding of NaN comparisons to query parameters
Branch: master
https://github.com/mongodb/mongo/commit/598c55daf9b15f5d8aa55a1355768d251f4e52dd

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