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

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

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

          Ascending order - Click to sort in descending order
          knielsen Kristian Nielsen created issue -
          ratzpo Rasmus Johansson (Inactive) added a comment -

          Launchpad bug id: 869104

          ratzpo Rasmus Johansson (Inactive) added a comment - Launchpad bug id: 869104
          ratzpo Rasmus Johansson (Inactive) made changes -
          Field Original Value New Value
          Labels Launchpad
          ratzpo Rasmus Johansson (Inactive) made changes -
          Key IMT-7438 MDEV-766
          Project ImportTest [ 10200 ] MariaDB Development [ 10000 ]
          Workflow jira [ 21087 ] defaullt [ 21610 ]
          serg Sergei Golubchik made changes -
          Priority Major [ 3 ]
          serg Sergei Golubchik made changes -
          Fix Version/s 5.5.36 [ 14600 ]
          Fix Version/s 10.0.8 [ 14200 ]
          Assignee Sergei Golubchik [ serg ]
          Resolution Fixed [ 1 ]
          Status Open [ 1 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow defaullt [ 21610 ] MariaDB v2 [ 44545 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Workflow MariaDB v2 [ 44545 ] MariaDB v3 [ 63897 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 63897 ] MariaDB v4 [ 145841 ]

          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.