flamerobin
flamerobin copied to clipboard
IDENTITY columns not generated in DDL when using custom domains
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
- Create a custom domain: CREATE DOMAIN DOM_ID AS INTEGER;
- 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) );
- Use FlameRobin's "Extract DDL" feature on the table
- 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) );