summaryrefslogtreecommitdiff
path: root/mysql-test/main/ctype_binary.result
diff options
context:
space:
mode:
authorAlexander Barkov <bar@mariadb.com>2019-12-06 18:51:05 +0400
committerAlexander Barkov <bar@mariadb.com>2019-12-06 18:51:05 +0400
commit3c6065a270f547d160e11bbcaa653930ec5ff90f (patch)
tree8022e7e08c894de49542c2be94a9fd4186baeb05 /mysql-test/main/ctype_binary.result
parent00445652dbe1631699d860c4eb2263d9c29256a9 (diff)
downloadmariadb-git-3c6065a270f547d160e11bbcaa653930ec5ff90f.tar.gz
MDEV-8844 Unreadable control characters printed as is in warnings
Diffstat (limited to 'mysql-test/main/ctype_binary.result')
-rw-r--r--mysql-test/main/ctype_binary.result26
1 files changed, 26 insertions, 0 deletions
diff --git a/mysql-test/main/ctype_binary.result b/mysql-test/main/ctype_binary.result
index 118a55cd5ee..77157a4da0a 100644
--- a/mysql-test/main/ctype_binary.result
+++ b/mysql-test/main/ctype_binary.result
@@ -3174,3 +3174,29 @@ DROP TABLE t1;
#
# End of 10.1 tests
#
+#
+# Start of 10.5 tests
+#
+#
+# MDEV-8844 Unreadable control characters printed as is in warnings
+#
+SET NAMES binary;
+CREATE TABLE t1 (a VARCHAR(20) CHARACTER SET latin1, UNIQUE(a));
+INSERT INTO t1 VALUES (0x61000162FF);
+INSERT INTO t1 VALUES (0x61000162FF);
+ERROR 23000: Duplicate entry 'a\0000\0001bÿ' for key 'a'
+INSERT IGNORE INTO t1 VALUES (0x61000162FF);
+Warnings:
+Warning 1062 Duplicate entry 'a\0000\0001bÿ' for key 'a'
+DROP TABLE t1;
+CREATE TABLE t1 (a VARCHAR(20) CHARACTER SET utf8, UNIQUE(a));
+INSERT INTO t1 VALUES (_latin1 0x61000162FF);
+INSERT INTO t1 VALUES (_latin1 0x61000162FF);
+ERROR 23000: Duplicate entry 'a\0000\0001bÿ' for key 'a'
+INSERT IGNORE INTO t1 VALUES (_latin1 0x61000162FF);
+Warnings:
+Warning 1062 Duplicate entry 'a\0000\0001bÿ' for key 'a'
+DROP TABLE t1;
+#
+# End of 10.5 tests
+#