summaryrefslogtreecommitdiff
path: root/mysql-test/r/ctype_ujis.result
diff options
context:
space:
mode:
authorunknown <bar@mysql.com>2005-01-13 18:12:04 +0400
committerunknown <bar@mysql.com>2005-01-13 18:12:04 +0400
commit9842aca3ef48bf56a6c3ee5b9e1159e4249ce346 (patch)
tree89b4be1d3a807d6f2554dce92b0a5ecd0a9009ab /mysql-test/r/ctype_ujis.result
parentbcb3783c7c88b06a8417a5734103ae856a2f7dbc (diff)
downloadmariadb-git-9842aca3ef48bf56a6c3ee5b9e1159e4249ce346.tar.gz
bug#7284: strnxfrm returns different results for equal strings
Diffstat (limited to 'mysql-test/r/ctype_ujis.result')
-rw-r--r--mysql-test/r/ctype_ujis.result20
1 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/r/ctype_ujis.result b/mysql-test/r/ctype_ujis.result
index aa4c347d54f..fd6c501499b 100644
--- a/mysql-test/r/ctype_ujis.result
+++ b/mysql-test/r/ctype_ujis.result
@@ -2207,3 +2207,23 @@ F4FC
F4FD
F4FE
DROP TABLE t1;
+SET collation_connection='ujis_japanese_ci';
+create table t1 select repeat('a',4000) a;
+delete from t1;
+insert into t1 values ('a'), ('a '), ('a\t');
+select collation(a),hex(a) from t1 order by a;
+collation(a) hex(a)
+ujis_japanese_ci 6109
+ujis_japanese_ci 61
+ujis_japanese_ci 6120
+drop table t1;
+SET collation_connection='ujis_bin';
+create table t1 select repeat('a',4000) a;
+delete from t1;
+insert into t1 values ('a'), ('a '), ('a\t');
+select collation(a),hex(a) from t1 order by a;
+collation(a) hex(a)
+ujis_bin 6109
+ujis_bin 61
+ujis_bin 6120
+drop table t1;