[DERBY-331] create table fails when a constraint defintion follows a column default

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 10.0.2.1
• Fix Version/s: 10.1.3.1, 10.2.1.6
• Component/s: SQL
• Environment: Windows XP
• Assignee: Dag H. Wanvik
• Reporter: Gin Ng
• Created: 01/Jun/05 04:02
• Updated: 10/Jun/06 21:01
• Resolved: 10/Jun/06 21:01

Description

The following statement fails with syntax error.

ij> create table t (a int not null, b int default 0, unique (a));
ERROR 42X01: Syntax error: Encountered "0" at line 1, column 47.

And it will work if I remove either default 0 or unique(a).