From 028fa1e454459e0732b00fc4adc1c0fb7fe6632f Mon Sep 17 00:00:00 2001 From: unknown Date: Tue, 20 Jun 2006 00:50:09 +0400 Subject: item_cmpfunc.cc, func_in.result, func_in.test: Reverted fix for bug#18360 mysql-test/t/func_in.test: Reverted fix for bug#18360 mysql-test/r/func_in.result: Reverted fix for bug#18360 sql/item_cmpfunc.cc: Reverted fix for bug#18360 --- mysql-test/t/func_in.test | 12 ------------ 1 file changed, 12 deletions(-) (limited to 'mysql-test/t') diff --git a/mysql-test/t/func_in.test b/mysql-test/t/func_in.test index 3481f2c7b11..2ffe5a2d5f7 100644 --- a/mysql-test/t/func_in.test +++ b/mysql-test/t/func_in.test @@ -109,16 +109,4 @@ select count(*) from t1 where id not in (1); select count(*) from t1 where id not in (1,2); drop table t1; -# -# Bug#18360 Incorrect type coercion in IN() results in false comparison -# -create table t1 (f1 char(1), f2 int); -insert into t1 values (1,0),('a',1),('z',2); -select f1 from t1 where f1 in (1,'z'); -select f2 from t1 where f2 in (1,'z'); -select f1 from t1 where 'z' in (1,f1); -select * from t1 where 'z' in (f2,f1); -select * from t1 where 1 in (f2,f1); -drop table t1; - # End of 4.1 tests -- cgit v1.2.1