SQLITE_SCANSTAT_NLOOP, SQLITE_SCANSTAT_NVISIT, SQLITE_SCANSTAT_EST, SQLITE_SCANSTAT_NAME, SQLITE_SCANSTAT_EXPLAIN, SQLITE_SCANSTAT_SELECTID ... 

 ... SQLITE_SCANSTAT_NAME The "const char *" variable pointed to by the V parameter will be set to a zero-terminated UTF-8 string containing the name of the index or table used for the X-th loop. SQLITE_SCANSTAT_EXPLAIN The "const char *" variable ... 

7. Options To Enable Features Normally Turned Off  ... However, the use of a covering index for a full scan will cause results to appear in a different order from legacy, which could cause some (incorrectly-coded) legacy applications to break. Hence, the covering index scan option can be ... 

3. Aggregated Data  ... Column Normal meaning Aggregate-mode meaning name The name of the table or index that is implemented by the btree of the current row path See description above Always NULL pageno The page number of the database page for the ... 

 ... The INDEXED BY and NOT INDEXED clauses are not allowed on UPDATE statements within triggers. The LIMIT and ORDER BY clauses for UPDATE are unsupported within triggers, regardless of the compilation options used to build SQLite. 2.2. UPDATE FROM ... 

sqlite3_blob_open()

 ... row iRow contains a value that is not a TEXT or BLOB value, Column zColumn is part of an index, PRIMARY KEY or UNIQUE constraint and the blob is being opened for read/write access, Foreign key constraints are enabled ... 

 ... The INDEXED BY and NOT INDEXED clauses are not supported for UPDATE and DELETE statements. The ORDER BY and LIMIT clauses on UPDATE and DELETE statements are not supported. ORDER BY and LIMIT are not normally supported for UPDATE or ... 

 ... These problems could results in incorrect query results or corrupt indexes. See the associated forum threads for details. Other trifling fixes are also included in the patch. 2024-01-30 - Version 3.45.1 Version 3.45.1 is a ... 

sqlite3_prepare(), sqlite3_prepare_v2(), sqlite3_prepare_v3(), sqlite3_prepare16(), sqlite3_prepare16_v2(), sqlite3_prepare16_v3()

 ... The specific value of a WHERE-clause parameter might influence the choice of query plan if the parameter is the left-hand side of a LIKE or GLOB operator or if the parameter is compared to an indexed column and ... 

 ... dbcmd  preupdate  count dbcmd  preupdate  depth dbcmd  preupdate  new  INDEX dbcmd  preupdate  old  INDEX The count submethod returns the number ... 

 ... Columns are zero-indexed from left to right. Note that this is different to parameters, which are indexed starting at one. The sqlite3_column_type() function returns the datatype for the value in the Nth column. The return value is one of ...