From 950abd526837b8772044d521387fa6d410de5706 Mon Sep 17 00:00:00 2001 From: unknown Date: Tue, 22 May 2012 08:48:10 +0300 Subject: 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. --- mysql-test/t/func_in.test | 11 +++++++++++ 1 file changed, 11 insertions(+) (limited to 'mysql-test/t/func_in.test') 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; + -- cgit v1.2.1