On 6/27/18, Mark Wagner <m...@google.com> wrote: > Thanks for all the good background. FWIW this came up because someone had > created a row with something like: (column_name non null). Needless to > say, this created a column without a "not null" constraint.
It should have. I get an error when I type: CREATE TABLE t1(x NOT NULL); INSERT INTO t1(x) VALUES(NULL); I think something else must be going on. Do you have an exact copy of what "someone" typed? -- 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