diff options
author | Alexander Barkov <bar@mariadb.com> | 2019-12-06 18:51:05 +0400 |
---|---|---|
committer | Alexander Barkov <bar@mariadb.com> | 2019-12-06 18:51:05 +0400 |
commit | 3c6065a270f547d160e11bbcaa653930ec5ff90f (patch) | |
tree | 8022e7e08c894de49542c2be94a9fd4186baeb05 /mysql-test/main/ctype_binary.result | |
parent | 00445652dbe1631699d860c4eb2263d9c29256a9 (diff) | |
download | mariadb-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.result | 26 |
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 +# |