Hello, SQLite version 3.13.0 2016-05-18 10:57:30 sqlite> create table test (name text default ''); sqlite> insert into test values (); Error: near ")": syntax error sqlite> insert into test values (''), (); Error: no tables specified
Maybe the parser rule is too permissive: values(A) ::= values(X) COMMA LP exprlist(Y) RP. versus values(A) ::= values(X) COMMA LP nexprlist(Y) RP. Thanks and regards. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users