Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Application-Defined SQL Functions
(appfunc.html)
3. Security Implications
... In CHECK constraints of a table definition.
In DEFAULT constraints of a table definition.
In the definitions of generated columns.
In the expression part of an index on an expression.
In the WHERE clause of a partial index.
To put ...
|
|
SQLite Autoincrement
(autoinc.html)
3. The AUTOINCREMENT Keyword
... However, if an
insert fails due to (for example) a uniqueness constraint, the ROWID of
the failed insertion attempt might not be reused on subsequent inserts,
resulting in gaps in the ROWID sequence. AUTOINCREMENT guarantees that
automatically chosen ROWIDs will ...
|
|
SQLite Older News
(oldnews.html)
... 2009-10-14 - Version 3.6.19
SQLite version 3.6.19 adds native support for
foreign key constraints, including deferred constraints and
cascading deletes. Enforcement of foreign keys is disabled by
default for backwards compatibility and must be turned ...
|
|
The SQLite R*Tree Module
(rtree.html)
4.1.1. Limitations
... However, future versions
of SQLite might start paying attention to the type affinity and
constraints, so users of auxiliary columns are advised to leave
both blank, to avoid future compatibility problems.
|
|
RETURNING
(lang_returning.html)
... The RETURNING clause
does not report any additional database changes
caused by foreign key constraints or triggers.
A RETURNING clause for an UPSERT reports both inserted and
updated rows.
2.1. Processing Order
When a DELETE, INSERT, or UPDATE statement ...
|
|
UPDATE
(lang_update.html)
... The optional "OR action" conflict clause that follows the
UPDATE keyword allows the user to nominate a specific
constraint conflict resolution algorithm to use during this one UPDATE command.
Refer to the section entitled ON CONFLICT for additional information.
2 ...
|
|
Datatypes In SQLite version 2
(datatypes.html)
... In this case,
the strings '0' and '0.0' are treated as numbers since they are being
inserted into a numeric column but 0==0.0 which violates the uniqueness
constraint. However, the second insert in the right-hand sequence ...
|
|
The C language interface to SQLite Version 2
(c_interface.html)
... SQLITE_CONSTRAINT
This constant is returned if the SQL statement would have violated
a database constraint.
SQLITE_MISMATCH
This error occurs when there is an attempt to insert non-integer
data into a column labeled INTEGER PRIMARY KEY. For most columns, SQLite ...
|
|
C API: Database Connection Configuration Options
(c3ref/c_dbconfig_defensive.html)
SQLITE_DBCONFIG_MAINDBNAME, SQLITE_DBCONFIG_LOOKASIDE, SQLITE_DBCONFIG_ENABLE_FKEY, SQLITE_DBCONFIG_ENABLE_TRIGGER, SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER, SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION ...
... SQLITE_DBCONFIG_ENABLE_FKEY
This option is used to enable or disable the enforcement of
foreign key constraints. This is the same setting that is
enabled or disabled by the PRAGMA foreign_keys statement.
The first argument is an integer which is 0 to ...
|
|
CREATE TRIGGER
(lang_createtrigger.html)
... An error code of SQLITE_CONSTRAINT is returned to the application,
along with the specified error message.
When RAISE(IGNORE) is called, the remainder of the current trigger program,
the statement that caused the trigger program to execute and any subsequent ...
|
Page generated by FTS5 in about 116.01 ms.