Not a bug. Instead of a keyword, you've defined an alias for the table named "limit1".
On Jun 19, 2017 4:00 AM, "Robert Cousins" <r...@rcousins.com> wrote: > Summary: > Leaving out the space after the word 'limit' causes the limit > clause to be ignored. > I've reproduced it on version 3.19.2 2017-05-25 16:50:27 > edb4e819b0c058c7d74d27ebd14cc5ceb2bad6a6144a486a970182b7afe3f8b9 > A sample output is below. > On one hand, this is a failure to catch a syntax error. On the other > hand, the fact that it isn't caught is perhaps problematic and indicates > an underlying parser issue. > Thanx > > sqlite> create table foo(id Integer not null primary key, bar int); > sqlite> insert into foo values (NULL,1),(NULL,2),(NULL,3); > sqlite> select * from foo limit1; > id bar > ---------- ---------- > 1 1 > 2 2 > 3 3 > sqlite> select * from foo limit2; > id bar > ---------- ---------- > 1 1 > 2 2 > 3 3 > sqlite> select * from foo limit 1; > id bar > ---------- ---------- > 1 1 > sqlite> select * from foo limit 2; > id bar > ---------- ---------- > 1 1 > 2 2 > sqlite> > > _______________________________________________ > 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
