db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tim Dudgeon <tdudg...@informaticsmatters.com>
Subject IDENTITY_VAL_LOCAL() returns 2 rows
Date Tue, 19 Sep 2006 08:18:27 GMT


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


Mime
View raw message