Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL)
-
None
Description
SET NAMES 'utf8mb3' COLLATE 'uca1400_swedish_nopad_ai_ci'; |
|
CREATE TABLE t (a CHAR(8)); |
INSERT INTO t VALUES ('foo'); |
--error ER_TRUNCATED_WRONG_VALUE
|
ALTER TABLE t MODIFY a INT; |
CREATE EVENT ev ON SCHEDULE EVERY 1 HOUR DO BEGIN END; |
|
# Cleanup
|
DROP EVENT ev; |
DROP TABLE t; |
10.10 bb76dcbe |
query 'CREATE EVENT ev ON SCHEDULE EVERY 1 HOUR DO BEGIN END' failed: ER_EVENT_STORE_FAILED (1538): Failed to store event body. Error code 2 "No such file or directory" from storage engine |
I tried a few uca1400_xxxx_nopad_xx_xx collations, it was reproducible with each of them. Couldn't reproduce with non-nopad, non-uca1400, and non-language-specific (without xxxx) which I tried.
Reproducible on 10.10/10.11.
The test case isn't applicable to earlier versions due to the use of UCA1400 collations.
On some reason the failing ALTER TABLE is important here, although I can't figure why.
Attachments
Issue Links
- is caused by
-
MDEV-27009 Add UCA-14.0.0 collations
- Closed
- relates to
-
MDEV-29776 collation_connection and db_collation are too short in mysql.proc and mysql.event
- Closed