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, Versioned Tables
-
Labels:None
-
Environment:bb-10.3-temporal ea49441c41
Description
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; |
Attachments
Issue Links
- causes
-
MDEV-14770 Versioned temporary table is marked as crashed and should be repaired
-
- Closed
-