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

LP:869104 - CREATE TABLE ... SELECT can result in column type "null"

    XMLWordPrintable

Details

    Description

      CREATE TABLE t1 ENGINE = INNODB AS SELECT IF(NULL IS NOT NULL, NULL, NULL);
      SHOW CREATE TABLE t1;

      Create Table: CREATE TABLE `t1` (
      `IF(NULL IS NOT NULL, NULL, NULL)` null DEFAULT NULL
      ) ENGINE=InnoDB DEFAULT CHARSET=latin1

      Note the column type "null". This is not valid in CREATE TABLE, so for example
      a mysqldump including such a table will not be able to re-create the table.

      This is MySQL bug#54394: http://bugs.mysql.com/bug.php?id=54394

      Attachments

        Activity

          People

            serg Sergei Golubchik
            knielsen Kristian Nielsen
            Votes:
            0 Vote for this issue
            Watchers:
            0 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.