diff options
Diffstat (limited to 'mysql-test/main/func_in.test')
| -rw-r--r-- | mysql-test/main/func_in.test | 11 |
1 files changed, 1 insertions, 10 deletions
diff --git a/mysql-test/main/func_in.test b/mysql-test/main/func_in.test index fb6f2036f20..86a54535a8b 100644 --- a/mysql-test/main/func_in.test +++ b/mysql-test/main/func_in.test @@ -567,7 +567,7 @@ SELECT 1 IN (YEAR(FROM_UNIXTIME(NULL)) ,1); --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)"; +PREPARE s FROM "SELECT 1 FROM t1 WHERE 1 < ALL (SELECT @a:= (1 IN (SELECT 1 FROM t1)) FROM t1)"; EXECUTE s; DROP TABLE t1; @@ -595,15 +595,6 @@ select * from t1 where a='2.1'; select * from t1 where b='2.1'; select * from t1 where IF(1,a,a)='2.1'; drop table t1; ---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; --echo # --echo # End of 5.3 tests |