I insert an latin1 string consisting of 250 ASCII characters in two TINYTEXT columns (compressed and non-compressed) with CHARACTER SET utf8. The compressed column truncates data. The non-compressed column writes the entire value, as expected:
SET sql_mode='';
|
CREATE OR REPLACE TABLE t1(
|
a TINYTEXT CHARACTER SET utf8 COMPRESSED,
|
b TINYTEXT CHARACTER SET utf8
|
);
|
INSERT INTO t1 VALUES (REPEAT(_latin1'a',250), REPEAT(_latin1'a',250));
|
SELECT CHAR_LENGTH(a), CHAR_LENGTH(b) FROM t1;
|
+----------------+----------------+
|
| CHAR_LENGTH(a) | CHAR_LENGTH(b) |
|
+----------------+----------------+
|
| 84 | 250 |
|
+----------------+----------------+
|
Looks wrong. The expected behavior would be to write all 250 characters into both columns.
Bug
Major
