I suppose ‘select * from (original select with limit clause) limit :lim’ gets round it.
From: Dominique Devienne<mailto:[email protected]> Sent: 16 February 2018 12:21 To: SQLite mailing list<mailto:[email protected]> Subject: Re: [sqlite] LIMIT versus sqlite3_step LIMIT times On Fri, Feb 16, 2018 at 1:11 PM, x <[email protected]> wrote: > Thanks for the replies. For my purpose it was about avoiding the > possibility of having to apply a limit to a query that might already have a > limit clause. Good point. I tried, and indeed that's an issue. I really really which SQLite expose more meta-data about prepared statements :). --DD C:\Users\ddevienne>sqlite3 SQLite version 3.21.0 2017-10-24 18:55:49 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> sqlite> create table t (c); sqlite> insert into t values (1), (2), ('three'); sqlite> select * from t; 1 2 three sqlite> select * from t limit 1; 1 sqlite> select * from t limit 1 limit 2; Error: near "limit": syntax error sqlite> _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
