diff options
| author | Sergey Petrunya <psergey@askmonty.org> | 2011-03-01 13:21:48 +0300 |
|---|---|---|
| committer | Sergey Petrunya <psergey@askmonty.org> | 2011-03-01 13:21:48 +0300 |
| commit | cb147b39654d3afea938253ed1457c088a5e87c9 (patch) | |
| tree | 854ca74d9bf60c0a120feacde8e3b6951f46bf61 /mysql-test/r/subselect.result | |
| parent | b8f00542e2ed66803d747cc5151279b9edf1392a (diff) | |
| parent | c6ba9598026b06f5d64e7508abb652ac22d50e48 (diff) | |
| download | mariadb-git-cb147b39654d3afea938253ed1457c088a5e87c9.tar.gz | |
Merge 5.3 -> 5.3-subqueries-mwl90
Diffstat (limited to 'mysql-test/r/subselect.result')
| -rw-r--r-- | mysql-test/r/subselect.result | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/r/subselect.result b/mysql-test/r/subselect.result index f0960b7e4e9..64c39a9fddf 100644 --- a/mysql-test/r/subselect.result +++ b/mysql-test/r/subselect.result @@ -4957,6 +4957,17 @@ sum(a) sub 1 3 deallocate prepare stmt1; drop table t1,t2; +# +# Bug LP#693935/#58727: Assertion failure with +# a single row subquery returning more than one row +# +create table t1 (a char(1) charset utf8); +insert into t1 values ('a'), ('b'); +create table t2 (a binary(1)); +insert into t2 values ('x'), ('y'); +select * from t2 where a=(select a from t1) and a='x'; +ERROR 21000: Subquery returns more than 1 row +drop table t1,t2; End of 5.1 tests # # No BUG#, a case brought from 5.2's innodb_mysql_lock.test |