[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: |
|
| 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 |