Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.4(EOL), 10.5
-
None
Description
A plain attempt to create a temporary table with app-time period fails:
MariaDB [test]> create temporary table tmp (a int, s date, e date, period for app(s,e)); |
ERROR 4152 (HY000): Application-time period table cannot be temporary |
However, creating the same table via CREATE .. LIKE is possible:
|
10.4 89ae01fd0085cf0d1af272eca545e49fdadf4538 |
MariaDB [test]> create table t1 (a int, s date, e date, period for app(s,e)); |
Query OK, 0 rows affected (0.226 sec) |
 |
MariaDB [test]> create temporary table tmp like t1; |
Query OK, 0 rows affected (0.048 sec) |
Which of course ends up with the structure which cannot be re-created:
MariaDB [test]> show create table tmp; |
+-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ |
| Table | Create Table | |
+-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ |
| tmp | CREATE TEMPORARY TABLE `tmp` ( |
`a` int(11) DEFAULT NULL, |
`s` date NOT NULL, |
`e` date NOT NULL, |
PERIOD FOR `app` (`s`, `e`) |
) ENGINE=InnoDB DEFAULT CHARSET=latin1 | |
+-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ |
1 row in set (0.001 sec) |
It should be consistent, either one way or another.
Attachments
Issue Links
- relates to
-
-
- Confirmed
-