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

Reply via email to