On Mon, May 12, 2008 at 7:47 PM, Aran <aran(a)organicdesign.co.nz> wrote:
If the queries which put NULL into AUTOINCREMENT NOT
NULL columns are
changed to insert a zero instead, then MSSQL can use its IDENTITY(1,1)
without requiring nextSequenceValue().
And MySQL will insert a literal zero, which will on the first attempt
insert a bogus ID, and on subsequent attempts either fail due to
duplicate ID or overwrite the existing entry (depending on INSERT vs.
REPLACE). In other words, everything would explode. :)
nextSequenceValue() is needed here, databases just aren't consistent
enough.