sqlite3_blob_open()

 ... This function fails with SQLITE_ERROR if any of the following are true: Database zDb does not exist, Table zTable does not exist within database zDb, Table zTable is a WITHOUT ROWID table, Column zColumn does not exist, Row iRow is ... 

 ... To work around this, the SELECT statement should always include a WHERE clause, even if that WHERE clause is just "WHERE true". Ambiguous use of ON: INSERT INTO t1 SELECT * FROM t2 ON CONFLICT(x) DO UPDATE SET y=excluded ... 

sqlite3_value_blob(), sqlite3_value_double(), sqlite3_value_int(), sqlite3_value_int64(), sqlite3_value_pointer(), sqlite3_value_text ... 

 ... Within the xUpdate method of a virtual table, the sqlite3_value_nochange(X) interface returns true if and only if the column corresponding to X is unchanged by the UPDATE operation that the xUpdate method call was invoked to implement and if ... 

3. Column Names  ... If the schema= argument is omitted, but header is true, then the values found in the first line of the CSV file become the column names. If the schema= argument is omitted and header is false, then the columns are ... 

3.1. No Separate BOOLEAN Datatype  ... Instead, TRUE and FALSE are (normally) represented as integers 1 and 0, respectively. This does not seem to cause many problems, as we seldom get complaints about it. But it is important to recognize. Beginning with SQLite version 3.23 ... 

sqlite3_snapshot_get()

 ... The following must be true for this function to succeed. If any of the following statements are false when sqlite3_snapshot_get() is called, SQLITE_ERROR is returned. The final value of *P is undefined in this case. The database handle must not ... 

sqlite3_enable_shared_cache()

 ... Sharing is enabled if the argument is true and disabled if the argument is false. This interface is omitted if SQLite is compiled with -DSQLITE_OMIT_SHARED_CACHE. The -DSQLITE_OMIT_SHARED_CACHE compile-time option is recommended because the use of shared cache mode is ... 

 ... The default behavior is "true". -nomutex BOOLEAN If true, then all mutexes for the database connection are disabled. This provides a small performance boost in single-threaded applications. -readonly BOOLEAN If true, then open the database file read-only. If ... 

sqlite3_soft_heap_limit64(), sqlite3_hard_heap_limit64()

 ... The heap limits are not enforced in the current implementation if one or more of following conditions are true: The limit value is set to zero. Memory accounting is disabled using a combination of the sqlite3_config(SQLITE_CONFIG_MEMSTATUS,...) start-time option ... 

2.8. The xEof Method int (*xEof)(sqlite3_vtab_cursor*); The xEof method must return false (zero) if the specified cursor currently points to a valid row of data, or true (non-zero) otherwise. This method is called by the SQL engine immediately after each xFilter and ...