This has been the case since Microsoft stole SQL Server from Sybase (where it is/was the case as well).
> -----Original Message----- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > On Behalf Of James K. Lowden > Sent: Thursday, 3 November, 2016 19:50 > To: SQLite mailing list > Subject: Re: [sqlite] Autoincrement sequence not updated by UPDATE > > On Tue, 1 Nov 2016 11:01:24 +0000 > Simon Slavin <slav...@bigfraud.org> wrote: > > > attempts to change a value in that column using UPDATE always > > generate an error. I didn't know that. I looked it up. Apparently > > Microsoft's SQLSERVER blocks it > > Blocks but does not prevent. > https://msdn.microsoft.com/en-us/library/ms188059.aspx > > --jkl > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users