diff options
| author | unknown <kroki/tomash@moonlight.intranet> | 2006-11-16 14:15:56 +0300 |
|---|---|---|
| committer | unknown <kroki/tomash@moonlight.intranet> | 2006-11-16 14:15:56 +0300 |
| commit | db336c0544f76ffe322d6f747a4627d7f9d790a6 (patch) | |
| tree | 887655dd59d97090c63cd7d4e3466b7b63a66918 /mysql-test/r | |
| parent | c6d317831ab8ccbef3685a5f03ca8c2cfa4d92f0 (diff) | |
| parent | e40e8052e89ada24a79c827cf38271beed756759 (diff) | |
| download | mariadb-git-db336c0544f76ffe322d6f747a4627d7f9d790a6.tar.gz | |
Merge moonlight.intranet:/home/tomash/src/mysql_ab/mysql-4.1-runtime
into moonlight.intranet:/home/tomash/src/mysql_ab/mysql-4.1-bug17047
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/func_in.result | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/r/func_in.result b/mysql-test/r/func_in.result index 3cf2afc83d1..f74c63f7260 100644 --- a/mysql-test/r/func_in.result +++ b/mysql-test/r/func_in.result @@ -202,3 +202,11 @@ select count(*) from t1 where id not in (1,2); count(*) 1 drop table t1; +DROP TABLE IF EXISTS t1; +CREATE TABLE t1 SELECT 1 IN (2, NULL); +SELECT should return NULL. +SELECT * FROM t1; +1 IN (2, NULL) +NULL +DROP TABLE t1; +End of 4.1 tests |