diff options
| author | unknown <kroki/tomash@moonlight.intranet> | 2006-11-16 14:13:03 +0300 |
|---|---|---|
| committer | unknown <kroki/tomash@moonlight.intranet> | 2006-11-16 14:13:03 +0300 |
| commit | 8c4a12a40f902d8c62471b4a408c0fbe9b959959 (patch) | |
| tree | ef824e40692b4feb07161bc9d403ccf6b01d03a0 /mysql-test/r/func_in.result | |
| parent | 299d6d9af6e40013c5be6238fd88445ba3b08d79 (diff) | |
| parent | dd558e31267a671b80447c6d5353a8f6fd90b274 (diff) | |
| download | mariadb-git-8c4a12a40f902d8c62471b4a408c0fbe9b959959.tar.gz | |
Merge moonlight.intranet:/home/tomash/src/mysql_ab/mysql-5.0-bug17047
into moonlight.intranet:/home/tomash/src/mysql_ab/mysql-5.1-bug17047
sql/item_cmpfunc.cc:
Auto merged
sql/item_strfunc.cc:
Auto merged
sql/item_strfunc.h:
Auto merged
mysql-test/r/func_in.result:
Manual merge. Add "End of <version> tests" marker.
mysql-test/r/func_str.result:
Manual merge. Add "End of <version> tests" marker.
mysql-test/t/func_in.test:
Manual merge. Add "End of <version> tests" marker.
mysql-test/t/func_str.test:
Manual merge. Add "End of <version> tests" marker.
Diffstat (limited to 'mysql-test/r/func_in.result')
| -rw-r--r-- | mysql-test/r/func_in.result | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/r/func_in.result b/mysql-test/r/func_in.result index b88e5a66f96..6578af7cd8b 100644 --- a/mysql-test/r/func_in.result +++ b/mysql-test/r/func_in.result @@ -202,6 +202,14 @@ 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 CREATE TABLE t1 (a int PRIMARY KEY); INSERT INTO t1 VALUES (44), (45), (46); SELECT * FROM t1 WHERE a IN (45); @@ -343,6 +351,7 @@ some_id 1 2 drop table t1; +End of 5.0 tests create table t1(f1 char(1)); insert into t1 values ('a'),('b'),('1'); select f1 from t1 where f1 in ('a',1); @@ -411,3 +420,4 @@ explain select f2 from t2 where f2 in (1,'b'); id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t2 index NULL t2f2 5 NULL 3 Using where; Using index drop table t1, t2; +End of 5.1 tests |