diff options
| author | unknown <gkodinov/kgeorge@magare.gmz> | 2007-05-21 10:21:55 +0300 |
|---|---|---|
| committer | unknown <gkodinov/kgeorge@magare.gmz> | 2007-05-21 10:21:55 +0300 |
| commit | 330a82f0663d7079aab924dcdb12a37a27ecc750 (patch) | |
| tree | d9360beced4f5bfb397f6cb9bfad7678db6c2193 /mysql-test/t/subselect3.test | |
| parent | 59a7e066e3a86bb4371ce5027b4ad6b79ac91ce2 (diff) | |
| parent | 455352b0b892252fdb060a1da71bd008da36f4ac (diff) | |
| download | mariadb-git-330a82f0663d7079aab924dcdb12a37a27ecc750.tar.gz | |
Merge macbook:mysql/work/B22855-5.0-opt
into magare.gmz:/home/kgeorge/mysql/work/B22855-5.0-opt
sql/item_subselect.cc:
Auto merged
mysql-test/r/subselect3.result:
manual merge
mysql-test/t/subselect3.test:
manual merge
Diffstat (limited to 'mysql-test/t/subselect3.test')
| -rw-r--r-- | mysql-test/t/subselect3.test | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/mysql-test/t/subselect3.test b/mysql-test/t/subselect3.test index 65556012588..0302e2cede6 100644 --- a/mysql-test/t/subselect3.test +++ b/mysql-test/t/subselect3.test @@ -571,3 +571,21 @@ SELECT (t1.id IN (SELECT t2.id FROM t2,t3 FROM t1; DROP TABLE t1,t2,t3; + +# +# Bug #22855: Optimizer doesn't rewrite NOT IN subselects to a correlated +# subquery +# +CREATE TABLE t1 (a INT NOT NULL); +INSERT INTO t1 VALUES (1),(-1), (65),(66); + +CREATE TABLE t2 (a INT UNSIGNED NOT NULL PRIMARY KEY); +INSERT INTO t2 VALUES (65),(66); + +SELECT a FROM t1 WHERE a NOT IN (65,66); +SELECT a FROM t1 WHERE a NOT IN (SELECT a FROM t2); +EXPLAIN SELECT a FROM t1 WHERE a NOT IN (SELECT a FROM t2); + +DROP TABLE t1; + +--echo End of 5.0 tests |