db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tim Dudgeon <tdudg...@informaticsmatters.com>
Subject Re: IDENTITY_VAL_LOCAL() returns 2 rows
Date Tue, 19 Sep 2006 12:47:32 GMT
Barry Books wrote:
> try SELECT IDENTITY_VAL_LOCAL() from sysibm.sysdummy1

Its get more weird!
SELECT IDENTITY_VAL_LOCAL() from sysibm.sysdummy1
returns 1 row


SELECT IDENTITY_VAL_LOCAL() from the_actual_table_name
returns as many rows as there are in the table, all with the value of 
the last ID.

Tim


Mime
View raw message