On 6/12/17, gwenn <gwenn.k...@gmail.com> wrote:
> invalid column constraints are ignored.

This is a consequence of designing SQLite according to Postel's Law
(https://en.wikipedia.org/wiki/Robustness_principle) which was very
popular 17 years ago when SQLite was being designed, but nowadays has
fallen out of favor.  It cannot be changed now because doing so might
break some of the millions of applications that were written against
SQLite over the past nearly two decades and which make use of SQLite's
liberal parsing policies.

-- 
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to