* zak mc kracken <[EMAIL PROTECTED]> [2008-01-21 20:10]:
> $ cat error
> create table t(c);
> select c from t; --COMMENT
> $ sqlite < error
> Incomplete SQL: select c from t; --COMMENT
> $ sqlite -version
> 2.8.17
>
> if I remove the '--COMMENT' there is no error... why?
> the problem persist using /*COMMENT*/ style
$ echo -e '\n;' >> error
$ sqlite < x
$
The sqlite shell doesn’t parse SQL, it just looks for a semicolon
as a statement terminator, so it sees your comment after it sees
the SELECT statement, but doesn’t find a terminator after that.
Regards,
--
Aristotle Pagaltzis // <http://plasmasturm.org/>
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
