diff options
| author | Sergey Vojtovich <svoj@mariadb.org> | 2018-04-25 14:42:38 +0400 |
|---|---|---|
| committer | Sergey Vojtovich <svoj@mariadb.org> | 2018-04-30 19:34:08 +0400 |
| commit | 68cbabbfb0667187042315461069d3e1aeb2c57b (patch) | |
| tree | 72d7eed804e1aa5e8206694049be33b0c56c42c8 /mysql-test/main/column_compression.test | |
| parent | 9a8498066865b508239b36853403f2700800af2b (diff) | |
| download | mariadb-git-68cbabbfb0667187042315461069d3e1aeb2c57b.tar.gz | |
MDEV-15938 - TINYTEXT CHARACTER SET utf8 COMPRESSED truncates data
Unexpected data truncation may occur when storing data to compressed blob
column having multi byte variable length character sets.
The reason was incorrect number of characters limit was enforced for
blobs.
Diffstat (limited to 'mysql-test/main/column_compression.test')
| -rw-r--r-- | mysql-test/main/column_compression.test | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/main/column_compression.test b/mysql-test/main/column_compression.test index 84f17076494..5590c995396 100644 --- a/mysql-test/main/column_compression.test +++ b/mysql-test/main/column_compression.test @@ -112,3 +112,11 @@ SET column_compression_threshold=0; INSERT INTO t1 VALUES('a'); SET column_compression_threshold=DEFAULT; DROP TABLE t1; + +--echo # +--echo # MDEV-15938 - TINYTEXT CHARACTER SET utf8 COMPRESSED truncates data +--echo # +CREATE TABLE t1(a TINYTEXT COMPRESSED, b TINYTEXT) CHARACTER SET utf8; +INSERT INTO t1 VALUES (REPEAT(_latin1'a', 254), REPEAT(_latin1'a', 254)); +SELECT CHAR_LENGTH(a), CHAR_LENGTH(b), LEFT(a, 10), LEFT(b, 10) FROM t1; +DROP TABLE t1; |