db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bernt M. Johnsen" <Bernt.John...@Sun.COM>
Subject Re: "generated by default" question
Date Tue, 30 May 2006 18:20:48 GMT
>>>>>>>>>>>> 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

View raw message