db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Paul J. Lucas" <pauljlu...@mac.com>
Subject Re: Atomicity of using IDENTITY_VAL_LOCAL()
Date Fri, 13 May 2005 18:43:35 GMT
On Fri, 13 May 2005, Mamta Satoor wrote:

> The SELECT IDENTITY_VAL_LOCAL() FROM mytable1 will return the value that got
> into generated for *any* table with identity column using single row insert
> with values clause in the current transaction.
                      ^^^^^^^^^^^^^^^^^^^^^^^^^^

 	That nugget of information is not in the documentation I don't
 	believe.  So that implies that if there are two open
 	transactions in two different threads and each does an insert,
 	then each thread will get its respective "correct" value for
 	IDENTITY_VAL_LOCAL().

 	Right?

 	- Paul

Mime
View raw message