Incorrect value reported for optimizer_switch by maria-5.3-wl21

Bug #695304 reported by Philip Stoev
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MariaDB
Fix Released
Medium
Igor Babaev

Bug Description

When constructing and reporting the current value of optimizer_switch , maria-5.3-wl21 does not put a comma between index_merge_sort_union and index_condition_pushdown. This prevents the value from being parsed properly

To repeat:

sql/mysqld --verbose --help | grep optimizer_switch

optimizer_switch index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=offindex_condition_pushdown=on,firstmatch=on,loosescan=on,materialization=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr_sort_keys=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,table_elimination=on

Note the string contains "index_merge_sort_intersection=offindex_condition_pushdown=on" with no comma.

If the variable is accessed via SELECT @@optimizer_switch or via information_schema, the correct value is reported

Related branches

Changed in maria:
assignee: nobody → Igor Babaev (igorb-seattle)
milestone: none → 5.3
Changed in maria:
status: New → Confirmed
importance: Undecided → Medium
status: Confirmed → In Progress
Changed in maria:
status: In Progress → Fix Committed
Changed in maria:
status: Fix Committed → Fix Released
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.