[MDEV-23643] Column information of a TEMPORARY table as a server side CURSOR Created: 2020-09-01  Updated: 2020-09-15

Status: Open
Project: MariaDB Server
Component/s: Data Manipulation - Subquery
Fix Version/s: None

Type: Task Priority: Minor
Reporter: Harun Tegmen Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: optimizer

Issue Links:
Relates
relates to MDEV-12459 The information_schema tables for get... Closed

 Description   

select ... from information_schema.columns
provides column information only about STATIC tables,
but does not column information of TEMPORARY tables.

For example:
create TEMPORARY table Temp1 (id int, exp char(30) );
select column_name Field,
column_type Type,
is_nullable "Null",
column_key "Key",
column_default "Default",
extra Extra
from information_schema.columns
where table_name = "Temp1"
and table_schema = database();

returns an EMPTY RESULT SET,

only desc Temp1; lists the column information of TEMPORARY table Temp1 succesfully.

How can be obtained column information of a TEMPORARY table as a server side CURSOR ?

If the command "desc Temp1;" can be used in subqueries, this will be achieved by direct way.


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