Please ignore the previous reply,
I see your concern is not the error message but indeed the difference in
messages for what seems to be a similar error (knowingly so).
On 2016/07/04 8:21 PM, gwenn wrote:
Hello,
SQLite version 3.13.0 2016-05-18 10:57:30
sqlite> create table test (name text
On 2016/07/04 8:21 PM, gwenn 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
The documentation is
insert into table test defaults;
On Mon, Jul 4, 2016 at 2:21 PM, gwenn 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
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) ::=
4 matches
Mail list logo