And that is why several SQL Engines prevent AUTOINCREMENT columns from
being UPDATEd.
I think it should be fixed in the Docs, not in Code.
Richard Hipp schrieb am 31.10.2016 um 18:56:
Note that the implied purpose of AUTOINCREMENT is to generate a unique
and immutable identifier. Running an UPDATE on an immutable
identifier breaks the contract. Even though this contract was not
previously stated in the documentation, apparently most people
understood it because this issue has never come up before in 14 years
of heavy use.
Thanks for pointing out the problem.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
