mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 10:56:12 +01:00
68cbabbfb0
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.
9 lines
361 B
Text
9 lines
361 B
Text
--source include/have_utf16.inc
|
|
|
|
--echo #
|
|
--echo # MDEV-15938 - TINYTEXT CHARACTER SET utf8 COMPRESSED truncates data
|
|
--echo #
|
|
CREATE TABLE t1(a TINYTEXT COMPRESSED, b TINYTEXT) CHARACTER SET utf16;
|
|
INSERT INTO t1 VALUES (REPEAT(_latin1'a', 127), REPEAT(_latin1'a', 127));
|
|
SELECT CHAR_LENGTH(a), CHAR_LENGTH(b), LEFT(a, 10), LEFT(b, 10) FROM t1;
|
|
DROP TABLE t1;
|