[DDLUTILS-11] derby create table syntax

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.0 RC1
• Component/s: Core - Derby/Cloudscape/JavaDB
• Environment: apache derby 10.1.1.0
• Assignee: Thomas Dudziak
• Reporter: dan meany
• Created: 08/Sep/05 22:16
• Updated: 04/Jun/07 02:34
• Resolved: 19/Sep/05 08:10

Description

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)
);