>>>>>>>>>>>> Michael Segel wrote (2006-05-30 13:09:19): > The issue that we see is that Derby barfs when it hits a row that > was inserted without using the identity value, and Derby doesn't > know how to generate the next identity value. > > That sir, is a bug. > And no, the SQL 2000 spec, as presented in this discussion does not concur > with how derby is implementing their auto sequence generation.
I have not studied this well enough to conclude wether Derby's current behaviour is compliant with the SQL 2000 spec or not. But there is nothing in the Derby charter that requires Derby to be SQL 2000 compliant, so if you're right, Derby is not compliant, but that's no bug, that's a feature, especially if it's documented. > So, when will either Sun or IBM fix this? ;-) -- Bernt Marius Johnsen, Database Technology Group, Staff Engineer, Technical Lead Derby/Java DB Sun Microsystems, Trondheim, Norway
signature.asc
Description: Digital signature
