On 1/12/15, Dan Ackroyd <dan...@basereality.com> wrote:
> Hi,
>
> It looks like there is an error in the amalgamated file on line 139834:
>
>  "FROM %Q.'%q_segdir' WHERE level BETWEEN ? AND ?"
>             "ORDER BY level DESC, idx ASC",
>
> There is no space between the question mark on the first line, and the
> 'ORDER' on the second line - which should generate invalid syntax I
> believe.

Nope.  In the SQL language, white space is only used to separate
tokens that would otherwise merge to become a single token.  So "?
ORDER" and "?ORDER" are both two tokens.

Probably we did intend to put a space between "?" and the "ORDER", for
readability.  But the fact that the space was omitted is benign.

-- 
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to