diff options
| author | Sergey Glukhov <Sergey.Glukhov@sun.com> | 2009-03-19 13:26:12 +0400 |
|---|---|---|
| committer | Sergey Glukhov <Sergey.Glukhov@sun.com> | 2009-03-19 13:26:12 +0400 |
| commit | 2ea2cc02c3f0c0988ef7a24301b6bc629733bc6f (patch) | |
| tree | 02b8513d0af1912779f5afeb1da9c478c484d942 /mysql-test/t | |
| parent | 5c49e6ebb38467d0fd6fc65bbeb1eecbe13f2f70 (diff) | |
| parent | 173ea364c8c25fd960aa079c40f165ab0834c23d (diff) | |
| download | mariadb-git-2ea2cc02c3f0c0988ef7a24301b6bc629733bc6f.tar.gz | |
5.0-bugteam->5.1-bugteam merge
Diffstat (limited to 'mysql-test/t')
| -rw-r--r-- | mysql-test/t/ctype_collate.test | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/t/ctype_collate.test b/mysql-test/t/ctype_collate.test index cfef8dfe81a..6b6abbcfbcc 100644 --- a/mysql-test/t/ctype_collate.test +++ b/mysql-test/t/ctype_collate.test @@ -229,3 +229,17 @@ insert into t1 set a=0x6c; insert into t1 set a=0x4c98; check table t1 extended; drop table t1; + +# +# Bug#41627 Illegal mix of collations in LEAST / GREATEST / CASE +# +select least(_latin1'a',_latin2'b',_latin5'c' collate latin5_turkish_ci); +create table t1 +select least(_latin1'a',_latin2'b',_latin5'c' collate latin5_turkish_ci) as f1; +show create table t1; +drop table t1; + +select case _latin1'a' when _latin2'b' then 1 when _latin5'c' collate +latin5_turkish_ci then 2 else 3 end; + +select concat(_latin1'a',_latin2'b',_latin5'c' collate latin5_turkish_ci); |