Data Modeler won't create SQL for identity fields in Firebird

Steps to reproduce:

  1. create a new 'Firebird 3' project
  2. create a new DOMAIN type "Bigint (identity)" --or-- "Integer (identity)"
  3. create a new table, add a field and set to the DOMAIN created
  4. generate the SQL Script. The field won't show 'generated by default as identity' right after the DOMAIN definition as supposed to:
CREATE TABLE TEST (ID DO_SEQ generated by default as identity NOT NULL);

Data Modeler tries to create the identity on the DOMAIN itself but Firebird 3 do not support it, so the CREATE DOMAIN code will fail.


In this case you should use a logical domain instead of a physical domain.

1 Like