[SERVER-85728] Enable Bonsai plan cache tests involving indices Created: 25/Jan/24  Updated: 27/Jan/24

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

Type: Task Priority: Major - P3
Reporter: William Qian Assignee: Backlog - Query Optimization
Resolution: Unresolved Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Related
is related to SERVER-85146 [CQF] Interaction between CQF fast pa... Closed
Assigned Teams:
Query Optimization
Participants:

 Description   

Index scans are currently ineligible for Bonsai Plan Cache, so the corresponding JS test cases are disabled when Bonsai Plan Cache is enabled. Once index scans are supported, these testes should be re-enabled by removing the check for the Bonsai Plan Cache feature flag:

  • jstests/core/query/plan_cache/plan_cache_clear.js
  • jstests/core/query/plan_cache/plan_cache_sbe.js
  • jstests/core/query/plan_cache/plan_cache_sbe_hinted.js

Other tests will require implementing fast path disablement because the entire test uses indexes. The above three tests provide examples for how to do this in a passthrough test. noPassthrough tests can directly set the query knob for internalCascadesOptimizerDisableFastPath to true.

  • jstests/core/index/index_filter_commands_invalidate_plan_cache_entries.js
  • jstests/core/sbe/from_plan_cache_flag.js
  • jstests/core/sbe_plan_cache_autoparameterize_collscan.js
  • jstests/noPassthrough/plan_cache_hits_and_misses_metrics.js
  • jstests/noPassthrough/sbe_plan_cache_size_metric.js

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