Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Implementation Limits For SQLite
(limits.html)
... Maximum Number Of Terms In A Compound SELECT Statement
A compound SELECT statement is two or more SELECT statements connected
by operators UNION, UNION ALL, EXCEPT, or INTERSECT. We call each
individual SELECT statement within a compound SELECT a "term ...
|
|
Query Planning
(queryplanner.html)
Overview
... For any given SQL statement, there might be hundreds or thousands or
even millions of different algorithms of performing the operation. All
of these algorithms will get the correct answer, though some will run
faster than others.
The query planner ...
|
|
The SQLite Bytecode Engine
(opcode.html)
4. The Opcodes
... If P2 is 0, then SQL statements are expired immediately. If P2 is 1,
then running SQL statements are allowed to continue to run to completion.
The P2==1 case occurs when a CREATE INDEX or similar schema change happens ...
|
|
Recent SQLite News
(news.html)
... code to be generated in some cases, resulting
in an infinite loop in the byte code, or a NULL-pointer dereference.
This patch release also fixes some other minor problems with
assert() statements and in the CLI.
2021-11-27 ...
|
|
Dynamic Memory Allocation In SQLite
(malloc.html)
3.3. Lookaside memory allocator
... This occurs most commonly when compiling SQL statements using
sqlite3_prepare_v2() but also to a lesser extent when running
prepared statements using sqlite3_step(). These small memory
allocations are used to hold things such as the names of tables
and columns, parse ...
|
|
Row Values
(rowvalue.html)
2. Syntax
... Two row values of the same size
can be compared using operators <, <=, >, >=,
=, <>, IS, IS NOT, IN, NOT IN, BETWEEN, or CASE.
In an UPDATE statement, a list of column names can be set to ...
|
|
About SQLite
(about.html)
... An automated test suite runs millions and millions of
test cases involving hundreds of millions of individual SQL statements
and achieves 100% branch test coverage.
SQLite responds gracefully to memory
allocation failures and disk I/O errors. Transactions are
ACID ...
|
|
Command Line Shell For SQLite
(cli.html)
21. Marking The End Of An SQL Statement
... In the CLI
you can also use the word "GO" (case-insensitive) or a slash character
"/" on a line by itself to end a command. These are used by SQL Server
and Oracle, respectively, and are supported by the SQLite ...
|
|
C API: Standard File Control Opcodes
(c3ref/c_fcntl_begin_atomic_write.html)
SQLITE_FCNTL_LOCKSTATE, SQLITE_FCNTL_GET_LOCKPROXYFILE, SQLITE_FCNTL_SET_LOCKPROXYFILE, SQLITE_FCNTL_LAST_ERRNO, SQLITE_FCNTL_SIZE_HINT, SQLITE_FCNTL_CHUNK_SIZE ...
... Whenever a PRAGMA statement is parsed, an SQLITE_FCNTL_PRAGMA
file control is sent to the open sqlite3_file object corresponding
to the database file to which the pragma statement refers. The argument
to the SQLITE_FCNTL_PRAGMA file control is an array of
pointers ...
|
|
Pointer Passing Interfaces
(bindptr.html)
... Since
the FTS3 cursor object contains pointers to other objects, the statement
above would be a pointer leak.
Except, the statement above does not work, thanks to pointer types.
The pointer generated by the MATCH operator has a type of ...
|
Page generated by FTS5 in about 282.08 ms.