Probably because altering a table is done by changing the value of
column SQL in table 'sqlite_master'.
Adding a unique constraint requires value checks.
On 12.2.2019 6:15, Mark Wagner wrote:
This is mainly for my curiosity. Is there any particular reason that one
can't add a unique column on an alter table? With a default value of null
they would all have unique values by default.
Any insight into this would be great. Perhaps there' something obvious I'm
missing.
-- Mark
_______________________________________________
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