Simplification may need to preserve record length

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

Bug Description

For a certain small class of optimizer bugs, simplification that removes all unnecessary columns produces an non-repeatable test case. The reason is that the total record length decreases, making full table scans more likely.

Therefore, simplification should try to either remove all columns, or replace them with a single CHAR() column whose length is equal to the sum of the length of the removed columns.

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.