diff options
| author | unknown <sanja@askmonty.org> | 2011-09-05 08:15:46 +0300 |
|---|---|---|
| committer | unknown <sanja@askmonty.org> | 2011-09-05 08:15:46 +0300 |
| commit | 4338091967df9fcb4a2576e2f21302a75d4feb36 (patch) | |
| tree | adfb37b271a91782a11b15061586f8d9a5bc92c9 | |
| parent | 37a8497d494ea256ff4b13a89e62150e06a17dae (diff) | |
| download | mariadb-git-4338091967df9fcb4a2576e2f21302a75d4feb36.tar.gz | |
Fix pbxt suite to keep the same opti9misation it was before.
| -rw-r--r-- | mysql-test/suite/pbxt/r/subselect.result | 2 | ||||
| -rw-r--r-- | mysql-test/suite/pbxt/t/subselect.test | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/suite/pbxt/r/subselect.result b/mysql-test/suite/pbxt/r/subselect.result index ebe74e442a2..8c3d1223b0a 100644 --- a/mysql-test/suite/pbxt/r/subselect.result +++ b/mysql-test/suite/pbxt/r/subselect.result @@ -1483,7 +1483,7 @@ id select_type table type possible_keys key key_len ref rows filtered Extra Warnings: Note 1003 select `test`.`t1`.`s1` AS `s1`,(not(<in_optimizer>(`test`.`t1`.`s1`,<exists>(<index_lookup>(<cache>(`test`.`t1`.`s1`) in t2 on s1 checking NULL where (`test`.`t2`.`s1` < 'a2') having trigcond(<is_not_null_test>(`test`.`t2`.`s1`))))))) AS `s1 NOT IN (SELECT s1 FROM t2 WHERE s1 < 'a2')` from `test`.`t1` drop table t1,t2; -create table t2 (a int, b int); +create table t2 (a int, b int not null); create table t3 (a int); insert into t3 values (6),(7),(3); select * from t3 where a >= all (select b from t2); diff --git a/mysql-test/suite/pbxt/t/subselect.test b/mysql-test/suite/pbxt/t/subselect.test index 15ccef0e025..154e8d1e627 100644 --- a/mysql-test/suite/pbxt/t/subselect.test +++ b/mysql-test/suite/pbxt/t/subselect.test @@ -925,7 +925,7 @@ drop table t1,t2; # # correct ALL optimisation # -create table t2 (a int, b int); +create table t2 (a int, b int not null); create table t3 (a int); insert into t3 values (6),(7),(3); select * from t3 where a >= all (select b from t2); |