diff options
| author | bar@mysql.com <> | 2005-01-20 15:38:56 +0400 |
|---|---|---|
| committer | bar@mysql.com <> | 2005-01-20 15:38:56 +0400 |
| commit | ca48cfbfccf2638afe9807094161051285302fd9 (patch) | |
| tree | cdb60e795cd9012e9e9014065737caded748a072 /mysql-test/t/func_in.test | |
| parent | 187dce645bb4cdb1f511f58c104bdd7f28290b6b (diff) | |
| download | mariadb-git-ca48cfbfccf2638afe9807094161051285302fd9.tar.gz | |
item_cmpfunc.cc:
Bug#7834 Illegal mix of collations in IN operator
IN was the first function supporting
character set convertion.
agg_arg_charsets() was written afterwards,
which is more flexible.
Now IN just reuses this function.
Diffstat (limited to 'mysql-test/t/func_in.test')
| -rw-r--r-- | mysql-test/t/func_in.test | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/t/func_in.test b/mysql-test/t/func_in.test index 3cd8c064817..6e0883b821f 100644 --- a/mysql-test/t/func_in.test +++ b/mysql-test/t/func_in.test @@ -80,6 +80,11 @@ 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; drop table t1; +# Bug#7834 Illegal mix of collations in IN operator +create table t1 (a char(10) character set latin1 not null); +insert into t1 values ('a'),('b'),('c'); +select a from t1 where a IN ('a','b','c') order by a; +drop table t1; set names latin1; select '1.0' in (1,2); |