Project

General

Profile

Actions

Bug #33704

closed

SQL parser does not support NULL as default value

Added by Xavier Perseguers about 12 years ago. Updated over 6 years ago.

Status:
Closed
Priority:
Should have
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

Also available in: Atom PDF