diff options
| author | unknown <evgen@moonbone.local> | 2006-07-12 06:12:59 +0400 |
|---|---|---|
| committer | unknown <evgen@moonbone.local> | 2006-07-12 06:12:59 +0400 |
| commit | e2c448fb5c61812b35fd0a791b5373dbde0abbd7 (patch) | |
| tree | 08076b1afbb104b80cf600160b7d5834c7210f36 /mysql-test | |
| parent | bf01313ccf49983adb77b12d564bb8516696cd21 (diff) | |
| parent | 03dbc2190dd33f7a5bb6b64e9fb153f977820abd (diff) | |
| download | mariadb-git-e2c448fb5c61812b35fd0a791b5373dbde0abbd7.tar.gz | |
Merge epotemkin@bk-internal.mysql.com:/home/bk/mysql-4.1-opt
into moonbone.local:/work/16302-bug-4.1-opt-mysql
mysql-test/r/subselect.result:
SCCS merged
mysql-test/t/subselect.test:
SCCS merged
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/subselect.result | 15 | ||||
| -rw-r--r-- | mysql-test/t/subselect.test | 14 |
2 files changed, 29 insertions, 0 deletions
diff --git a/mysql-test/r/subselect.result b/mysql-test/r/subselect.result index 108f5dd1973..c78f0951469 100644 --- a/mysql-test/r/subselect.result +++ b/mysql-test/r/subselect.result @@ -2835,6 +2835,21 @@ a 4 DROP TABLE t1,t2,t3; purge master logs before (select adddate(current_timestamp(), interval -4 day)); +CREATE TABLE t1 (f1 INT); +CREATE TABLE t2 (f2 INT); +INSERT INTO t1 VALUES (1); +SELECT * FROM t1 WHERE f1 > ALL (SELECT f2 FROM t2); +f1 +1 +SELECT * FROM t1 WHERE f1 > ALL (SELECT f2 FROM t2 WHERE 1=0); +f1 +1 +INSERT INTO t2 VALUES (1); +INSERT INTO t2 VALUES (2); +SELECT * FROM t1 WHERE f1 > ALL (SELECT f2 FROM t2 WHERE f2=0); +f1 +1 +DROP TABLE t1, t2; select 1 from dual where 1 < any (select 2); 1 1 diff --git a/mysql-test/t/subselect.test b/mysql-test/t/subselect.test index f7d5e7f8713..e01310bba45 100644 --- a/mysql-test/t/subselect.test +++ b/mysql-test/t/subselect.test @@ -1822,6 +1822,20 @@ purge master logs before (select adddate(current_timestamp(), interval -4 day)); # +# Bug#18503: Queries with a quantified subquery returning empty set may +# return a wrong result. +# +CREATE TABLE t1 (f1 INT); +CREATE TABLE t2 (f2 INT); +INSERT INTO t1 VALUES (1); +SELECT * FROM t1 WHERE f1 > ALL (SELECT f2 FROM t2); +SELECT * FROM t1 WHERE f1 > ALL (SELECT f2 FROM t2 WHERE 1=0); +INSERT INTO t2 VALUES (1); +INSERT INTO t2 VALUES (2); +SELECT * FROM t1 WHERE f1 > ALL (SELECT f2 FROM t2 WHERE f2=0); +DROP TABLE t1, t2; + +# # Bug#16302: Quantified subquery without any tables gives wrong results # select 1 from dual where 1 < any (select 2); |