diff options
Diffstat (limited to 'mysql-test/r/func_in.result')
| -rw-r--r-- | mysql-test/r/func_in.result | 17 |
1 files changed, 2 insertions, 15 deletions
diff --git a/mysql-test/r/func_in.result b/mysql-test/r/func_in.result index 650f103710d..2c20b77a7c4 100644 --- a/mysql-test/r/func_in.result +++ b/mysql-test/r/func_in.result @@ -469,6 +469,8 @@ SELECT HEX(a) FROM t2 WHERE a IN HEX(a) 7FFFFFFFFFFFFFFE 7FFFFFFFFFFFFFFF +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: 'abc' CREATE TABLE t3 (a BIGINT UNSIGNED); INSERT INTO t3 VALUES (9223372036854775551); SELECT HEX(a) FROM t3 WHERE a IN (9223372036854775807, 42); @@ -777,18 +779,3 @@ SELECT 1 IN (YEAR(FROM_UNIXTIME(NULL)) ,1); 1 # End of 5.1 tests -create table t1 (a bigint, b int); -insert t1 values (1,1),(2,2),(3,3); -select * from t1 where a in ('2.1'); -a b -2 2 -select * from t1 where b in ('2.1'); -a b -select * from t1 where a='2.1'; -a b -2 2 -select * from t1 where b='2.1'; -a b -select * from t1 where IF(1,a,a)='2.1'; -a b -drop table t1; |