Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.9(EOL)
-
None
Description
Slightly alike to MDEV-11691, but this one is not in upstream and the SQL required is different.
SET sql_mode=''; |
CREATE TABLE t0 (a TIMESTAMP) ENGINE=CSV; |
INSERT INTO t0 VALUES (0); |
RENAME TABLE t0 TO t; |
SET sql_mode='traditional'; |
UPDATE t SET a=0; |
Leads to:
10.7.0 1bc82aaf0a7746c0921a94034aff2d51f0d75cd0 (Debug) |
2021-09-10 8:26:50 4 [ERROR] mysqld: Table 't' is marked as crashed and should be repaired
|
Attachments
Issue Links
- relates to
-
MDEV-11691 CSV: Table marked as crashed and should be repaired
- Confirmed