... We emphasize that they exist only so that old and ill-formed SQL statements will run correctly. Future versions of SQLite might raise errors instead of accepting the malformed statements covered by the exceptions above. SQLite adds new keywords from ... 

 ... Like other SQL identifiers, schema names are case-insensitive. If a schema name is specified, then only that one schema is searched for the named object. Most object references may only resolve to a specific type of object (for example ... 

 ... Restrictions on UPDATE Statements Within CREATE TRIGGER The following additional syntax restrictions apply to UPDATE statements that occur within the body of a CREATE TRIGGER statement. The table-name specified as part of an UPDATE statement within a trigger body ... 

 ... Simple Select Processing The core of a SELECT statement is a "simple SELECT" shown by the and syntax diagrams below. In practice, most SELECT statements are simple SELECT statements. Generating the results of a simple SELECT statement is presented as ... 

 ... Parsing Ambiguity When the INSERT statement to which the UPSERT is attached takes its values from a SELECT statement, there is a potential parsing ambiguity. The parser might not be able to tell if the "ON" keyword is introducing the ... 

sqlite3_unlock_notify()

 ... When executing a "DROP TABLE" or "DROP INDEX" statement, SQLite checks if there are any currently executing SELECT statements that belong to the same connection. If there are, SQLITE_LOCKED is returned. In this case there is no "blocking connection", so ... 

7. Summary The query planner in SQLite normally does a terrific job of selecting fast algorithms for running your SQL statements. This is true of the legacy query planner and even more true of the new NGQP. There may be an occasional ... 

2.13. The xUpdate Method  ... This will occur when an SQL statement updates a rowid, as in the statement: UPDATE table SET rowid=rowid+1 WHERE ...; The xUpdate method must return SQLITE_OK if and only if it is successful. If a failure occurs, the xUpdate ... 

 ... The iif() function is really a short-hand notation for a CASE expression. For example, the iif(X,Y,Z) function is logically equivalent to and generates the same bytecode as the CASE expression "CASE WHEN X THEN Y ELSE ... 

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

 ... xValue and xInverse may either both be NULL, in which case a regular aggregate function is created, or must both be non-NULL, in which case the new function may be used as either an aggregate or aggregate window function ...