db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bernt M. Johnsen (JIRA)" <derby-...@db.apache.org>
Subject [jira] Created: (DERBY-158) PRIMARY KEY does not imply NOT NULL
Date Thu, 03 Mar 2005 21:52:52 GMT
PRIMARY KEY does not imply NOT NULL
-----------------------------------

         Key: DERBY-158
         URL: http://issues.apache.org/jira/browse/DERBY-158
     Project: Derby
        Type: Bug
  Components: SQL  
    Reporter: Bernt M. Johnsen
    Priority: Minor


PRIMARY KEY does not imply NOT NULL. Derby issues error message:

ij> create table tab (i integer primary key);
ERROR 42831: 'I' cannot be a column of a primary key or unique key because it can contain
null values.

This is neither compliant with SQL-92 nor with SQL-99 (Feature E141-08, I think).


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira


Mime
View raw message