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