diff options
| author | unknown <evgen@moonbone.local> | 2007-07-09 02:02:18 +0400 |
|---|---|---|
| committer | unknown <evgen@moonbone.local> | 2007-07-09 02:02:18 +0400 |
| commit | 25cba4500946f8c31488b008e86b54989ccd9c38 (patch) | |
| tree | f037ac3859c739c7d32bb201407c9cbbb429e72c /mysql-test | |
| parent | f045039d861bbadfe82266460aa95f9b6d89760f (diff) | |
| parent | bfa027e72e99c2cd27df3cf3869289ddc9bff5a3 (diff) | |
| download | mariadb-git-25cba4500946f8c31488b008e86b54989ccd9c38.tar.gz | |
Merge epotemkin@bk-internal.mysql.com:/home/bk/mysql-5.0-opt
into moonbone.local:/mnt/gentoo64/work/29461-bug-5.0-opt-mysql
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/ctype_collate.result | 8 | ||||
| -rw-r--r-- | mysql-test/t/ctype_collate.test | 11 |
2 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/r/ctype_collate.result b/mysql-test/r/ctype_collate.result index 52ee76d1948..5c9bb93103e 100644 --- a/mysql-test/r/ctype_collate.result +++ b/mysql-test/r/ctype_collate.result @@ -603,3 +603,11 @@ check table t1 extended; Table Op Msg_type Msg_text test.t1 check status OK drop table t1; +create table t1 (a varchar(2) character set latin7 collate latin7_general_ci,key(a)); +insert into t1 set a=0x4c20; +insert into t1 set a=0x6c; +insert into t1 set a=0x4c98; +check table t1 extended; +Table Op Msg_type Msg_text +test.t1 check status OK +drop table t1; diff --git a/mysql-test/t/ctype_collate.test b/mysql-test/t/ctype_collate.test index 4bbae42559a..cfef8dfe81a 100644 --- a/mysql-test/t/ctype_collate.test +++ b/mysql-test/t/ctype_collate.test @@ -218,3 +218,14 @@ insert into t1 set f1=0x3F3F1E563F; insert into t1 set f1=0x3F3F; check table t1 extended; drop table t1; + +# +# Bug#29461: Sort order of the collation wasn't used when comparing characters +# with the space character. +# +create table t1 (a varchar(2) character set latin7 collate latin7_general_ci,key(a)); +insert into t1 set a=0x4c20; +insert into t1 set a=0x6c; +insert into t1 set a=0x4c98; +check table t1 extended; +drop table t1; |