diff options
| author | unknown <gkodinov/kgeorge@magare.gmz> | 2008-05-05 15:04:26 +0300 |
|---|---|---|
| committer | unknown <gkodinov/kgeorge@magare.gmz> | 2008-05-05 15:04:26 +0300 |
| commit | cd865e657d16b8bc156e6341f1a280eee6c19a96 (patch) | |
| tree | abf659f1b97fe897ad06ffd82541140d3bd894de /mysql-test/t/subselect3.test | |
| parent | 8bce58d6b78ba79f2e37003ae6a91b191bc782d7 (diff) | |
| parent | 369e58ff62df115d7fad11cb8bd7c002422b4741 (diff) | |
| download | mariadb-git-cd865e657d16b8bc156e6341f1a280eee6c19a96.tar.gz | |
Merge bk-internal:/home/bk/mysql-5.0
into magare.gmz:/home/kgeorge/mysql/work/merge-5.0-bugteam
mysql-test/mysql-test-run.pl:
Auto merged
Diffstat (limited to 'mysql-test/t/subselect3.test')
| -rw-r--r-- | mysql-test/t/subselect3.test | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/t/subselect3.test b/mysql-test/t/subselect3.test index cfbde8c29cd..d7bb1f7186a 100644 --- a/mysql-test/t/subselect3.test +++ b/mysql-test/t/subselect3.test @@ -605,4 +605,17 @@ SELECT ROW(1, 2) IN (SELECT t1.a, 2 FROM t2) FROM t1 GROUP BY t1.a; DROP TABLE t1, t2; +# +# Bug #36005: crash in subselect with single row +# (subselect_single_select_engine::exec) +# + +CREATE TABLE t1 (a INT); +INSERT INTO t1 VALUES (1),(2),(3); +CREATE TABLE t2 SELECT * FROM t1; + +SELECT 1 FROM t1 WHERE t1.a NOT IN (SELECT 1 FROM t1, t2 WHERE 0); + +DROP TABLE t1, t2; + --echo End of 5.0 tests |