Actions
Bug #33704
closedSQL parser does not support NULL as default value
Status:
Closed
Priority:
Should have
Assignee:
Category:
Database API (Doctrine DBAL)
Target version:
Start date:
2012-02-06
Due date:
% Done:
100%
Estimated time:
TYPO3 Version:
4.6
PHP Version:
5.3
Tags:
Complexity:
Is Regression:
Sprint Focus:
Description
When preparing a database schema with proper referential integrity, one typically has to choose NULL as default value for foreign keys:
CREATE TABLE tx_myext_domain_model_member ( uid int(11) NOT NULL auto_increment, pid int(11) DEFAULT '0' NOT NULL, some_fk int(11) DEFAULT NULL,
However, database analyzer does not support NULL as default value and shows an empty string ('') instead, thus suggesting that the underlying table structure is invalid and should be adapted.
Actions