diff options
| author | unknown <bar@mysql.com> | 2004-09-01 15:39:15 +0500 |
|---|---|---|
| committer | unknown <bar@mysql.com> | 2004-09-01 15:39:15 +0500 |
| commit | 94ecacdb97b97c74aae3eeb29965b80be28ac020 (patch) | |
| tree | 77ebcecccdab54d0eed739c08f6404be23bc1aff /mysql-test/r/func_in.result | |
| parent | 705d50660de96fd7d20d585348ace0d2eb512baf (diff) | |
| download | mariadb-git-94ecacdb97b97c74aae3eeb29965b80be28ac020.tar.gz | |
Allow IN to convert arguments into Unicode in some cases.
Diffstat (limited to 'mysql-test/r/func_in.result')
| -rw-r--r-- | mysql-test/r/func_in.result | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/r/func_in.result b/mysql-test/r/func_in.result index f66b3dea94b..374affce8c5 100644 --- a/mysql-test/r/func_in.result +++ b/mysql-test/r/func_in.result @@ -148,6 +148,16 @@ id select_type table type possible_keys key key_len ref rows Extra Warnings: Note 1003 select test.t1.a AS `a`,test.t1.b AS `b`,test.t1.c AS `c` from test.t1 where (_latin1'a' in (test.t1.a,test.t1.b,(test.t1.c collate _latin1'latin1_bin'))) drop table t1; +set names utf8; +create table t1 (a char(10) character set utf8 not null); +insert into t1 values ('bbbb'),(_koi8r'ÃÃÃÃ'),(_latin1'ÄÄÄÄ'); +select a from t1 where a in ('bbbb',_koi8r'ÃÃÃÃ',_latin1'ÄÄÄÄ') order by a; +a +ÄÄÄÄ +bbbb +цццц +drop table t1; +set names latin1; select '1.0' in (1,2); '1.0' in (1,2) 1 |