Small. Fast. Reliable.
Choose any three.
Choose any three.
|
SQLite Frequently Asked Questions
(faq.html)
... But enforcement
of foreign key constraints is turned off by default (for backwards compatibility).
To enable foreign key constraint enforcement, run
PRAGMA foreign_keys=ON or compile with
-DSQLITE_DEFAULT_FOREIGN_KEYS=1.
(23) I get a compiler error if I use the SQLITE_OMIT_ ...
|
|
Datatypes In SQLite version 2
(datatypes.html)
... the second insert will fail. 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 ...
|
|
Pragma statements supported by SQLite
(pragma.html)
PRAGMA foreign_key_check
... The fourth column is the index of
the specific foreign key constraint that failed. The fourth column
in the output of the foreign_key_check pragma is the same integer as
the first column in the output of the foreign_key_list pragma.
When ...
|
|
CREATE TRIGGER
(lang_createtrigger.html)
... one of RAISE(ROLLBACK,...), RAISE(ABORT,...) or RAISE(FAIL,...)
is called during trigger-program
execution, the specified ON CONFLICT processing is performed and
the current query terminates.
An error code of SQLITE_CONSTRAINT is returned to the application,
along with the ...
|
|
Dynamic Memory Allocation In SQLite
(malloc.html)
1. Features
... SQLite can be configured so that, subject to certain usage constraints
detailed below, it is guaranteed to never fail a memory allocation
or fragment the heap.
This property is important to long-running, high-reliability
embedded systems where a memory ...
|
|
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 ...
|
|
SQLite Session Module C/C++ Interface
(session.html)
... If the attempt to insert the row fails because of some other constraint
violation (e.g. NOT NULL or UNIQUE), the conflict handler function is
invoked with the second argument set to SQLITE_CHANGESET_CONSTRAINT.
This includes the case where the INSERT ...
|
|
The SQLite Bytecode Engine
(opcode.html)
4. The Opcodes
... NOT NULL constraint failed: P4
2: UNIQUE constraint failed: P4
3: CHECK constraint failed: P4
4: FOREIGN KEY constraint failed: P4
If P3 is zero and P5 is not zero and P4 is NULL, then everything after
the ":" is omitted ...
|
|
The Session Extension
(sessionintro.html)
... Some other database constraint, for example a UNIQUE or CHECK
constraint, may be violated when the new row is inserted.
When processing a DELETE change, the following conflicts may be
detected:
The target database may contain no row with the ...
|
|
The Tcl interface to the SQLite library
(tclsqlite.html)
... If the open succeeds, a new Tcl command named by the first argument is created
and "" is returned.
(This approach is similar to the way widgets are created in Tk.)
If the open fails, an error is raised without creating ...
|
Page generated by FTS5 in about 84.83 ms.