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

Column information of a TEMPORARY table as a server side CURSOR

Details

    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.

      Attachments

        Issue Links

          Activity

            There are no comments yet on this issue.

            People

              Unassigned Unassigned
              tegmen Harun Tegmen
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.