Details
-
Task
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
Description
The current implementation of 'INNODB_TEMP_TABLE_INFO' in MySQL 5.7 (not yet implemented in MariaDB 10.2.5) is limited and only shows basic information of the name of the file, but there is no way to relate the table file name with the table name in a session.
This because how can we query (via SELECT) the field information of a temporary table. yes we can use 'SHOW COLUMS FROM' but there is no way we can process the resultset inside MySQl server, or use a CURSOR to navigate the result dataset. For example to generate a table from a prepared SELECT statement and read the field information to make specific tasks.