diff options
| author | unknown <gshchepa/uchum@host.loc> | 2008-04-23 11:06:26 +0500 |
|---|---|---|
| committer | unknown <gshchepa/uchum@host.loc> | 2008-04-23 11:06:26 +0500 |
| commit | e3ed2f88bd59876f5df876cc2889c8cb20888a94 (patch) | |
| tree | a2ecc8aded425fd30407dc717fe1b6a7e4ffa81b /mysql-test/r/subselect3.result | |
| parent | 6b4179ec5b0e3015076b1b492e73abe6499b6d4d (diff) | |
| parent | c2d1ac6e2cb8c393a229399de28f2793a9007d59 (diff) | |
| download | mariadb-git-e3ed2f88bd59876f5df876cc2889c8cb20888a94.tar.gz | |
Merge host.loc:/home/uchum/work/5.0-bugteam
into host.loc:/home/uchum/work/5.1-bugteam
mysql-test/r/ctype_gbk.result:
Auto merged
mysql-test/r/subselect3.result:
Auto merged
mysql-test/t/subselect3.test:
Auto merged
sql/sql_select.cc:
Auto merged
strings/ctype-big5.c:
Merge with 5.0-bugteam (bug#35993).
strings/ctype-gbk.c:
Merge with 5.0-bugteam (bug#35993).
Diffstat (limited to 'mysql-test/r/subselect3.result')
| -rw-r--r-- | mysql-test/r/subselect3.result | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/r/subselect3.result b/mysql-test/r/subselect3.result index 89cc3626aa9..5f8aa2f1767 100644 --- a/mysql-test/r/subselect3.result +++ b/mysql-test/r/subselect3.result @@ -770,4 +770,13 @@ SELECT ROW(1, 2) IN (SELECT t1.a, 2 FROM t2) FROM t1 GROUP BY t1.a; ROW(1, 2) IN (SELECT t1.a, 2 FROM t2) 1 DROP TABLE t1, t2; +CREATE TABLE t1 (a INT); +INSERT INTO t1 VALUES (1),(2),(3); +CREATE TABLE t2 SELECT * FROM t1; +SELECT 1 FROM t1 WHERE t1.a NOT IN (SELECT 1 FROM t1, t2 WHERE 0); +1 +1 +1 +1 +DROP TABLE t1, t2; End of 5.0 tests |