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/r/func_in.result | |
parent | f4e07b861e886db5893f92238fba20346262c06b (diff) | |
download | mariadb-git-687863c093f0f01f54770b10fdd40f554e21a6f8.tar.gz |
IN now aggregates all argument types for comparison
Diffstat (limited to 'mysql-test/r/func_in.result')
-rw-r--r-- | mysql-test/r/func_in.result | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/mysql-test/r/func_in.result b/mysql-test/r/func_in.result index 4b15c44fdb1..a197371b345 100644 --- a/mysql-test/r/func_in.result +++ b/mysql-test/r/func_in.result @@ -143,3 +143,24 @@ select * from t1 where 'a' in (a,b,c collate latin1_bin); a b c a c c drop table t1; +select '1.0' in (1,2); +'1.0' in (1,2) +1 +select 1 in ('1.0',2); +1 in ('1.0',2) +1 +select 1 in (1,'2.0'); +1 in (1,'2.0') +1 +select 1 in ('1.0',2.0); +1 in ('1.0',2.0) +1 +select 1 in (1.0,'2.0'); +1 in (1.0,'2.0') +1 +select 1 in ('1.1',2); +1 in ('1.1',2) +0 +select 1 in ('1.1',2.0); +1 in ('1.1',2.0) +0 |