Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (asf.osuosl.org: local policy)
Date: Tue, 30 May 2006 20:20:48 +0200
From: "Bernt M. Johnsen" <Bernt.Johnsen@Sun.COM>
Subject: Re: "generated by default" question
In-reply-to: <200605301309.19884.derby@segel.com>
Sender: Bernt.Johnsen@Sun.COM
To: Derby Discussion <derby-user@db.apache.org>, derby@segel.com
Message-id: <20060530182048.GB21158@localhost.localdomain>
Organization: Sun Microsystems
MIME-version: 1.0
Content-type: multipart/signed; boundary=uAKRQypu60I7Lcqm;
 protocol="application/pgp-signature"; micalg=pgp-sha1
Content-disposition: inline
References: <20060530144043.52834243A4@dbrack01.segel.com>
 <DD522070-780A-4C31-B095-0009E49EFEA2@SUN.com>
 <d9619e4a0605300902n5038df99x4fd6e909c4492e6@mail.gmail.com>
 <200605301309.19884.derby@segel.com>
User-Agent: Mutt/1.5.9i


--uAKRQypu60I7Lcqm
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

>>>>>>>>>>>> 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.
>=20
> That sir, is a bug.
> And no, the SQL 2000 spec, as presented in this discussion does not concu=
r=20
> 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? ;-)


--=20
Bernt Marius Johnsen, Database Technology Group,=20
Staff Engineer, Technical Lead Derby/Java DB
Sun Microsystems, Trondheim, Norway

--uAKRQypu60I7Lcqm
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFEfI0AlFBD9TXBAPARAp86AJoCwVwDa/LIId0X2ai8Wo8smHPc3wCfQBHB
3PgARNUWYZL8Q6AS2y5vRYI=
=PlpS
-----END PGP SIGNATURE-----

--uAKRQypu60I7Lcqm--