summaryrefslogtreecommitdiff
path: root/mysql-test/r/func_in.result
diff options
context:
space:
mode:
authorunknown <holyfoot/hf@hfmain.(none)>2007-03-22 11:50:24 +0400
committerunknown <holyfoot/hf@hfmain.(none)>2007-03-22 11:50:24 +0400
commit27a65dbe6c2e286e9e604456eec4886b4db6966e (patch)
tree5fc6f23da9d58b6b18da2d9cb52b7fdb83334fbf /mysql-test/r/func_in.result
parenteb7ab8f939dcb1bb10f6258732b133bcaeecca89 (diff)
parent3e950bbaab951dda753a0731e41fff7f90e1c52f (diff)
downloadmariadb-git-27a65dbe6c2e286e9e604456eec4886b4db6966e.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/r/func_in.result')
-rw-r--r--mysql-test/r/func_in.result5
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/r/func_in.result b/mysql-test/r/func_in.result
index 7a8f59c65f4..992d1cd418b 100644
--- a/mysql-test/r/func_in.result
+++ b/mysql-test/r/func_in.result
@@ -477,6 +477,11 @@ a
Warnings:
Warning 1292 Incorrect date value: '19772-07-29' for column 'a' at row 1
DROP TABLE t1,t2,t3,t4;
+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)) );
+id
+DROP TABLE t1;
End of 5.0 tests
create table t1(f1 char(1));
insert into t1 values ('a'),('b'),('1');