Cross check between enabled optimizations and triggered optimizations

Bug #854548 reported by Philip Stoev
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Random Query Generator
New
Undecided
Unassigned

Bug Description

The following two "silent" scenarios are possible:

- an optimization transformation is disabled in DisableChosenPlan, and is therefore not tested at all.

- an optimization transformation is enabled in DisableChosenPlan, but is not exercised by the particular grammar or combination of optimizer switches;

A partial solution to the second one would be to print out a warning if there were transformations in DisableChosenPlan that were not triggered by any incoming qurey.

The solution for the first would be to fail the test if most queries passed through DisableChosenPlan without modification, as visible in EXPLAIN.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.