diff options
| author | unknown <igor@rurik.mysql.com> | 2005-08-08 16:55:29 -0700 |
|---|---|---|
| committer | unknown <igor@rurik.mysql.com> | 2005-08-08 16:55:29 -0700 |
| commit | 310bb7e2da86482c5ead49fee19ccb306158a7fb (patch) | |
| tree | 829975c5b480cb151ccb40e9ea4534e2bd79162e /mysql-test/t/subselect.test | |
| parent | e6ed39b405fdbb6a83c587b7b79d5725e37ede8d (diff) | |
| parent | 6f0a6260976712e6b9c828ebb120165540c14935 (diff) | |
| download | mariadb-git-310bb7e2da86482c5ead49fee19ccb306158a7fb.tar.gz | |
Merge rurik.mysql.com:/home/igor/mysql-4.1
into rurik.mysql.com:/home/igor/dev/mysql-4.1-0
mysql-test/r/subselect.result:
Auto merged
mysql-test/t/subselect.test:
Auto merged
Diffstat (limited to 'mysql-test/t/subselect.test')
| -rw-r--r-- | mysql-test/t/subselect.test | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/t/subselect.test b/mysql-test/t/subselect.test index ecd553ee8f8..1b7e01627cd 100644 --- a/mysql-test/t/subselect.test +++ b/mysql-test/t/subselect.test @@ -1774,4 +1774,15 @@ SELECT one,two,ROW(one,two) IN (SELECT one,two FROM t2 WHERE flag = 'N' group by DROP TABLE t1,t2; +# +# Bug #12392: where cond with IN predicate for rows and NULL values in table +# + +CREATE TABLE t1 (a char(5), b char(5)); +INSERT INTO t1 VALUES (NULL,'aaa'), ('aaa','aaa'); + +SELECT * FROM t1 WHERE (a,b) IN (('aaa','aaa'), ('aaa','bbb')); + +DROP TABLE t1; + # End of 4.1 tests |