|
If you were logged in you would be able to see more operations.
|
|
|
| Resolution Date: |
09/Mar/05 06:25 AM
|
|
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).
|
|
Description
|
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).
|
Show » |
| No work has yet been logged on this issue.
|
|
Bug
Closed
Minor
PRIMARY KEY does not imply NOT NULL
