sqlite3_commit_hook(), sqlite3_rollback_hook()

 ... For the purposes of this API, a transaction is said to have been rolled back if an explicit "ROLLBACK" statement is executed, or an error or constraint causes an implicit rollback to occur. The rollback callback is not invoked if ... 

sqlite3_create_function(), sqlite3_create_function16(), sqlite3_create_function_v2(), sqlite3_create_window_function()

 ... The fourth parameter may also optionally include the SQLITE_DIRECTONLY flag, which if present prevents the function from being invoked from within VIEWs, TRIGGERs, CHECK constraints, generated column expressions, index expressions, or the WHERE clause of partial indexes. For best security ... 

 ... Due to relaxed bin-packing constraints, the 4096-byte page size might actually result in a smaller file, once substantial content is added. This page last modified on 2025-03-07 07:45:37 UTC

sqlite3_changes(), sqlite3_changes64()

 ... Only changes made directly by the INSERT, UPDATE or DELETE statement are considered - auxiliary changes caused by triggers, foreign key actions or REPLACE constraint resolution are not counted. Changes to a view that are intercepted by INSTEAD OF triggers are ... 

 ... The "NOT INDEXED" clause specifies that no index shall be used when accessing the preceding table, including implied indices create by UNIQUE and PRIMARY KEY constraints. However, the rowid can still be used to look up entries even when "NOT ... 

sqlite3_create_collation(), sqlite3_create_collation_v2(), sqlite3_create_collation16()

 ... If a collating function fails any of the above constraints and that collating function is registered and used, then the behavior of SQLite is undefined. The sqlite3_create_collation_v2() works like sqlite3_create_collation() with the addition that the xDestroy callback is invoked on ... 

2.2. Conflicts  ... Some other database constraint, for example a UNIQUE or CHECK constraint, may be violated when the new row is inserted. When processing a DELETE change, the following conflicts may be detected: The target database may contain no row with the ... 

2. Creating Partial Indexes  ... show join-constraint: show join-operator: show ordering-term: show result-column: show table-or-subquery: show window-defn: show frame-spec: show type-name: show signed-number: show indexed-column: show Any index that includes the WHERE clause at ... 

 ... SQLITE_ERROR means that a run-time error (such as a constraint violation) has occurred. sqlite3_step() should not be called again on the VM. More information may be found by calling sqlite3_errmsg(). With the legacy interface, a more specific error code ... 

 ... SQLITE_CHANGESET_CONSTRAINT If any other constraint violation occurs while applying a change (i.e. a UNIQUE, CHECK or NOT NULL constraint), the conflict handler is invoked with CHANGESET_CONSTRAINT as the second argument. There is no conflicting row in this case. The ...