[MDEV-12460] IMPROVE INNODB_TEMP_TABLE_INFO or an additional global info for temp tables metadata with extended information (fields, indexes, etc) Created: 2017-04-06  Updated: 2017-05-24

Status: Open
Project: MariaDB Server
Component/s: Data Definition - Temporary
Fix Version/s: None

Type: Task Priority: Major
Reporter: Francisco Dueñas Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: 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.



 Comments   
Comment by Sergei Golubchik [ 2017-05-24 ]

Is that a duplicate of MDEV-12459 ?

Generated at Thu Feb 08 07:57:53 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.