summaryrefslogtreecommitdiff
path: root/mysql-test/t
diff options
context:
space:
mode:
authorunknown <sanja@montyprogram.com>2012-05-22 08:48:10 +0300
committerunknown <sanja@montyprogram.com>2012-05-22 08:48:10 +0300
commit950abd526837b8772044d521387fa6d410de5706 (patch)
treed5deadcf46de5a138088ce2f2dd407dbba094a56 /mysql-test/t
parent280fcf08085e43b5359ec79c0e34166e51b3ebd8 (diff)
downloadmariadb-git-950abd526837b8772044d521387fa6d410de5706.tar.gz
Fix of LP bug#992380 + revise fix_fields about missing with_subselect collection
The problem is that some fix_fields do not call Item_func::fix_fields and do not collect with subselect_information.
Diffstat (limited to 'mysql-test/t')
-rw-r--r--mysql-test/t/func_in.test11
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/t/func_in.test b/mysql-test/t/func_in.test
index dd4194e2a4e..9e054da3fe2 100644
--- a/mysql-test/t/func_in.test
+++ b/mysql-test/t/func_in.test
@@ -576,3 +576,14 @@ DROP TABLE t1;
--echo #
--echo End of 5.1 tests
+
+--echo #
+--echo # LP bug#992380 Crash when creating PS for a query with
+--echo # subquery in WHERE (see also mysql bug#13012483)
+--echo #
+CREATE TABLE t1 (a INT);
+PREPARE s FROM "SELECT 1 FROM t1 WHERE 1 < ALL (SELECT @:= (1 IN (SELECT 1 FROM t1)) FROM t1)";
+EXECUTE s;
+
+DROP TABLE t1;
+