[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: |
|
||||||||
| Description |
|
select ... from information_schema.columns For example: 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. |