diff options
| author | unknown <igor@rurik.mysql.com> | 2005-08-15 21:58:17 -0700 |
|---|---|---|
| committer | unknown <igor@rurik.mysql.com> | 2005-08-15 21:58:17 -0700 |
| commit | 5082c41bf3ae5668d28132e912574a42cbe18ccb (patch) | |
| tree | 834a2aa03ea5d0bfdbb5fffcde55d504cbb94ca3 /mysql-test/r/subselect.result | |
| parent | c78623fa10bfb8d0716c2a77a85be651fdd33996 (diff) | |
| parent | 4161d7cb0d5394dfca0f56aef7e189c0d1f6f8fd (diff) | |
| download | mariadb-git-5082c41bf3ae5668d28132e912574a42cbe18ccb.tar.gz | |
Manual merge
Diffstat (limited to 'mysql-test/r/subselect.result')
| -rw-r--r-- | mysql-test/r/subselect.result | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/r/subselect.result b/mysql-test/r/subselect.result index 6c05ce10592..bbfdeb970a6 100644 --- a/mysql-test/r/subselect.result +++ b/mysql-test/r/subselect.result @@ -2829,6 +2829,23 @@ SELECT * FROM t1 WHERE (a,b) IN (('aaa','aaa'), ('aaa','bbb')); a b aaa aaa DROP TABLE t1; +CREATE TABLE t1 (a int); +CREATE TABLE t2 (a int, b int); +CREATE TABLE t3 (b int NOT NULL); +INSERT INTO t1 VALUES (1), (2), (3), (4); +INSERT INTO t2 VALUES (1,10), (3,30); +SELECT * FROM t2 LEFT JOIN t3 ON t2.b=t3.b +WHERE t3.b IS NOT NULL OR t2.a > 10; +a b b +SELECT * FROM t1 +WHERE t1.a NOT IN (SELECT a FROM t2 LEFT JOIN t3 ON t2.b=t3.b +WHERE t3.b IS NOT NULL OR t2.a > 10); +a +1 +2 +3 +4 +DROP TABLE t1,t2,t3; create table t1 (df decimal(5,1)); insert into t1 values(1.1); insert into t1 values(2.2); |