struct sqlite3_pcache_methods2

 ... The third argument to xCreate(), bPurgeable, is true if the cache being created will be used to cache database pages of a file stored on disk, or false if it is used for an in-memory database. The cache implementation ... 

 ... iif(X,Y,Z) The iif(X,Y,Z) function returns the value Y if X is true, and Z otherwise. The iif(X,Y,Z) function is logically equivalent to and generates the same bytecode as the CASE expression ... 

6. Summary  ... This is true of the legacy query planner and even more true of the new NGQP. There may be an occasional situation where, due to incomplete information, the query planner selects a suboptimal plan. This will happen less often with ... 

 ... Otherwise, the UPDATE affects only those rows for which the WHERE clause boolean expression is true. It is not an error if the WHERE clause does not evaluate to true for any row in the table - this just means that ... 

 ... After any attempt to obtain a write-lock on a table fails (because one or more other connections are holding read-locks), all attempts to open new transactions on the shared-cache fail until one of the following is true ... 

 ... If a FILTER clause is provided, then only rows for which the expr is true are included in the aggregate. 2. List of built-in aggregate functions avg(X) count(*) count(X) group_concat(X) group_concat(X,Y) max(X) min ... 

 ... To avoid a parsing ambiguity, the SELECT statement should always contain a WHERE clause, even if that clause is simply "WHERE true", if the is present. Without the WHERE clause, the parser does not know if the token "ON" is ... 

7.3. Forcing coverage of boundary values and boolean vector tests  ... The argument is a condition for which we want test cases that evaluate to both true and false. In non-coverage builds (that is to say, in release builds) the testcase() macro is a no-op: #define testcase(X) But ... 

struct sqlite3_io_methods

 ... It returns true if such a lock exists and false otherwise. The xFileControl() method is a generic interface that allows custom VFS implementations to directly control an open file using the sqlite3_file_control() interface. The second "op" argument is an integer ... 

 ... A Warranty of Title is a legal document that asserts that the claimed authors of SQLite are the true authors, and that the authors have the legal right to dedicate the SQLite to the public domain, and that Hwaci will ...