Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: N/A
-
Fix Version/s: 10.3.4
-
Component/s: Data Definition - Temporary
-
Labels: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
-