diff options
| author | unknown <gkodinov/kgeorge@magare.gmz> | 2008-05-16 19:03:50 +0300 |
|---|---|---|
| committer | unknown <gkodinov/kgeorge@magare.gmz> | 2008-05-16 19:03:50 +0300 |
| commit | 277e783d13cd928d93e19ef16a91f352fde43868 (patch) | |
| tree | f497d0113e8f33b049afe24b7ecc567a85135711 /mysql-test/t/subselect.test | |
| parent | db84d00029b436994cc2a61dd88e7a65f941ef88 (diff) | |
| parent | 0fb1527e9556940d30ab14b11742c03510db081d (diff) | |
| download | mariadb-git-277e783d13cd928d93e19ef16a91f352fde43868.tar.gz | |
Merge magare.gmz:/home/kgeorge/mysql/work/B36011-take2-5.0-bugteam
into magare.gmz:/home/kgeorge/mysql/work/B36011-5.1-bugteam
sql/sql_select.cc:
Auto merged
mysql-test/r/subselect.result:
merge of bug 36011 to 5.1-bugteam
mysql-test/t/subselect.test:
merge of bug 36011 to 5.1-bugteam
Diffstat (limited to 'mysql-test/t/subselect.test')
| -rw-r--r-- | mysql-test/t/subselect.test | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/t/subselect.test b/mysql-test/t/subselect.test index 9808f2de011..ee3a7428d4a 100644 --- a/mysql-test/t/subselect.test +++ b/mysql-test/t/subselect.test @@ -3225,6 +3225,18 @@ select t1.a from t1 where drop table t1, t2; + +# +# Bug #36011: Server crash with explain extended on query with dependent +# subqueries +# + +CREATE TABLE t1 (a INT); +INSERT INTO t1 VALUES (1),(2); +EXPLAIN EXTENDED SELECT 1 FROM t1 WHERE 1 IN (SELECT 1 FROM t1 GROUP BY a); +EXPLAIN EXTENDED SELECT 1 FROM t1 WHERE 1 IN (SELECT 1 FROM t1 WHERE a > 3 GROUP BY a); +DROP TABLE t1; + --echo End of 5.0 tests. # |