[ http://issues.apache.org/jira/browse/DERBY-331?page=comments#action_12315325 ]
Daniel John Debrunner commented on DERBY-331: --------------------------------------------- Committed revision 209842 (331b.diff) Sorry for missing this one, noticed it the other day when looking at the release notes, but didn't get back to it. > create table fails when a constraint defintion follows a column default > ----------------------------------------------------------------------- > > Key: DERBY-331 > URL: http://issues.apache.org/jira/browse/DERBY-331 > Project: Derby > Type: Bug > Components: SQL > Versions: 10.0.2.1 > Environment: Windows XP > Reporter: Gin Ng > Assignee: Dag H. Wanvik > Priority: Minor > Attachments: 331b.diff, 331b.stat > > 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). -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
