I have a table using the
GENERATED BY DEFAULT AS IDENTITY(START WITH 1) PRIMARY KEY
autogenerated primary key.
I do an insert into this table and then try to get the generated key using
SELECT IDENTITY_VAL_LOCAL() FROM my_table
And I get two identical rows back.
Why 2 rows?

Tim

Reply via email to