Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.3(EOL), 10.4(EOL), 10.5
-
None
Description
CREATE TABLE t1 (id int) with system versioning; |
CREATE TEMPORARY TABLE tmp1 LIKE t1; |
|
CREATE TABLE t2 (id int primary key) with system versioning; |
CREATE TEMPORARY TABLE tmp2 LIKE t2; |
|
drop table t1,t2; |
MariaDB [test]> CREATE TABLE t1 (id int) with system versioning;
|
Query OK, 0 rows affected (0.059 sec)
|
|
MariaDB [test]> CREATE TEMPORARY TABLE tmp1 LIKE t1;
|
Query OK, 0 rows affected, 1 warning (0.014 sec)
|
Warning (Code 1105): System versioning is stripped from temporary `test.tmp1`
|
|
MariaDB [test]> CREATE TABLE t2 (id int,unique key (id)) with system versioning;
|
Query OK, 0 rows affected (0.046 sec)
|
|
MariaDB [test]> CREATE TEMPORARY TABLE tmp2 LIKE t2;
|
ERROR 1072 (42000): Key column 'row_end' doesn't exist in table
|
Warning (Code 1105): System versioning is stripped from temporary `test.tmp2`
|
Error (Code 1072): Key column 'row_end' doesn't exist in table
|