mysqltest: At line 211: query 'insert into cs3 values (_utf8mb4 0xF09F988E, '2020-10-25 01:02:07',
|
'1234567890', '2020-10-25 01:02:08',
|
'abc', '2020-10-25 01:02:09',
|
'cde', '2020-10-25 01:02:10')' succeeded - should have failed with error ER_TRUNCATED_WRONG_VALUE_FOR_FIELD (1366)...
|
|
The result from queries just before the failure was:
|
< snip >
|
insert into cs3 values ('1', '2020-10-25 01:02:04',
|
_utf8mb4 0xc2b9c2b2c2b3e281b4e281b5e281b6e281b7e281b8e281b9e281b0, '2020-10-25 01:02:05', -- ¹²³â´âµâ¶â·â¸â¹â°
|
'abc', '2020-10-25 01:02:06',
|
'cde', '2020-10-25 01:02:07');
|
insert into cs3 values ('1', '2020-10-25 01:02:05',
|
_utf8mb4 0xc2b9c2b2c2b3e281b4e281b5e281b6e281b7e281b8e281b9e281b0c2b9, '2020-10-25 01:02:06', -- ¹²³â´âµâ¶â·â¸â¹â°Â¹
|
'abc', '2020-10-25 01:02:07',
|
'cde', '2020-10-25 01:02:08');
|
ERROR 22001: Data too long for column 'c' at row 1
|
insert ignore into cs3 values ('12', '2020-10-25 01:02:06',
|
_utf8mb4 0xc2b9c2b2c2b3e281b4e281b5e281b6e281b7e281b8e281b9e281b0c2b9, '2020-10-25 01:02:07', -- ¹²³â´âµâ¶â·â¸â¹â°Â¹
|
'abc', '2020-10-25 01:02:08',
|
'cde', '2020-10-25 01:02:09');
|
Warnings:
|
Warning 1265 Data truncated for column 'a' at row 1
|
Warning 1265 Data truncated for column 'c' at row 1
|
insert into cs3 values (_utf8mb4 0xF09F988E, '2020-10-25 01:02:07',
|
'1234567890', '2020-10-25 01:02:08',
|
'abc', '2020-10-25 01:02:09',
|
'cde', '2020-10-25 01:02:10');
|
|
More results from queries before failure can be found in /var/tmp/mtr/log/mcol_2000.log
|