[MDEV-766] LP:869104 - CREATE TABLE ... SELECT can result in column type "null" Created: 2011-10-06  Updated: 2014-03-03  Resolved: 2014-03-03

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: 5.5.36, 10.0.8

Type: Bug Priority: Major
Reporter: Kristian Nielsen Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug869104.xml    

 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

 Comments   
Comment by Rasmus Johansson (Inactive) [ 2012-03-22 ]

Launchpad bug id: 869104

Generated at Thu Feb 08 06:31:11 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.