Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
5.5.38, 10.0.12
-
None
-
None
Description
MariaDB [test]> CREATE TABLE tab (c INT) ENGINE = InnoDB; |
Query OK, 0 rows affected (0.43 sec) |
MariaDB [test]> CREATE TEMPORARY TABLE tab LIKE tab; |
ERROR 1066 (42000): Not unique table/alias: 'tab' |
I suppose that this error should only appear if I omit the TEMPORARY keyword, or if a temporary table with that name already exists. In this case, the old table and the new table are distinct entities...