Details
-
Type:
Bug
-
Status: In Review (View Workflow)
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: N/A
-
Fix Version/s: 10.9
-
Component/s: Data Definition - Temporary
-
Labels:
Description
MDEV-12459 introduced a note upon creation of a temporary table which shadows an existing base table; it looks quite natural.
However, this note is also produced upon ALTER of such a table. That is not natural, even though may be understandable from the technical point of view.
create table t (a int); |
create temporary table t (b int); |
alter table t add c int; |
 |
# Cleanup
|
drop temporary table t; |
drop table t; |
preview-10.9-MDEV-20119-misc c906db30 |
alter table t add c int; |
Warnings:
|
Note 1050 Table 't' already exists |
Attachments
Issue Links
- is caused by
-
MDEV-12459 The information_schema tables for getting temporary tables info is missing, at least for innodb there is no INNODB_TEMP_TABLE_INFO
-
- Stalled
-