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;
|