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

Column information of a TEMPORARY table as a server side CURSOR

    XMLWordPrintable

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

            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.