Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
N/A
-
None
Description
Note: The problem is likely to go away after MDEV-14769 is fixed, so it will stay draft for now.
CREATE TEMPORARY TABLE table11_aria ( `col_int_key` INT) ENGINE=Aria;
|
INSERT INTO table11_aria VALUES (1),(2);
|
SET STATEMENT system_versioning_alter_history=KEEP FOR ALTER TABLE `table11_aria` ADD SYSTEM VERSIONING, ROW_FORMAT=DYNAMIC;
|
UPDATE table11_aria SET `col_int_key` = 3;
|
SET STATEMENT system_versioning_alter_history=KEEP FOR ALTER TABLE `table11_aria` ADD COLUMN IF NOT EXISTS `vers_end` BIGINT UNSIGNED GENERATED ALWAYS AS ROW END;
|
DELETE HISTORY FROM `table11_aria`;
|
OPTIMIZE TABLE `table11_aria`;
|
UPDATE table11_aria SET `col_int_key` = 2;
|
bb-10.3-temporal ea49441c41 |
mysqltest: At line 8: query 'UPDATE table11_aria SET `col_int_key` = 2' failed: 1194: Table 'table11_aria' is marked as crashed and should be repaired
|
Attachments
Issue Links
- is caused by
-
MDEV-14769 Temporary table can be altered into system versioning + system_versioning_alter_history has no effect
- Closed