[ http://issues.apache.org/jira/browse/DDLUTILS-11?page=all ] Thomas Dudziak resolved DDLUTILS-11: ------------------------------------
Resolution: Fixed > derby create table syntax > ------------------------- > > Key: DDLUTILS-11 > URL: http://issues.apache.org/jira/browse/DDLUTILS-11 > Project: DdlUtils > Type: Bug > Environment: apache derby 10.1.1.0 > Reporter: dan meany > Assignee: Thomas Dudziak > > Create table syntax for AUTOINCREMENT column and DEFAULT value should be: > CREATE TABLE TEST ( > SEQ_NO INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START > WITH 1, INCREMENT BY 1), > STATUS CHAR(1) NOT NULL DEFAULT 'Y', > PRIMARY KEY (SEQ_NO) > ); -- 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