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
- IDENTITY_VAL_LOCAL() returns 2 rows Tim Dudgeon
- Re: IDENTITY_VAL_LOCAL() returns 2 rows Barry Books
- Re: IDENTITY_VAL_LOCAL() returns 2 rows Tim Dudgeon
- Re: IDENTITY_VAL_LOCAL() returns 2 rows Dan Scott
- Re: IDENTITY_VAL_LOCAL() returns 2 rows Barry Books
