[MDEV-14769] Temporary table can be altered into system versioning + system_versioning_alter_history has no effect - Jira

XML

Word

Printable

Creation of a temporary table with system versioning is prohibited:

MariaDB [test]> CREATE OR REPLACE TEMPORARY TABLE t1 (i INT) WITH SYSTEM VERSIONING;

ERROR 4146 (HY000): WITH SYSTEM VERSIONING prohibited for TEMPORARY tables

However, such a table can be created in two steps:

MariaDB [test]> CREATE OR REPLACE TEMPORARY TABLE t1 (i INT);

Query OK, 0 rows affected (0.01 sec)

MariaDB [test]> ALTER TABLE t1 ADD SYSTEM VERSIONING;

Query OK, 0 rows affected (0.01 sec)

Records: 0  Duplicates: 0  Warnings: 0

Please also note that system_versioning_alter_history has no effect here:

MariaDB [test]> CREATE OR REPLACE TEMPORARY TABLE t1 (i INT);

Query OK, 0 rows affected (0.01 sec)

MariaDB [test]> SET system_versioning_alter_history= ERROR;

Query OK, 0 rows affected (0.00 sec)

MariaDB [test]> ALTER TABLE t1 ADD SYSTEM VERSIONING;

Query OK, 0 rows affected (0.01 sec)

Records: 0  Duplicates: 0  Warnings: 0

Same test case for copy-pasting
--error ER_VERS_TEMPORARY
CREATE OR REPLACE TEMPORARY TABLE t1 (i INT) WITH SYSTEM VERSIONING;

CREATE OR REPLACE TEMPORARY TABLE t1 (i INT);

SET system_versioning_alter_history= ERROR;
--error ER_VERS_TEMPORARY
ALTER TABLE t1 ADD SYSTEM VERSIONING;

causes

MDEV-14770 Versioned temporary table is marked as crashed and should be repaired

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.