diff options
| author | unknown <evgen@moonbone.local> | 2006-05-30 19:16:30 +0400 |
|---|---|---|
| committer | unknown <evgen@moonbone.local> | 2006-05-30 19:16:30 +0400 |
| commit | 7b639f05f8916537bf3d6e36c7e07b2e80be8f49 (patch) | |
| tree | 124637154b2ebae6aa7b8032d151173f289dedb0 /mysql-test/t/func_in.test | |
| parent | c56193330101e6dfeb6afd43f76553aae8a3929e (diff) | |
| parent | a9824f263dcaedaabfbbc9e398eb55117f19a41f (diff) | |
| download | mariadb-git-7b639f05f8916537bf3d6e36c7e07b2e80be8f49.tar.gz | |
Manually merged
mysql-test/t/func_in.test:
Auto merged
Diffstat (limited to 'mysql-test/t/func_in.test')
| -rw-r--r-- | mysql-test/t/func_in.test | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/t/func_in.test b/mysql-test/t/func_in.test index 8ddf1fbe314..5a5e3ec798d 100644 --- a/mysql-test/t/func_in.test +++ b/mysql-test/t/func_in.test @@ -109,6 +109,18 @@ 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 # |