Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.3(EOL)
-
None
Description
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.