1#
2# MDEV-15938 - TINYTEXT CHARACTER SET utf8 COMPRESSED truncates data
3#
4CREATE TABLE t1(a TINYTEXT COMPRESSED, b TINYTEXT) CHARACTER SET utf16;
5INSERT INTO t1 VALUES (REPEAT(_latin1'a', 127), REPEAT(_latin1'a', 127));
6SELECT CHAR_LENGTH(a), CHAR_LENGTH(b), LEFT(a, 10), LEFT(b, 10) FROM t1;
7CHAR_LENGTH(a)	CHAR_LENGTH(b)	LEFT(a, 10)	LEFT(b, 10)
8127	127	aaaaaaaaaa	aaaaaaaaaa
9DROP TABLE t1;
10