diff options
| author | unknown <holyfoot/hf@hfmain.(none)> | 2007-03-22 11:50:24 +0400 |
|---|---|---|
| committer | unknown <holyfoot/hf@hfmain.(none)> | 2007-03-22 11:50:24 +0400 |
| commit | bd36057b7870f7122bd718fbe09010026b898170 (patch) | |
| tree | 5fc6f23da9d58b6b18da2d9cb52b7fdb83334fbf /mysql-test/t/func_in.test | |
| parent | 941f2fb956a446d6f0e37581cd71ebdf889d5633 (diff) | |
| parent | a4a23fb907ce7b2c3e998735e074da647b3e9ffc (diff) | |
| download | mariadb-git-bd36057b7870f7122bd718fbe09010026b898170.tar.gz | |
Merge mysql.com:/home/hf/work/mrg/mysql-5.0-opt
into mysql.com:/home/hf/work/mrg/mysql-5.1-opt
mysql-test/r/func_in.result:
Auto merged
mysql-test/t/func_in.test:
Auto merged
sql/item_cmpfunc.cc:
Auto merged
Diffstat (limited to 'mysql-test/t/func_in.test')
| -rw-r--r-- | mysql-test/t/func_in.test | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/t/func_in.test b/mysql-test/t/func_in.test index 31352e4c639..e9583f982ff 100644 --- a/mysql-test/t/func_in.test +++ b/mysql-test/t/func_in.test @@ -361,6 +361,17 @@ SELECT * FROM t4 WHERE a IN ('1972-02-06','19772-07-29'); DROP TABLE t1,t2,t3,t4; +# +# BUG#27362: IN with a decimal expression that may return NULL +# + +CREATE TABLE t1 (id int not null); +INSERT INTO t1 VALUES (1),(2); + +SELECT id FROM t1 WHERE id IN(4564, (SELECT IF(1=0,1,1/0)) ); + +DROP TABLE t1; + --echo End of 5.0 tests |