*** DRAFT ***
|
The Advantages Of Flexible Typing
(flextypegood.html)
4.3. Rigid type enforcement prevents data pollution
... This is not true. It is true that type enforcement might help prevent
egregiously incorrect data from getting into the system.
But type enforcement is no help in prevent subtly incorrect data
from being recorded.
So, for example, rigid type ...
|
|
SELECT
(lang_select.html)
... Only rows for which the expression evaluates to
true are included from the dataset.
If there is a USING clause
then each of the column names specified must exist in the datasets to
both the left and right of the ...
|
|
Powersafe Overwrite
(psow.html)
... We say that a system has the powersafe overwrite property if the following
statement is true:
When an application writes a range of bytes in a file, no
bytes outside of that range will change, even if the write occurs ...
|
|
Atomic Commit In SQLite
(atomiccommit.html)
2. Hardware Assumptions
... We do not know if this assumption is always true but it
seems reasonable.
The previous paragraph states that SQLite does not assume that
sector writes are atomic. This is true by default. But as of
SQLite version 3.5 ...
|
|
The SQLite Query Optimizer Overview
(optoverview.html)
18. The Constant Propagation Optimization
... CREATE TABLE t1(a INTEGER PRIMARY KEY, b INT, c INT);
SELECT * FROM t1 WHERE a=b AND b=5;
SQLite looks at the "a=b" and "b=5" constraints and deduces that
if those two constraints are true, then ...
|
|
The Session Extension
(sessionintro.html)
3.2. Applying a Changeset to a Database
... Or, if bIgnoreConflicts is
** false, then this call fails with an SQLTIE_ABORT error if a changeset
** conflict is encountered.
*/
int apply_changeset(
sqlite3 *db, /* Database handle */
int bIgnoreConflicts, /* True to ignore conflicting changes */
int nChangeset, /* Size of changeset in bytes */
void ...
|
|
SQLite Changes From Version 3.5.9 To 3.6.0
(35to36.html)
... 3 IN (1,2,NULL)
3 IN (SELECT * FROM x1)
Similarly, the following expressions have historically evaluated to
TRUE when in fact NULL is also the correct answer here:
3 NOT IN (1,2,NULL)
3 NOT IN (SELECT * FROM ...
|
|
Vulnerabilities
(cves.html)
2.3. The SQLite Developer Policy Toward CVEs
... Almost all bugs reported by CVEs are just bugs and not
true vulnerabilities. Claiming that they are vulnerabilities is
stretching the meaning of the word "vulnerability" and the SQLite
developers do not wish to participate in that deception.
The developers ...
|
|
SQLite Over a Network, Caveats and Considerations
(useovernet.html)
... The design
assumptions upon which it relies may hold more true where
an application is tested than where it is relied upon.
Rely upon it at your (and your customers') peril.
See How To Corrupt Your Database Files.
Performance and ...
|
|
CREATE TRIGGER
(lang_createtrigger.html)
... INSERT
NEW references are valid
UPDATE
NEW and OLD references are valid
DELETE
OLD references are valid
If a WHEN clause is supplied, the SQL statements specified
are only executed if the WHEN clause is true.
If no WHEN clause ...
|
Page generated by FTS5 in about 75.33 ms.