CREATE TABLE ... SELECT can result in column type "null"
Bug #869104 reported by
Kristian Nielsen
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
New
|
Undecided
|
Unassigned |
Bug 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://
tags: | added: upstream |
To post a comment you must log in.