diff options
| author | unknown <bar@mysql.com> | 2004-08-19 15:15:10 +0500 |
|---|---|---|
| committer | unknown <bar@mysql.com> | 2004-08-19 15:15:10 +0500 |
| commit | 7fbc796d4ad9681fa2381791f8c895be4cbd738b (patch) | |
| tree | 01ac6df006d72fc8d39e0e1c185bc3c8bc11a7bb /mysql-test/r/binary.result | |
| parent | 6cf9fd7cdb9d102ee1e12408f5a8e871d069618d (diff) | |
| download | mariadb-git-7fbc796d4ad9681fa2381791f8c895be4cbd738b.tar.gz | |
Bug#4521: unique key prefix interacts poorly with utf8.
Fix for binary collations for MyISAM and HEAP BTREE.
This patch also changes trailing spaces behaviour for
binary collations. Binary collations now have PAD
characteristic too.
Diffstat (limited to 'mysql-test/r/binary.result')
| -rw-r--r-- | mysql-test/r/binary.result | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/r/binary.result b/mysql-test/r/binary.result index 000c0c16d77..a4ced14bb12 100644 --- a/mysql-test/r/binary.result +++ b/mysql-test/r/binary.result @@ -59,8 +59,10 @@ concat("-",a,"-",b,"-") -hello-hello- select concat("-",a,"-",b,"-") from t1 where b="hello "; concat("-",a,"-",b,"-") +-hello-hello- select concat("-",a,"-",b,"-") from t1 ignore index (b) where b="hello "; concat("-",a,"-",b,"-") +-hello-hello- alter table t1 modify b tinytext not null, drop key b, add key (b(100)); select concat("-",a,"-",b,"-") from t1; concat("-",a,"-",b,"-") |