diff options
| author | Sergey Petrunya <psergey@askmonty.org> | 2012-06-18 22:38:11 +0400 |
|---|---|---|
| committer | Sergey Petrunya <psergey@askmonty.org> | 2012-06-18 22:38:11 +0400 |
| commit | 90fbd8b22b4b84cdc027fed26012efd87c2b6737 (patch) | |
| tree | 48eff1dbe5fd3468e7583d1748de6b5cc8b16c92 /mysql-test/r/func_in.result | |
| parent | db6dbadb5a9edd9e93398b6afe8e3196eb768e0a (diff) | |
| parent | 64aa1fcb1354ffa24999a1512258c897116b0928 (diff) | |
| download | mariadb-git-90fbd8b22b4b84cdc027fed26012efd87c2b6737.tar.gz | |
Merge 5.2->5.3
Diffstat (limited to 'mysql-test/r/func_in.result')
| -rw-r--r-- | mysql-test/r/func_in.result | 13 |
1 files changed, 11 insertions, 2 deletions
diff --git a/mysql-test/r/func_in.result b/mysql-test/r/func_in.result index 91f766468b0..f6d50764cc9 100644 --- a/mysql-test/r/func_in.result +++ b/mysql-test/r/func_in.result @@ -150,8 +150,8 @@ Note 1003 select `test`.`t1`.`a` AS `a`,`test`.`t1`.`b` AS `b`,`test`.`t1`.`c` A drop table t1; set names utf8; create table t1 (a char(10) character set utf8 not null); -insert into t1 values ('bbbb'),(_koi8r'ÃÃÃÃ'),(_latin1'ÄÄÄÄ'); -select a from t1 where a in ('bbbb',_koi8r'ÃÃÃÃ',_latin1'ÄÄÄÄ') order by a; +insert into t1 values ('bbbb'),(_koi8r'ÃÃÃÃ'),(_latin1'ÄÄÄÄ'); +select a from t1 where a in ('bbbb',_koi8r'ÃÃÃÃ',_latin1'ÄÄÄÄ') order by a; a ÄÄÄÄ bbbb @@ -787,6 +787,15 @@ DROP TABLE t1; # End of test BUG#13012483 # End of 5.1 tests +# +# LP bug#992380 Crash when creating PS for a query with +# subquery in WHERE (see also mysql bug#13012483) +# +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; +1 +DROP TABLE t1; create table t1 (a bigint, b int); insert t1 values (1,1),(2,2),(3,3); select * from t1 where a in ('2.1'); |