Renaming a NOT NULL column without a default value fails in MySQL migrations

When trying to rename a column that is NOT NULL and has no default value, Doctrine generates this SQL:

ALTER TABLE `article` CHANGE `typeid` `listid` INT DEFAULT NULL NOT NULL

Which fails. It should be:

ALTER TABLE `article` CHANGE `typeid` `listid` INT NOT NULL

Ascending order - Click to sort in descending order

Jack Sleight made changes - 25/Jun/10 3:27 PM

Field	Original Value	New Value
Description	When trying to rename a column that is NOT NULL and has no default value, Doctrine generates this SQL: {code}ALTER TABLE `article` CHANGE `typeid` `listid` INT DEFAULT NULL NOT NULL{code} Which fails. It should be: {code}ALTER TABLE `at_article` CHANGE `journalid` `listid` INT NOT NULL{code}	When trying to rename a column that is NOT NULL and has no default value, Doctrine generates this SQL: {code}ALTER TABLE `article` CHANGE `typeid` `listid` INT DEFAULT NULL NOT NULL{code} Which fails. It should be: {code}ALTER TABLE `article` CHANGE `typeid` `listid` INT NOT NULL{code}

Attachment

DC-768.patch [ 10922 ]

Vote (2)

Watch (1)