summaryrefslogtreecommitdiff
path: root/mysql-test/r
diff options
context:
space:
mode:
authorAlexander Barkov <alexander.barkov@oracle.com>2012-01-23 13:23:50 +0400
committerAlexander Barkov <alexander.barkov@oracle.com>2012-01-23 13:23:50 +0400
commitd29e871b681dd6934303384257b34379c0379116 (patch)
tree55a46bd596bfdbfb3adc641f4fc3b175041ae6e0 /mysql-test/r
parent78bb7cc600a256a0ece8844745cbcd91a8f730b8 (diff)
parente56caa38f19845dc56f1b556c782ca2f48200a2a (diff)
downloadmariadb-git-d29e871b681dd6934303384257b34379c0379116.tar.gz
Merging Bug#11752408 from mysql-5.1
Diffstat (limited to 'mysql-test/r')
-rw-r--r--mysql-test/r/ctype_utf8.result24
1 files changed, 24 insertions, 0 deletions
diff --git a/mysql-test/r/ctype_utf8.result b/mysql-test/r/ctype_utf8.result
index 8237f174514..fc306e499d3 100644
--- a/mysql-test/r/ctype_utf8.result
+++ b/mysql-test/r/ctype_utf8.result
@@ -1928,6 +1928,30 @@ D120
SELECT HEX(INSERT(_utf8 0xD18FD18E, 2, 1, 0x20));
HEX(INSERT(_utf8 0xD18FD18E, 2, 1, 0x20))
D120D18E
+#
+# Bug#11752408 - 43593: DUMP/BACKUP/RESTORE/UPGRADE TOOLS FAILS BECAUSE OF UTF8_GENERAL_CI
+#
+CREATE TABLE t1 (a VARCHAR(10) CHARACTER SET utf8 COLLATE utf8_general_mysql500_ci);
+INSERT INTO t1 VALUES ('a'),('r'),('s'),(_latin1 0xDF),(_latin1 0xF7),('t'),('z');
+SELECT * FROM t1 ORDER BY a;
+a
+a
+r
+s
+t
+z
+SELECT a, COUNT(*) FROM t1 GROUP BY a;
+a COUNT(*)
+a 1
+r 1
+s 1
+t 1
+z 1
+ß 1
+÷ 1
+DROP TABLE t1;
End of 5.1 tests
Start of 5.4 tests
SET NAMES utf8mb3;