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
Assigned to: 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
