Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Critical
-
Resolution: Unresolved
-
10.5.25, 10.6.18, 10.11.8, 11.6(EOL)
Description
The optimizer can perform a range scan and build a SEL_TREE.
When attempting to allocate more than optimizer_max_sel_args (thd->variables.optimizer_max_sel_args), Item_cond::get_mm_tree() will abort all range scans and potentially revert to a full table scan.
This issue is created to explore more useful alternatives to this.
Attachments
Issue Links
- relates to
-
MDEV-34620 Large N-way OR causes a lot of index_merge variants to be created and discarded
- Stalled