summaryrefslogtreecommitdiff
path: root/mysql-test/t/subselect.test
diff options
context:
space:
mode:
authorgkodinov/kgeorge@magare.gmz <>2007-05-04 10:57:14 +0300
committergkodinov/kgeorge@magare.gmz <>2007-05-04 10:57:14 +0300
commit27624ee4e8bb720534f85cd331dcbe0520128e6e (patch)
tree4ce958e6ff6f3d0cbac9a4870233fcf80ea461bf /mysql-test/t/subselect.test
parent1a0cf6db7ca901547c667ac3d2d3c11db28a8eec (diff)
parent6badb08ce30c7b96714e7df91b8d7cf008a7bbb9 (diff)
downloadmariadb-git-27624ee4e8bb720534f85cd331dcbe0520128e6e.tar.gz
Merge gkodinov@bk-internal.mysql.com:/home/bk/mysql-5.0-opt
into magare.gmz:/home/kgeorge/mysql/autopush/B27807-5.0-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 5cd2cd5fa7d..64de2ada93c 100644
--- a/mysql-test/t/subselect.test
+++ b/mysql-test/t/subselect.test
@@ -2874,4 +2874,12 @@ 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.