diff options
| author | unknown <bar@mysql.com> | 2005-06-07 13:56:42 +0500 |
|---|---|---|
| committer | unknown <bar@mysql.com> | 2005-06-07 13:56:42 +0500 |
| commit | c9914ac6ac456386aff36f948fa8036f066612bf (patch) | |
| tree | ddfae8863835948b6506f22aef6d459ca2a0178d /mysql-test/r | |
| parent | e3dc3db659a5d8edec4d46635d069d0c1777bb8c (diff) | |
| download | mariadb-git-c9914ac6ac456386aff36f948fa8036f066612bf.tar.gz | |
Bug#10253: compound index length and utf8 char set
produces invalid query results
mi_key.c:
well_formed_length should be executed before space trimming, not after.
ctype_utf8.test:
ctype_utf8.result:
adding test.
myisam/mi_key.c:
Bug#10253: ompound index length and utf8 char set produces invalid query results
well_formed_length should be executed before space trimming, not after.
mysql-test/r/ctype_utf8.result:
adding test.
adding test.
mysql-test/t/ctype_utf8.test:
adding test.
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/ctype_utf8.result | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/r/ctype_utf8.result b/mysql-test/r/ctype_utf8.result index b7aa7c68b67..ac421ea1717 100644 --- a/mysql-test/r/ctype_utf8.result +++ b/mysql-test/r/ctype_utf8.result @@ -891,3 +891,14 @@ string create table t1 (a varchar(255)) default character set utf8; insert into t1 values (1.0); drop table t1; +create table t1 ( +id int not null, +city varchar(20) not null, +key (city(7),id) +) character set=utf8; +insert into t1 values (1,'Durban North'); +insert into t1 values (2,'Durban'); +select * from t1 where city = 'Durban'; +id city +2 Durban +drop table t1; |