Small. Fast. Reliable.
Choose any three.
Choose any three.
|
The Bytecode() And Tables_Used() Table-Valued Functions
(bytecodevtab.html)
2. Usage
... They both require a single argument which is the SQL statement to be
analyzed. For example:
SELECT * FROM bytecode('SELECT * FROM bytecode(?1)');
The argument can be either the text of an SQL statement, in which case
the bytecode (or ...
|
|
SQLite Unlock-Notify API
(unlock_notify.html)
... If a "DROP TABLE" or "DROP INDEX" SQL command is executed, and the
same database connection currently has one or more actively
executing SELECT statements, then SQLITE_LOCKED is returned. If
sqlite3_unlock_notify() is called in this case, then the specified
callback ...
|
|
The Use Of assert() In SQLite
(assert.html)
2. Examples
... true
for all of the hundreds of millions of test cases run against SQLite,
since it has been verified by the assert().
In contrast, a text pre-condition statement in a header comment
is untested. It might have been true ...
|
|
How SQLite Is Tested
(testing.html)
7.1. Statement versus branch coverage
... If any one of those instructions is ever evaluated, then
we say that the statement has been tested. So, for example, it might
be the case that the conditional expression is
always false and the "d" variable is
never incremented ...
|
|
SQL Language Expressions
(lang_expr.html)
... or DELETE statement,
the ON or USING clause of a join in a SELECT statement,
the HAVING clause of a SELECT statement,
the WHEN clause of an SQL trigger, and
the WHEN clause or clauses of some CASE expressions.
To ...
|
|
C API: Number of columns in a result set
(c3ref/data_count.html)
sqlite3_data_count()
The sqlite3_data_count(P) interface returns the number of columns in the
current row of the result set of prepared statement P.
If prepared statement P does not have results ready to return
(via calls to the sqlite3_column() family of
interfaces ...
|
|
NULL Handling in SQLite
(nulls.html)
... This involved making NULLs
indistinct for the purposes of the SELECT DISTINCT statement and
for the UNION operator in a SELECT. NULLs are still distinct
in a UNIQUE column. This seems somewhat arbitrary, but the desire
to be compatible with ...
|
|
CREATE TABLE
(lang_createtable.html)
... Tables are removed using the DROP TABLE statement.
2.1. CREATE TABLE ... AS SELECT Statements
A "CREATE TABLE ... AS SELECT" statement creates and populates a database
table based on the results of a SELECT statement. The table has the same ...
|
|
C API: Determine If Virtual Table Column Access Is For UPDATE
(c3ref/vtab_nochange.html)
sqlite3_vtab_nochange()
... If the xColumn method calls sqlite3_vtab_nochange() and finds that
the column is not changed by the UPDATE statement, then the xColumn
method can optionally return without setting a result, without calling
any of the sqlite3_result_xxxxx() interfaces.
In that case, sqlite3_value_nochange ...
|
|
The SQLITE_DBPAGE Virtual Table
(dbpage.html)
2.2. Truncating A Database
... However, as a special case, doing an INSERT
of a NULL into page 2 or greater as the last operation prior to COMMIT
causes the page being inserted into and all subsequent pages to be deleted,
truncating the database. For ...
|
Page generated by FTS5 in about 253.29 ms.