merge with mysql-5.5.21

1 files changed, 0 insertions, 19 deletions

diff --git a/mysql-test/t/func_in.test b/mysql-test/t/func_in.test
index febec62f037..9e6628a1972 100644
--- a/mysql-test/t/func_in.test
+++ b/mysql-test/t/func_in.test
@@ -564,22 +564,3 @@ SELECT 1 IN (YEAR(FROM_UNIXTIME(NULL)) ,1);
 
 --echo End of 5.1 tests
 
-#
-# lp:817966 int_column IN (string_constant)
-#
-# rather illogically, when BIGINT field is compared to a string,
-# the string is converted to an integer, not to a double.
-# When some other integer field (not BIGINT) is compared to a string,
-# or when the BIGINT is not a field, but an expression, both
-# operands are compared as doubles. The latter behavior is correct,
-# according to the manual.
-#
-create table t1 (a bigint, b int);
-insert t1 values (1,1),(2,2),(3,3);
-select * from t1 where a in ('2.1');
-select * from t1 where b in ('2.1');
-select * from t1 where a='2.1'; 
-select * from t1 where b='2.1'; 
-select * from t1 where IF(1,a,a)='2.1'; 
-drop table t1;
-