diff options
Diffstat (limited to 'mysql-test/t/func_in.test')
| -rw-r--r-- | mysql-test/t/func_in.test | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/t/func_in.test b/mysql-test/t/func_in.test new file mode 100644 index 00000000000..6830534e761 --- /dev/null +++ b/mysql-test/t/func_in.test @@ -0,0 +1,19 @@ +# +# test of IN (NULL) +# + +CREATE TABLE t1 (field char(1)); +INSERT INTO t1 VALUES ('A'),(NULL); +SELECT * from t1 WHERE field IN (NULL); +SELECT * from t1 WHERE field NOT IN (NULL); +SELECT * from t1 where field = field; +SELECT * from t1 where field <=> field; +DELETE FROM t1 WHERE field NOT IN (NULL); +SELECT * FROM t1; +drop table t1; + +create table t1 (id int(10) primary key); +insert into t1 values (1),(2),(3),(4),(5),(6),(7),(8),(9); +select * from t1 where id in (2,5,9); +drop table t1; + |