Lines Matching full:deferred
4332 ** to modify the database connection must be deferred until after the
4392 ** to modify the database connection must be deferred until after the
8396 i64 nDeferredCons; /* Net deferred constraints this transaction. */
8547 i64 nDeferredCons; /* Number of deferred fk violations */
8832 u8 isDeferred; /* True if constraint checking is deferred till COMMIT */
8858 ** same as ROLLBACK for DEFERRED keys. SETNULL means that the foreign
8873 #define OE_Restrict 6 /* OE_Abort for IMMEDIATE, OE_Rollback for DEFERRED */
17581 i64 movetoTarget; /* Argument to the deferred sqlite3BtreeMoveto() */
22162 ** to close() the file descriptor is deferred until all of the locks clear.
22267 ** locks, the close is deferred until all locks clear by adding the
23137 ** was deferred because of outstanding locks.
25874 ** this reason, the division that implements of proxy locking is deferred
35498 ** of the journal file is deferred until there is an actual need to
49364 ** database handles deferred constraint counter to the value it had when
49403 ** committed. If there are outstanding deferred foreign key constraint
49411 SQLITE_PRIVATE int sqlite3VdbeCheckFk(Vdbe *p, int deferred){
49413 if( (deferred && db->nDeferredCons>0) || (!deferred && p->nFkConstraint>0) ){
49519 ** or hit an 'OR FAIL' constraint and there are no deferred foreign
55084 ** too. If it is a ROLLBACK TO, then set the number of deferred
55238 /* Store the current value of the database handles deferred constraint
55819 ** This is actually a deferred seek. Nothing actually happens until
57475 ** (deferred foreign key constraints). Otherwise, if P1 is zero, the
57494 ** is zero (the one that counts deferred constraint violations). If P1 is
64209 ** the dallocation is deferred until the column cache line that uses
68624 ** to sqlite3DeferForeignKey() might change this to DEFERRED.
68740 ** This routine is called when an INITIALLY IMMEDIATE or INITIALLY DEFERRED
68742 ** parameter is 1 for INITIALLY DEFERRED and 0 for INITIALLY IMMEDIATE.
72823 ** Deferred and Immediate FKs
72826 ** Foreign keys in SQLite come in two flavours: deferred and immediate.
72829 ** deferred foreign key constraint is violated, no action is taken
72833 ** Deferred constraints are implemented using a simple counter associated
72842 ** * When a commit fails due to a deferred foreign key constraint,
73110 ** INSERT deferred Increment the "deferred constraint counter".
73112 ** DELETE deferred Decrement the "deferred constraint counter".
73235 ** deferred, when a row is inserted into the same table. When generating
73251 ** DELETE deferred Increment the "deferred constraint counter".
73255 ** INSERT deferred Decrement the "deferred constraint counter".
73268 int nIncr /* Amount to increment deferred counter by */
73350 ** clause. If the constraint is not deferred, throw an exception for
73351 ** each row found. Otherwise, for deferred constraints, increment the
73352 ** deferred constraint counter by nIncr for each row selected. */
73416 ** (b) The table is the child table of a deferred FK constraint and it is
73417 ** determined at runtime that there are outstanding deferred FK
73432 /* Search for a deferred foreign key constraint for which this table
73435 ** the entire DELETE if there are no outstanding deferred constraints
73615 ** deferred trigger. That's what RESTRICT means. To defer checking
73986 ** classified as either immediate or deferred.
85904 ** the disconnect is deferred until all locks have been removed.
89967 sqlite3VdbeAddOp2(v, OP_Seek, iCur, iRowidReg); /* Deferred seek */
91635 26, /* DEFERRED => ID */
91773 "PLAN", "BEGIN", "TRANSACTION", "DEFERRED",
91857 /* 14 */ "transtype ::= DEFERRED",
91929 /* 86 */ "init_deferred_pred_opt ::= INITIALLY DEFERRED",
92963 case 14: /* transtype ::= DEFERRED */
93020 case 86: /* init_deferred_pred_opt ::= INITIALLY DEFERRED */ yytestcase(yyruleno==86);
94583 testcase( i==98 ); /* DEFERRED */
96200 /* Any deferred constraint violations have now been resolved. */
111165 ** Change the default behavior of BEGIN to IMMEDIATE instead of DEFERRED.