On Mon, May 12, 2008 at 7:47 PM, Aran aran@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.