db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mark Thornton <mthorn...@optrak.co.uk>
Subject default (0)
Date Wed, 15 Aug 2007 14:20:00 GMT
Derby 10.2.2 appears to reject constant expressions enclosed in 
parentheses (which should still be constant).

CREATE TABLE APP.ArcConstraintGroups (
ConstraintGroupID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
Name VARCHAR(128),
usePenaltyCosts SMALLINT DEFAULT (0),
Description LONG VARCHAR,
matrixID INTEGER NOT NULL,
CONSTRAINT PK__ArcConstraintGro__762C88DA PRIMARY KEY (ConstraintGroupID)
)

results in

java.sql.SQLSyntaxErrorException: Syntax error: Encountered "(" at line 
5, column 34.

Regards,
Mark Thornton


Mime
View raw message