diff options
| author | unknown <bar@bar.mysql.r18.ru> | 2003-07-18 14:03:54 +0500 |
|---|---|---|
| committer | unknown <bar@bar.mysql.r18.ru> | 2003-07-18 14:03:54 +0500 |
| commit | 687863c093f0f01f54770b10fdd40f554e21a6f8 (patch) | |
| tree | 5e29655e80bb3c7b7c170462c2e9ceece6dfc18c /mysql-test/t/func_in.test | |
| parent | f4e07b861e886db5893f92238fba20346262c06b (diff) | |
| download | mariadb-git-687863c093f0f01f54770b10fdd40f554e21a6f8.tar.gz | |
IN now aggregates all argument types for comparison
Diffstat (limited to 'mysql-test/t/func_in.test')
| -rw-r--r-- | mysql-test/t/func_in.test | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/t/func_in.test b/mysql-test/t/func_in.test index dca068f368a..105612bf238 100644 --- a/mysql-test/t/func_in.test +++ b/mysql-test/t/func_in.test @@ -73,3 +73,11 @@ select * from t1 where 'a' collate latin1_general_ci in (a,b,c); select * from t1 where 'a' collate latin1_bin in (a,b,c); select * from t1 where 'a' in (a,b,c collate latin1_bin); drop table t1; + +select '1.0' in (1,2); +select 1 in ('1.0',2); +select 1 in (1,'2.0'); +select 1 in ('1.0',2.0); +select 1 in (1.0,'2.0'); +select 1 in ('1.1',2); +select 1 in ('1.1',2.0); |