*** DRAFT ***
|
The Use Of assert() In SQLite
(assert.html)
1. Assert() And Similar Macros In SQLite
... ALWAYS(X) →
The ALWAYS(X) function indicates that condition X is always true as far
as the developers know, but there is no proof the X is true, or the
proof is complex and error-prone, or the proof ...
|
|
C API: Determine If An SQL Statement Writes The Database
(c3ref/stmt_readonly.html)
sqlite3_stmt_readonly()
The sqlite3_stmt_readonly(X) interface returns true (non-zero) if
and only if the prepared statement X makes no direct changes to
the content of the database file.
Note that application-defined SQL functions or
virtual tables might change the database ...
|
|
Rowid Tables
(rowidtable.html)
... The PRIMARY KEY constraint for a rowid table (as long as it is not
the true primary key or INTEGER PRIMARY KEY) is really the same thing
as a UNIQUE constraint. Because it is not a true primary key,
columns ...
|
|
C API: Determine If Virtual Table Column Access Is For UPDATE
(c3ref/vtab_nochange.html)
sqlite3_vtab_nochange()
If the sqlite3_vtab_nochange(X) routine is called within the xColumn
method of a virtual table, then it might return true if the
column is being fetched as part of an UPDATE operation during which the
column value will not change ...
|
|
The SQLITE_STMT Virtual Table
(stmt.html)
2.1. Columns
... CREATE TABLE sqlite_stmt(
sql TEXT, -- Original SQL text
ncol INT, -- Number of output columns
ro BOOLEAN, -- True for "read only" statements
busy BOOLEAN, -- True if the statement is current running
nscan INT, -- Number of full-scan steps
nsort INT, -- Number ...
|
|
C API: Virtual Table Indexing Information
(c3ref/index_info.html)
struct sqlite3_index_info, struct sqlite3_index_constraint, struct sqlite3_index_orderby ...
... If the omit flag is change to true, then
the constraint may or may not be checked in byte code. In other words,
when the omit flag is true there is no guarantee that the constraint will
not be checked ...
|
|
C API: Mutex Verification Routines
(c3ref/mutex_held.html)
sqlite3_mutex_held(), sqlite3_mutex_notheld()
... These routines should return true if the mutex in their argument
is held or not held, respectively, by the calling thread.
The implementation is not required to provide versions of these
routines that actually work. If the implementation does not ...
|
|
NULL Handling in SQLite
(nulls.html)
... END" is 0?
Yes
Yes
Yes
Yes
Yes
Yes
Yes
"null OR true" is true
Yes
Yes
Yes
Yes
Yes
Yes
Yes
"not (null AND false)" is true
Yes
Yes
Yes
Yes
Yes
Yes
Yes
MySQL3.23.41 ...
|
|
SQL Language Expressions
(lang_expr.html)
... If there already
exists columns or tables or other objects named TRUE or FALSE, then for
the sake of backwards compatibility, the TRUE and FALSE identifiers refer
to those other objects, not to the boolean values.
The boolean identifiers TRUE ...
|
|
C API: Identify and handle IN constraints in xBestIndex
(c3ref/vtab_in.html)
sqlite3_vtab_in()
... A call to sqlite3_vtab_in(P,N,-1) will return true (non-zero)
if and only if the P->aConstraint[N] constraint
is an IN operator that can be processed all at once. In other words,
sqlite3_vtab_in() with -1 in the ...
|
Page generated by FTS5 in about 73.04 ms.