flamerobin icon indicating copy to clipboard operation
flamerobin copied to clipboard

IDENTITY columns not generated in DDL when using custom domains

Open arvanus opened this issue 4 months ago • 0 comments

FlameRobin fails to generate GENERATED BY DEFAULT AS IDENTITY clauses in CREATE TABLE DDL scripts when the IDENTITY column uses a custom domain instead of a system domain. Steps to Reproduce

  1. Create a custom domain: CREATE DOMAIN DOM_ID AS INTEGER;
  2. Create a table with an IDENTITY column using the custom domain: CREATE TABLE TEST_TABLE ( ID DOM_ID GENERATED BY DEFAULT AS IDENTITY, NAME VARCHAR(50) );
  3. Use FlameRobin's "Extract DDL" feature on the table
  4. Observe the generated DDL

Expected Behavior

The generated DDL should include the IDENTITY clause: CREATE TABLE TEST_TABLE ( ID DOM_ID GENERATED BY DEFAULT AS IDENTITY, NAME VARCHAR(50) );

Actual Behavior

The generated DDL is missing the IDENTITY clause: CREATE TABLE TEST_TABLE ( ID DOM_ID, NAME VARCHAR(50) );

arvanus avatar Aug 16 '25 13:08 arvanus