Actions
Bug #21616
closed
Columns with NOT NULL are created as NULLABLE
Status:
Closed
Priority:
Should have
Assignee:
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2009-11-19
Due date:
% Done:
0%
Estimated time:
TYPO3 Version:
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:
Description
Extract:
CREATE TABLE cache_pages (
id int(11) unsigned NOT NULL auto_increment,
hash varchar(32) DEFAULT '' NOT NULL,
page_id int(11) unsigned DEFAULT '0' NOT NULL,
...
) ENGINE=InnoDB;
Column id is created as NOT NULL but hash and page_id are created without flag NOT NULL.
(issue imported from #M12670)
Updated by Xavier Perseguers about 15 years ago
Actually, this is by design that NOT NULL information is removed when dealing with an Oracle database as Oracle consider empty strings as NULL values. This is located within method compileFieldCfg() of ux_t3lib_sqlparser.
Actions