db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "George Baklarz (JIRA)" <derby-...@db.apache.org>
Subject [jira] Created: (DERBY-166) NULL is not a valid constraint type
Date Mon, 07 Mar 2005 22:11:52 GMT
NULL is not a valid constraint type

         Key: DERBY-166
         URL: http://issues.apache.org/jira/browse/DERBY-166
     Project: Derby
        Type: Bug
  Components: Documentation  
 Environment: Windows XP SP1 Professional
    Reporter: George Baklarz
    Priority: Trivial

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:


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.

This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
If you want more information on JIRA, or have a bug to report see:

View raw message