diff options
| author | unknown <evgen@moonbone.local> | 2006-07-11 17:48:33 +0400 |
|---|---|---|
| committer | unknown <evgen@moonbone.local> | 2006-07-11 17:48:33 +0400 |
| commit | bf01313ccf49983adb77b12d564bb8516696cd21 (patch) | |
| tree | 9301e5d8ca1ba62428272f4ea2abf4576752ae24 /mysql-test/t | |
| parent | 7642d18146bc890aad8c2349e342262cbd020c80 (diff) | |
| parent | 7bea031d7c5db395dd70aee2eb1736d3ec891add (diff) | |
| download | mariadb-git-bf01313ccf49983adb77b12d564bb8516696cd21.tar.gz | |
Merge moonbone.local:/work/allany-4.1-mysql
into moonbone.local:/work/16302-bug-4.1-opt-mysql
Diffstat (limited to 'mysql-test/t')
| -rw-r--r-- | mysql-test/t/subselect.test | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/t/subselect.test b/mysql-test/t/subselect.test index cbc7a3afb5f..f7d5e7f8713 100644 --- a/mysql-test/t/subselect.test +++ b/mysql-test/t/subselect.test @@ -1820,4 +1820,14 @@ DROP TABLE t1,t2,t3; purge master logs before (select adddate(current_timestamp(), interval -4 day)); + +# +# Bug#16302: Quantified subquery without any tables gives wrong results +# +select 1 from dual where 1 < any (select 2); +select 1 from dual where 1 < all (select 2); +select 1 from dual where 2 > any (select 1); +select 1 from dual where 2 > all (select 1); +select 1 from dual where 1 < any (select 2 from dual); +select 1 from dual where 1 < all (select 2 from dual where 1!=1); # End of 4.1 tests |