diff options
| author | Igor Babaev <igor@askmonty.org> | 2011-07-22 23:47:28 -0700 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2011-07-22 23:47:28 -0700 |
| commit | 668eb2b55ed2cefeb79e196ba48565a75f485f15 (patch) | |
| tree | d042decca87b2c0f3545b49b7c752b25ff7402e4 /mysql-test/r/ps_3innodb.result | |
| parent | d117f51901adc011d6d655216ec19ee0559e6acf (diff) | |
| download | mariadb-git-668eb2b55ed2cefeb79e196ba48565a75f485f15.tar.gz | |
Removed settings of 'derived_merge' to 'on' in ps tests.
Diffstat (limited to 'mysql-test/r/ps_3innodb.result')
| -rw-r--r-- | mysql-test/r/ps_3innodb.result | 3 |
1 files changed, 0 insertions, 3 deletions
diff --git a/mysql-test/r/ps_3innodb.result b/mysql-test/r/ps_3innodb.result index 701c7528cca..6b7434390af 100644 --- a/mysql-test/r/ps_3innodb.result +++ b/mysql-test/r/ps_3innodb.result @@ -902,8 +902,6 @@ a (select count(distinct t5.b) as sum from t5, t6 1 2 drop table t5, t6, t7 ; drop table if exists t2 ; -set @save_optimizer_switch=@@optimizer_switch; -set optimizer_switch='derived_merge=on'; create table t2 as select * from t9; set @stmt= ' SELECT (SELECT SUM(c1 + c12 + 0.0) FROM t2 @@ -953,7 +951,6 @@ execute stmt1 using @arg00, @arg01, @arg02, @arg03, @arg04, @arg05, @arg06, execute stmt1 using @arg00, @arg01, @arg02, @arg03, @arg04, @arg05, @arg06, @arg07, @arg08, @arg09 ; drop table t2 ; -set optimizer_switch=@save_optimizer_switch; select 1 < (select a from t1) ; ERROR 21000: Subquery returns more than 1 row prepare stmt1 from ' select 1 < (select a from t1) ' ; |