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