summaryrefslogtreecommitdiff
path: root/mysql-test/t/subselect.test
diff options
context:
space:
mode:
authorgkodinov/kgeorge@magare.gmz <>2007-05-04 16:37:30 +0300
committergkodinov/kgeorge@magare.gmz <>2007-05-04 16:37:30 +0300
commitee624171ebcab64f40ca92b09f400d7ca5e3747a (patch)
tree6044b00f62117d52ebae6c52fa1ceae2ae7f2c4e /mysql-test/t/subselect.test
parent9bdfe876a9a54040a24c6554a5045f12f166ab5c (diff)
parent287ebed161a18c8a648b70b440a2ef113df5d158 (diff)
downloadmariadb-git-ee624171ebcab64f40ca92b09f400d7ca5e3747a.tar.gz
Merge magare.gmz:/home/kgeorge/mysql/work/B27531-5.0-opt
into magare.gmz:/home/kgeorge/mysql/work/B27531-5.1-opt
Diffstat (limited to 'mysql-test/t/subselect.test')
-rw-r--r--mysql-test/t/subselect.test8
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/t/subselect.test b/mysql-test/t/subselect.test
index 0648c3ebda0..aaeb998d0c7 100644
--- a/mysql-test/t/subselect.test
+++ b/mysql-test/t/subselect.test
@@ -2874,6 +2874,14 @@ FROM t1;
DROP TABLE t1,t2;
+#
+# Bug #27807: Server crash when executing subquery with EXPLAIN
+#
+CREATE TABLE t1 (a int, b int, KEY (a));
+INSERT INTO t1 VALUES (1,1),(2,1);
+EXPLAIN SELECT 1 FROM t1 WHERE a = (SELECT COUNT(*) FROM t1 GROUP BY b);
+DROP TABLE t1;
+
--echo End of 5.0 tests.
#