Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-6013

SHOW CREATE TABLE doesn't detect if a temporary table is used

    XMLWordPrintable

Details

    Description

      All of the following statements should work and not produce any errors.

      CREATE TEMPORARY TABLE t1(id INT);
      INSERT INTO t1 VALUES (1);
      SELECT * FROM t1;
      SHOW CREATE TABLE t1;
      

      The SHOW CREATE TABLE fails as it doesn't detect that the table in question is a temporary one.

      Attachments

        Activity

          People

            markus makela markus makela
            markus makela markus makela
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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