Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
N/A
-
None
-
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
-
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Assignee | Elena Stepanova [ elenst ] | Alexander Krizhanovsky [ krizhanovsky ] |
| Environment | bb-10.3-temporal ea49441c41 |
| Assignee | Alexander Krizhanovsky [ krizhanovsky ] | Eugene Kosov [ kevg ] |
It's always ok (and standard) to `ADD SYSTEM VERSIONING` and `DROP SYSTEM VERSIONING`. `system_versioning_alter_history` prohibits all other `ALTER` types.
You are right, sorry for the confusion, please ignore the part that refers to system_versioning_alter_history behavior.
It initially came from a non-simplified test case, which was executing more complex statements, like
ALTER TABLE t1 ADD SYSTEM VERSIONING, ADD COLUMN a INT |
which I expected to fail, but I can now see that this is allowed for non-temporary tables as well, so I guess it's not a problem.
| Fix Version/s | 10.3.4 [ 22904 ] | |
| Fix Version/s | 10.3 [ 22126 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Open [ 1 ] | Closed [ 6 ] |
| Link |
This issue causes |
| Workflow | MariaDB v3 [ 84603 ] | MariaDB v4 [ 153435 ] |
It's always ok (and standard) to `ADD SYSTEM VERSIONING` and `DROP SYSTEM VERSIONING`. `system_versioning_alter_history` prohibits all other `ALTER` types.