diff options
| author | Sergey Petrunya <psergey@askmonty.org> | 2010-07-16 12:58:24 +0400 |
|---|---|---|
| committer | Sergey Petrunya <psergey@askmonty.org> | 2010-07-16 12:58:24 +0400 |
| commit | 13058d8056cea616a39f82d18d1ab061cbbf0bcb (patch) | |
| tree | 1fde269708463bbe4f91090d6d073e1a78053bf3 /mysql-test/r/myisam_mrr.result | |
| parent | 4274e9b5d4c8998e8c47fc7d322d0cdb2210cfe5 (diff) | |
| download | mariadb-git-13058d8056cea616a39f82d18d1ab061cbbf0bcb.tar.gz | |
Fix @@optimizer_switch support
- Let "mysqld --help --verbose" list all optimizer options
- Make it possible to add new @@optimizer_switch flags w/o causing .result
changes all over the testsuite:
= Remove "select @@optimizer_switch" from tests that do not need all switches
= Move @@optimizer_switch-specific tests to t/optimizer_switch.test
Diffstat (limited to 'mysql-test/r/myisam_mrr.result')
| -rw-r--r-- | mysql-test/r/myisam_mrr.result | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/r/myisam_mrr.result b/mysql-test/r/myisam_mrr.result index 70bc0cd36be..5db03db85ac 100644 --- a/mysql-test/r/myisam_mrr.result +++ b/mysql-test/r/myisam_mrr.result @@ -392,9 +392,9 @@ drop table t0, t1; # Part of MWL#67: DS-MRR backport: add an @@optimizer_switch flag for # index_condition pushdown: # - engine_condition_pushdown does not affect ICP -select @@optimizer_switch; -@@optimizer_switch -index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_condition_pushdown=on,firstmatch=on,loosescan=on,materialization=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on +select @@optimizer_switch like '%index_condition_pushdown=on%'; +@@optimizer_switch like '%index_condition_pushdown=on%' +1 create table t0 (a int); insert into t0 values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); create table t1 (a int, b int, key(a)); |