[Commits] Rev 2817: table_elimination switchable only for debug build and has no influence on the result of the test so it is removed. in file:///home/bell/maria/bzr/work-maria-5.3-lb615760/

sanja at askmonty.org sanja at askmonty.org
Thu Sep 9 11:01:14 EEST 2010


At file:///home/bell/maria/bzr/work-maria-5.3-lb615760/

------------------------------------------------------------
revno: 2817
revision-id: sanja at askmonty.org-20100909080113-n50060cuq884gibh
parent: sanja at askmonty.org-20100908062617-e5qtdh4b65r2gxsp
committer: sanja at askmonty.org
branch nick: work-maria-5.3-lb615760
timestamp: Thu 2010-09-09 11:01:13 +0300
message:
  table_elimination switchable only for debug build and has no influence on the result of the test so it is removed.
-------------- next part --------------
=== modified file 'mysql-test/r/subselect_cache.result'
--- a/mysql-test/r/subselect_cache.result	2010-09-08 06:26:17 +0000
+++ b/mysql-test/r/subselect_cache.result	2010-09-09 08:01:13 +0000
@@ -3199,7 +3199,7 @@ Note	1003	select `test`.`t1`.`a` AS `a` 
 drop table t1,t2;
 set @@optimizer_switch= default;
 # LP BUG#615760 (part 2: incorrect heap table index flags)
-SET SESSION optimizer_switch = 'index_merge=off,index_merge_union=off,index_merge_sort_union=off,index_merge_intersection=off,index_condition_pushdown=off,firstmatch=off,loosescan=off,materialization=off,semijoin=off,partial_match_rowid_merge=off,partial_match_table_scan=off,subquery_cache=on,table_elimination=off';
+SET SESSION optimizer_switch = 'index_merge=off,index_merge_union=off,index_merge_sort_union=off,index_merge_intersection=off,index_condition_pushdown=off,firstmatch=off,loosescan=off,materialization=off,semijoin=off,partial_match_rowid_merge=off,partial_match_table_scan=off,subquery_cache=on';
 CREATE TABLE `t1` (
 `pk` int(11) NOT NULL AUTO_INCREMENT,
 `col_int_nokey` int(11) DEFAULT NULL,

=== modified file 'mysql-test/t/subselect_cache.test'
--- a/mysql-test/t/subselect_cache.test	2010-09-08 06:26:17 +0000
+++ b/mysql-test/t/subselect_cache.test	2010-09-09 08:01:13 +0000
@@ -1489,7 +1489,7 @@ set @@optimizer_switch= default;
 #
 --echo # LP BUG#615760 (part 2: incorrect heap table index flags)
 #
-SET SESSION optimizer_switch = 'index_merge=off,index_merge_union=off,index_merge_sort_union=off,index_merge_intersection=off,index_condition_pushdown=off,firstmatch=off,loosescan=off,materialization=off,semijoin=off,partial_match_rowid_merge=off,partial_match_table_scan=off,subquery_cache=on,table_elimination=off';
+SET SESSION optimizer_switch = 'index_merge=off,index_merge_union=off,index_merge_sort_union=off,index_merge_intersection=off,index_condition_pushdown=off,firstmatch=off,loosescan=off,materialization=off,semijoin=off,partial_match_rowid_merge=off,partial_match_table_scan=off,subquery_cache=on';
 
 CREATE TABLE `t1` (
   `pk` int(11) NOT NULL AUTO_INCREMENT,



More information about the commits mailing list