Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Recent SQLite News
(news.html)
... The "old.*" values in an UPDATE trigger might be incorrect
if the trigger fires in response to an UPSERT.
The sum() function might return NULL in some cases where Infinity
would be a better answer.
None of the problems are ...
|
|
SQLite Older News
(oldnews.html)
... The second major enhancement is that SQLite now support recursive
triggers. The older non-recursive behavior of triggers is still the
default behavior. Recursive triggers are activated using the
recursive_triggers pragma. In addition to allowing triggers to
call themselves (either ...
|
|
Database File Format
(fileformat.html)
2.6. Storage Of The SQL Database Schema
... For a trigger, the tbl_name
column stores the name of the table or view that causes the trigger
to fire.
The sqlite_schema.rootpage column stores the page number of the root
b-tree page for tables and indexes. For rows ...
|
|
SQLite FTS5 Extension
(fts5.html)
4.4.3. External Content Tables
... CREATE TABLE tbl(a INTEGER PRIMARY KEY, b, c);
CREATE VIRTUAL TABLE fts_idx USING fts5(b, c, content='tbl', content_rowid='a');
-- Triggers to keep the FTS index up to date.
CREATE TRIGGER tbl_ai AFTER INSERT ON tbl BEGIN
INSERT INTO ...
|
|
The SQLite Bytecode Engine
(opcode.html)
2.5. Subroutines, Coroutines, and Subprograms
... Since bytecode
subroutines are not reentrant a different mechanism must be used to
implement triggers. Each trigger is implemented using a separate bytecode
program with its own opcodes, program counter, and register set. The
Program opcode invokes the trigger subprogram ...
|
|
Compile-time Options
(compile.html)
9. Options To Omit Features
... SQLITE_OMIT_TRIGGER
Defining this option omits support for TRIGGER objects. Neither the
CREATE TRIGGER or DROP TRIGGER
commands are available in this case, and attempting to execute
either will result in a parse error.
This option also disables enforcement of foreign ...
|
|
Temporary Files Used By SQLite
(tempfiles.html)
2.6. TEMP Databases
... These TEMP tables, together
with any associated indices, triggers, and views, are collectively
stored in a separate temporary database file that is created as
soon as the first "CREATE TEMP TABLE" statement is seen.
This separate temporary database file also ...
|
|
SQLite FTS3 and FTS4 Extensions
(fts3.html)
6.2.2. External Content FTS4 Tables
... CREATE TRIGGER t2_bu BEFORE UPDATE ON t2 BEGIN
DELETE FROM t3 WHERE docid=old.rowid;
END;
CREATE TRIGGER t2_bd BEFORE DELETE ON t2 BEGIN
DELETE FROM t3 WHERE docid=old.rowid;
END;
CREATE TRIGGER t2_au AFTER UPDATE ON t2 BEGIN ...
|
|
Result and Error Codes
(rescode.html)
6. Result Code Meanings
... SQLITE_CONSTRAINT_TRIGGER
The SQLITE_CONSTRAINT_TRIGGER error code
is an extended error code
for SQLITE_CONSTRAINT indicating that a RAISE function within
a trigger fired, causing the SQL statement to abort.
(2058) SQLITE_IOERR_UNLOCK
The SQLITE_IOERR_UNLOCK error code is an extended error code
for SQLITE_IOERR ...
|
|
CREATE TABLE
(lang_createtable.html)
... It is not an error to create a table that has the same name as an
existing trigger.
Tables are removed using the DROP TABLE statement.
2.1. CREATE TABLE ... AS SELECT Statements
A "CREATE TABLE ... AS SELECT" statement creates ...
|
Page generated by FTS5 in about 50.92 ms.