[MDEV-3632] LP:695304 - Incorrect value reported for optimizer_switch by maria-5.3-wl21 Created: 2010-12-29  Updated: 2015-02-02  Resolved: 2012-10-04

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Minor
Reporter: Philip Stoev (Inactive) Assignee: Igor Babaev
Resolution: Fixed Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug695304.xml    

 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



 Comments   
Comment by Rasmus Johansson (Inactive) [ 2011-12-13 ]

Launchpad bug id: 695304

Generated at Thu Feb 08 06:50:03 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.