Details
-
New Feature
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
Description
Since some more recent version (e.g. 11.2 behaves this way, 10.x didn't yet), MariaDB reports temporary tables in the INFORMATION_SCHEMA.TABLES view, but their columns aren't reported in the INFORMATION_SCHEMA.COLUMNS view:
create temporary table t (
|
c int
|
);
|
|
select t.table_name, t.table_type, c.column_name
|
from information_schema.tables t
|
left join information_schema.columns c
|
on t.table_schema = c.table_schema
|
and t.table_name = c.table_name
|
where t.table_name = 't'
|
order by c.ordinal_position;
|
This produces:
TABLE_NAME | TABLE_TYPE | COLUMN_NAME |
t | TEMPORARY |
Attachments
Issue Links
- relates to
-
MDEV-12459 The information_schema tables for getting temporary tables info is missing, at least for innodb there is no INNODB_TEMP_TABLE_INFO
-
- Closed
-