diff options
author | unknown <bar@noter.(none)> | 2005-05-06 18:41:41 +0500 |
---|---|---|
committer | unknown <bar@noter.(none)> | 2005-05-06 18:41:41 +0500 |
commit | cdbf4939975a579179c3cdeb744416841d5416af (patch) | |
tree | 3e01a5860e7b6f1f9e61060e48e8131893813dcc /mysql-test/t/ctype_latin2.test | |
parent | 0efb151d46c6157f5dd26e7b048bc635c5b1cfb4 (diff) | |
download | mariadb-git-cdbf4939975a579179c3cdeb744416841d5416af.tar.gz |
Bug#6505 Wrong sorting order:
latin2_croatian_ci collation was fixed.
Diffstat (limited to 'mysql-test/t/ctype_latin2.test')
-rw-r--r-- | mysql-test/t/ctype_latin2.test | 11 |
1 files changed, 7 insertions, 4 deletions
diff --git a/mysql-test/t/ctype_latin2.test b/mysql-test/t/ctype_latin2.test index 445223f534c..cc232adeaec 100644 --- a/mysql-test/t/ctype_latin2.test +++ b/mysql-test/t/ctype_latin2.test @@ -7,10 +7,6 @@ drop table if exists t1; SET NAMES latin2; CREATE TABLE t1 (a char(1) character set latin2); -INSERT INTO t1 VALUES (0x00),(0x01),(0x02),(0x03),(0x04),(0x05),(0x06),(0x07); -INSERT INTO t1 VALUES (0x08),(0x09),(0x0A),(0x0B),(0x0C),(0x0D),(0x0E),(0x0F); -INSERT INTO t1 VALUES (0x10),(0x11),(0x12),(0x13),(0x14),(0x15),(0x16),(0x17); -INSERT INTO t1 VALUES (0x18),(0x19),(0x1A),(0x1B),(0x1C),(0x1D),(0x1E),(0x1F); INSERT INTO t1 VALUES (0x20),(0x21),(0x22),(0x23),(0x24),(0x25),(0x26),(0x27); INSERT INTO t1 VALUES (0x28),(0x29),(0x2A),(0x2B),(0x2C),(0x2D),(0x2E),(0x2F); INSERT INTO t1 VALUES (0x30),(0x31),(0x32),(0x33),(0x34),(0x35),(0x36),(0x37); @@ -45,3 +41,10 @@ INSERT INTO t1 VALUES (0xF8),(0xF9),(0xFA),(0xFB),(0xFC),(0xFD),(0xFE),(0xFF); # SELECT hex(a) ha, hex(lower(a)) hl, hex(upper(a)) hu, a, lower(a) l, upper(a) u from t1 order by ha; + + +# +# Bug#6505 wrong sorting order +# +SELECT group_concat(a collate latin2_croatian_ci order by binary a) from t1 group by a collate latin2_croatian_ci; +drop table t1; |