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
8391 i64 nDeferredCons; /* Net deferred constraints this transaction. */
8542 i64 nDeferredCons; /* Number of deferred fk violations */
8827 u8 isDeferred; /* True if constraint checking is deferred till COMMIT */
8853 ** same as ROLLBACK for DEFERRED keys. SETNULL means that the foreign
8868 #define OE_Restrict 6 /* OE_Abort for IMMEDIATE, OE_Rollback for DEFERRED */
17576 i64 movetoTarget; /* Argument to the deferred sqlite3BtreeMoveto() */
22157 ** to close() the file descriptor is deferred until all of the locks clear.
22262 ** locks, the close is deferred until all locks clear by adding the
23132 ** was deferred because of outstanding locks.
25869 ** this reason, the division that implements of proxy locking is deferred
35493 ** of the journal file is deferred until there is an actual need to
49353 ** database handles deferred constraint counter to the value it had when
49392 ** committed. If there are outstanding deferred foreign key constraint
49400 SQLITE_PRIVATE int sqlite3VdbeCheckFk(Vdbe *p, int deferred){
49402 if( (deferred && db->nDeferredCons>0) || (!deferred && p->nFkConstraint>0) ){
49508 ** or hit an 'OR FAIL' constraint and there are no deferred foreign
55073 ** too. If it is a ROLLBACK TO, then set the number of deferred
55227 deferred constraint
55808 ** This is actually a deferred seek. Nothing actually happens until
57464 ** (deferred foreign key constraints). Otherwise, if P1 is zero, the
57483 ** is zero (the one that counts deferred constraint violations). If P1 is
64198 ** the dallocation is deferred until the column cache line that uses
68613 ** to sqlite3DeferForeignKey() might change this to DEFERRED.
68729 ** This routine is called when an INITIALLY IMMEDIATE or INITIALLY DEFERRED
68731 ** parameter is 1 for INITIALLY DEFERRED and 0 for INITIALLY IMMEDIATE.
72812 ** Deferred and Immediate FKs
72815 ** Foreign keys in SQLite come in two flavours: deferred and immediate.
72818 ** deferred foreign key constraint is violated, no action is taken
72822 ** Deferred constraints are implemented using a simple counter associated
72831 ** * When a commit fails due to a deferred foreign key constraint,
73099 ** INSERT deferred Increment the "deferred constraint counter".
73101 ** DELETE deferred Decrement the "deferred constraint counter".
73224 ** deferred, when a row is inserted into the same table. When generating
73240 ** DELETE deferred Increment the "deferred constraint counter".
73244 ** INSERT deferred Decrement the "deferred constraint counter".
73257 int nIncr /* Amount to increment deferred counter by */
73339 ** clause. If the constraint is not deferred, throw an exception for
73340 ** each row found. Otherwise, for deferred constraints, increment the
73341 ** deferred constraint counter by nIncr for each row selected. */
73405 ** (b) The table is the child table of a deferred FK constraint and it is
73406 ** determined at runtime that there are outstanding deferred FK
73421 /* Search for a deferred foreign key constraint for which this table
73424 ** the entire DELETE if there are no outstanding deferred constraints
73604 ** deferred trigger. That's what RESTRICT means. To defer checking
73975 ** classified as either immediate or deferred.
85893 ** the disconnect is deferred until all locks have been removed.
89956 sqlite3VdbeAddOp2(v, OP_Seek, iCur, iRowidReg); /* Deferred seek */
91624 26, /* DEFERRED => ID */
91762 "PLAN", "BEGIN", "TRANSACTION", "DEFERRED",
91846 /* 14 */ "transtype ::= DEFERRED",
91918 /* 86 */ "init_deferred_pred_opt ::= INITIALLY DEFERRED",
92952 case 14: /* transtype ::= DEFERRED */
93009 case 86: /* init_deferred_pred_opt ::= INITIALLY DEFERRED */ yytestcase(yyruleno==86);
94572 testcase( i==98 ); /* DEFERRED */
96187 /* Any deferred constraint violations have now been resolved. */
