diff options
| author | unknown <timour@askmonty.org> | 2012-02-09 23:35:26 +0200 |
|---|---|---|
| committer | unknown <timour@askmonty.org> | 2012-02-09 23:35:26 +0200 |
| commit | f6cdddf51f385fd7dd9afe286f3bdce0b7e59f60 (patch) | |
| tree | 422751c28f35fe532a5f9df281c8d127bc8dca35 /mysql-test/r/subselect.result | |
| parent | 3efc8d016f1e1fbc854a4698e1d06aba5fa2ec15 (diff) | |
| download | mariadb-git-f6cdddf51f385fd7dd9afe286f3bdce0b7e59f60.tar.gz | |
Test case for bug lp:905353
The bug itself is fixed by the patch for bug lp:908269.
Diffstat (limited to 'mysql-test/r/subselect.result')
| -rw-r--r-- | mysql-test/r/subselect.result | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/r/subselect.result b/mysql-test/r/subselect.result index 47dcafc663b..bca4eb677de 100644 --- a/mysql-test/r/subselect.result +++ b/mysql-test/r/subselect.result @@ -5994,5 +5994,14 @@ SELECT ( SELECT b FROM t2 WHERE b = a OR rand() * 0) FROM t1; 1 NULL drop table t1,t2,t3; +# +# LP BUG#905353 Wrong non-empty result with a constant table, +# aggregate function in subquery, MyISAM or Aria +# +CREATE TABLE t1 ( a INT ) ENGINE=MyISAM; +INSERT INTO t1 VALUES (1); +SELECT a FROM t1 WHERE ( SELECT MIN(a) = 100 ); +a +drop table t1; # return optimizer switch changed in the beginning of this test set optimizer_switch=@subselect_tmp; |