insert into table test defaults;
On Mon, Jul 4, 2016 at 2:21 PM, gwenn <gwenn.k...@gmail.com> wrote:
> 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
>
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
