Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-12460

IMPROVE INNODB_TEMP_TABLE_INFO or an additional global info for temp tables metadata with extended information (fields, indexes, etc)

    XMLWordPrintable

Details

    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.

      Attachments

        Activity

          People

            Unassigned Unassigned
            fduenas Francisco Dueñas
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.