db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Barry Books" <trs...@gmail.com>
Subject Re: IDENTITY_VAL_LOCAL() returns 2 rows
Date Tue, 19 Sep 2006 15:49:30 GMT
sysibm.sysdummy1 has 1 row in it. If you do
select 1 from myTable
you will also get as many rows as are in the table. I often do
select * from myTable where key = IDENTITY_VAL_LOCAL() to get back
what's really in the table after triggers, default values etc.

If you don't have a where it's likely you will get more than 1 row.

View raw message