Actions
Bug #76641
closedDatabase compare and "NULL default NULL" is not recognized
Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Install Tool
Target version:
-
Start date:
2016-06-15
Due date:
% Done:
100%
Estimated time:
TYPO3 Version:
7
PHP Version:
Tags:
Complexity:
Is Regression:
No
Sprint Focus:
Description
I have a case where a decimal field is needed, which has a default value of NULL, and can contain NULL values, to differentiate between 0.0 and NULL.
The definition is
price decimal(5,2) unsigned NULL default NULL
Database compare then shows said field under "change fields" as
CHANGE price price decimal(5,2) unsigned NULL default NULL; Current value: decimal(5,2) unsigned default NULL
However, using "unsigned default NULL" would not allow NULL values and will yield errors on inserting or updating records.
Actions