/[Apache-SVN]
ViewVC logotype

Revision 156570


Jump to revision: Previous Next
Author: jboynes
Date: Tue Mar 8 21:22:59 2005 UTC (19 years, 1 month ago)
Changed paths: 7
Log Message:
Fix for DERBY-158 PRIMARY KEY does not imply NOT NULL
Columns specified in a PRIMARY KEY constraint in CREATE TABLE 
are implicitly set to NOT NULL per the SQL spec. 

If a PRIMARY KEY constraint is added using ALTER TABLE then all
columns must also be NOT NULL. Similarly, columns
specified in a UNIQUE constraint must still be explictly NOT NULL.

Changed paths

Path Details
Directoryincubator/derby/code/trunk/java/engine/org/apache/derby/impl/sql/compile/TableElementList.java modified , text changed
Directoryincubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/db2Compatibility.out modified , text changed
Directoryincubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/nulls.out modified , text changed
Directoryincubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/primarykey.out modified , text changed
Directoryincubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/db2Compatibility.sql modified , text changed
Directoryincubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/nulls.sql modified , text changed
Directoryincubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/primarykey.sql modified , text changed

infrastructure at apache.org
ViewVC Help
Powered by ViewVC 1.1.26