dynamobi/dynamobi — Issue #339: [FRG-428] GENERATED...AS IDENTITY not showing up in ddl gen
Author: dynamobi-build
Created: 2011-12-30 02:33:26+00:00
State: open
Labels: DDL, FRG

[reporter="ksecretan", created="Tue, 5 Jul 2011 18:29:45 -0500 (GMT-05:00)"]
0: jdbc:luciddb:> create table web_activity_capture.load_status_log

. . . . . . . . > (

. . . . . . . . > id BIGINT GENERATED ALWAYS AS IDENTITY NOT NULL,

. . . . . . . . > filename VARCHAR(200) NOT NULL,

. . . . . . . . > commenced_date DATE NOT NULL,

. . . . . . . . > commenced_ts TIMESTAMP NOT NULL,

. . . . . . . . > complete_date DATE,

. . . . . . . . > complete_ts TIMESTAMP,

. . . . . . . . > status VARCHAR(10) NOT NULL,

. . . . . . . . > message VARCHAR(200),

. . . . . . . . > CONSTRAINT load_status_log_pk PRIMARY KEY (id),

. . . . . . . . > CONSTRAINT load_status_log_filename_unique UNIQUE (filename)

. . . . . . . . > );

select * from table(sys_root.generate_ddl_for_table('WEB_ACTIVITY_CAPTURE', 'LOAD_STATUS_LOG'));

+---------------------------------------------------------------------+

| STATEMENT |

+---------------------------------------------------------------------+

| CREATE TABLE "WEB_ACTIVITY_CAPTURE"."LOAD_STATUS_LOG" ( |

| "ID" BIGINT NOT NULL, |

| "FILENAME" VARCHAR(200) NOT NULL,|

| "COMMENCED_DATE" DATE NOT NULL, |

| "COMMENCED_TS" TIMESTAMP NOT NULL, |

| "COMPLETE_DATE" DATE, |

| "COMPLETE_TS" TIMESTAMP, |

| "STATUS" VARCHAR(10) NOT NULL, |

| "MESSAGE" VARCHAR(200), |

| PRIMARY KEY ("ID"), |

| CONSTRAINT "LOAD_STATUS_LOG_FILENAME_UNIQUE" UNIQUE("FILENAME") |

| ); |

+---------------------------------------------------------------------+