diff options
| author | bell@sanja.is.com.ua <> | 2003-09-10 09:43:30 +0300 |
|---|---|---|
| committer | bell@sanja.is.com.ua <> | 2003-09-10 09:43:30 +0300 |
| commit | 23ad0cfbbb11c7daa38d8991c612c4386cf2934e (patch) | |
| tree | 73c8fe84cf622d5ea736eac353f427d56b828c9c /mysql-test/t/subselect.test | |
| parent | 4b1c22c57e8ba051aa9b435a78c940b2a4cebd8a (diff) | |
| parent | 813d81c72692b1d9512064ccef193aa317a6e627 (diff) | |
| download | mariadb-git-23ad0cfbbb11c7daa38d8991c612c4386cf2934e.tar.gz | |
Merge sanja.is.com.ua:/home/bell/mysql/bk/mysql-4.1
into sanja.is.com.ua:/home/bell/mysql/bk/work-in-4.1
Diffstat (limited to 'mysql-test/t/subselect.test')
| -rw-r--r-- | mysql-test/t/subselect.test | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/t/subselect.test b/mysql-test/t/subselect.test index bd6a4037f3d..304e5939718 100644 --- a/mysql-test/t/subselect.test +++ b/mysql-test/t/subselect.test @@ -934,3 +934,16 @@ select * from t1 where ('a','b')=(select 'a','b' from t1 union select 'a','b' fr explain (select * from t1); (select * from t1); drop table t1; + +# +# IN optimisation test results +# +create table t1 (s1 char(5), index s1(s1)); +create table t2 (s1 char(5), index s1(s1)); +insert into t1 values ('a1'),('a2'),('a3'); +insert into t2 values ('a1'),('a2'); +select s1, s1 NOT IN (SELECT s1 FROM t2) from t1; +select s1, s1 NOT IN (SELECT s1 FROM t2 WHERE s1 < 'a2') from t1; +explain select s1, s1 NOT IN (SELECT s1 FROM t2) from t1; +explain select s1, s1 NOT IN (SELECT s1 FROM t2 WHERE s1 < 'a2') from t1; +drop table t1,t2; |