[SERVER-69026] [CQF] Support for index OR-ing Created: 21/Aug/22  Updated: 29/Oct/23  Resolved: 27/Apr/23

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

Type: Improvement Priority: Major - P3
Reporter: Svilen Mihaylov (Inactive) Assignee: David Percy
Resolution: Fixed Votes: 0
Labels: auto-reverted, feature
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
depends on SERVER-75587 [CQF] Handle RIDUnion for physical op... Closed
depends on SERVER-74101 [CQF] Update callsites of PartialSche... Closed
depends on SERVER-74539 [CQF] Handle disjunction in PartialSc... Closed
depends on SERVER-74540 [CQF] Handle disjunction in SargableN... Closed
depends on SERVER-70163 [CQF] Implement RIDUnionNode Closed
depends on SERVER-70164 [CQF] Support Partial Schema Requirem... Closed
depends on SERVER-70637 [CQF] Implement sorted merge physical... Closed
depends on SERVER-71846 [CQF] Utility to convert a BoolExpr t... Closed
is depended on by SERVER-72010 [CQF] SortedMergeNode reference track... Backlog
is depended on by SERVER-69351 [CQF] Use a union plan avoid fetching... Closed
Problem/Incident
Related
is related to SERVER-68488 Estimate FilterNode with mixed sargab... Backlog
Assigned Teams:
Query Optimization
Backwards Compatibility: Fully Compatible
Sprint: QO 2023-04-17, QO 2023-05-01
Participants:
Linked BF Score: 135

 Description   

Support a DNF when converting a filter to PSR: a vector of partial schema req. If we encounter a PathComposeA, convert to a vector. After conversion, place a disjunction using a new RIDUnionNode.



 Comments   
Comment by Githook User [ 27/Apr/23 ]

Author:

{'name': 'David Percy', 'email': 'david.percy@mongodb.com', 'username': 'dpercy'}

Message: SERVER-69026 [CQF] Rewrite Sargable disjunction to RIDUnion
Branch: master
https://github.com/mongodb/mongo/commit/ecc1631b5b299b0753909f7abf874008e5e51e7e

Comment by xgen-buildbaron-user [ 26/Apr/23 ]

Ticket re-opened due to revert. query_golden_cqf began a consistent failure of jstests\query_golden\ce_mixed.js

Comment by Githook User [ 26/Apr/23 ]

Author:

{'name': 'auto-revert-processor', 'email': 'dev-prod-dag@mongodb.com', 'username': ''}

Message: Revert "SERVER-69026 [CQF] Rewrite Sargable disjunction to RIDUnion"

This reverts commit f55584c091541a27c0ccf3c1eceb5d58a4a9c896.
Branch: master
https://github.com/mongodb/mongo/commit/5c1f588bfa4ed2edbeb3abbb26e952e08641da14

Comment by Githook User [ 25/Apr/23 ]

Author:

{'name': 'David Percy', 'email': 'david.percy@mongodb.com', 'username': 'dpercy'}

Message: SERVER-69026 [CQF] Rewrite Sargable disjunction to RIDUnion
Branch: master
https://github.com/mongodb/mongo/commit/f55584c091541a27c0ccf3c1eceb5d58a4a9c896

Comment by xgen-buildbaron-user [ 22/Apr/23 ]

Ticket re-opened due to revert. cqf_passthrough began a consistent failure of jstests/core/query/or/or_inexact.js

Comment by Githook User [ 22/Apr/23 ]

Author:

{'name': 'auto-revert-processor', 'email': 'dev-prod-dag@mongodb.com', 'username': ''}

Message: Revert "SERVER-69026 [CQF] Rewrite Sargable disjunction to RIDUnion"

This reverts commit 1c7f114d6cc1b8e1691bcb9a7a36776cc1e96780.
Branch: master
https://github.com/mongodb/mongo/commit/522136d69a6db74ccfb3a1d2277c4fd2396f66f7

Comment by Githook User [ 21/Apr/23 ]

Author:

{'name': 'David Percy', 'email': 'david.percy@mongodb.com', 'username': 'dpercy'}

Message: SERVER-69026 [CQF] Rewrite Sargable disjunction to RIDUnion
Branch: master
https://github.com/mongodb/mongo/commit/1c7f114d6cc1b8e1691bcb9a7a36776cc1e96780

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