2. Details The designed query interface is: SELECT DISTINCT candidate COLLATE nocase FROM completion($prefix, $wholeline) ORDER BY 1; The query above will return suggestions for the whole input word that begins with $prefix. The $wholeline parameter is all text from the ... 

 ... Recursive Query Examples The following query returns all integers between 1 and 1000000: WITH RECURSIVE cnt(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM cnt WHERE x<1000000) SELECT x FROM cnt; Consider how this query works ... 

3.1. Scrolling Window Queries  ... What really happens with "LIMIT x OFFSET y" is that SQLite computes the query as "LIMIT x+y" and discards the first y values without returning them to the application. So as the window scrolls down toward the bottom of ... 

sqlite3_get_auxdata(), sqlite3_set_auxdata()

 ... during the original sqlite3_set_auxdata() call if the function is evaluated during query planning instead of during query execution, as sometimes happens with SQLITE_ENABLE_STAT4. Note the last two bullets in particular. The destructor X in sqlite3_set_auxdata(C,N,P,X) might ... 

2.7. Materializations Of Views And Subqueries Queries that contain subqueries must sometime evaluate the subqueries separately and store the results in a temporary table, then use the content of the temporary table to evaluate the outer query. We call this "materializing" the subquery. The query optimizer ... 

 ... If changes occur on the same database connection after a query starts running but before the query completes, then it is undefined whether or not the query will see those changes. If changes occur on the same database connection after ... 

 ... If the query is a "SELECT DISTINCT" query, duplicate rows are removed from the set of result rows. There are two types of simple SELECT statement - aggregate and non-aggregate queries. A simple SELECT statement is an aggregate query if ... 

4. Usage The carray() function can be used in the FROM clause of a query. For example, to query two entries from the OBJ table using rowids taken from a C-language array at address $PTR. SELECT obj.* FROM obj, carray($PTR ... 

sqlite3_open(), sqlite3_open16()

 ... Specifying an unknown parameter in the query component of a URI is not an error. Future versions of SQLite might understand additional query parameters. See "query parameters with special meaning to SQLite" for additional information. URI filename examples URI filenames ... 

 ... In all previous versions of SQLite, a ROLLBACK would cause pending queries to stop immediately and return SQLITE_ABORT or SQLITE_ABORT_ROLLBACK. Pending queries still abort if the ROLLBACK changes the database schema, but as of this patch release, the queries are ...