[SERVER-54321] [SBE] jstests/aggregation/optimize_away_pipeline.js fails Created: 04/Feb/21  Updated: 27/Oct/23  Resolved: 04/Mar/21

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

Type: Bug Priority: Major - P3
Reporter: Anton Korshunov Assignee: Anton Korshunov
Resolution: Duplicate Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Duplicate
duplicates SERVER-54322 Text query plans are not shown proper... Closed
Related
related to SERVER-82525 Complete TODO listed in SERVER-54321 Blocked
related to SERVER-56552 Complete TODO listed in SERVER-54321 Closed
related to SERVER-56564 Complete TODO listed in SERVER-54321 Closed
Operating System: ALL
Steps To Reproduce:

resmoke run --suite=aggregation_sbe jstests/aggregation/optimize_away_pipeline.js

 

Sprint: Query Execution 2021-02-22, Query Execution 2021-03-08
Participants:

 Comments   
Comment by Drew Paroski [ 04/Mar/21 ]

Apologies for all the Jira churn.

With mickey.winters' diff for SERVER-54552, the following tests now pass when SBE mode is enabled:
    jstests/core/index_check3.js
    jstests/core/wildcard_index_nonblocking_sort.js
    jstests/core/min_max_bounds.js

I've re-purposed this task to track whatever remaining issue(s) are causing "optimize_away_pipeline.js" to fail when SBE mode is enabled.

It appears "optimize_away_pipeline.js" is failing (at least in part) due to SERVER-54322 ("Text query plans are not shown properly in SBE explain").

Comment by Nikita Lapkov (Inactive) [ 25/Feb/21 ]

SERVER-54548 has very similar symptoms: it returns less documents performing a backwards index scan while sorting in the descending order. Attaching the test from SERVER-54548 to this ticket and marking it as duplicate.

Comment by Nikita Lapkov (Inactive) [ 18/Feb/21 ]

After offline discussion with anton.korshunov, we have figured out that test jstests/core/wildcard_index_nonblocking_sort.js (originally part of SERVER-54490) fails due to the problem in backwards index scan, which Anton already investigates in this ticket. Attaching the test to this ticket and removing it from SERVER-54490.

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