[DERBY-166] NULL is not a valid constraint type

• Type: Bug
• Status: Closed
• Priority: Trivial
• Resolution: Duplicate
• Affects Version/s: 10.0.2.0
• Component/s: Documentation
• Environment: Windows XP SP1 Professional
• Assignee: Unassigned
• Reporter: George Baklarz
• Created: 08/Mar/05 07:11
• Updated: 10/Oct/06 10:15
• Resolved: 30/Jun/05 08:55

Description

The following statement in the documentation is incorrect:

NULL The opposite of NOT NULL (not really a constraint), it specifies that the column can hold NULL values. Specifying NULL is the same as saying nothing at all, except when the column is included in a PRIMARY KEY constraint.

If you try to create a column with the NULL attribute, you get a failure:

CREATE TABLE X ( A INT NULL );

ERROR 42X01: Syntax error: Encountered "null" at line 1, column 23.

While this isn't really a problem since we can just omit the NULL keyword, the documentation gives the impression that it is allowed in the CREATE statement.