Lines Matching full:deferred
4666 ** to modify the database connection must be deferred until after the
4724 ** to modify the database connection must be deferred until after the
9016 i64 nDeferredCons; /* Net deferred constraints this transaction. */
9194 i64 nDeferredCons; /* Number of deferred fk violations */
9479 u8 isDeferred; /* True if constraint checking is deferred till COMMIT */
9505 ** same as ROLLBACK for DEFERRED keys. SETNULL means that the foreign
9520 #define OE_Restrict 6 /* OE_Abort for IMMEDIATE, OE_Rollback for DEFERRED */
12031 i64 movetoTarget; /* Argument to the deferred sqlite3BtreeMoveto() */
23677 ** to close() the file descriptor is deferred until all of the locks clear.
24444 ** was deferred because of outstanding locks.
28156 ** this reason, the division that implements of proxy locking is deferred
57267 ** database handles deferred constraint counter to the value it had when
57306 ** committed. If there are outstanding deferred foreign key constraint
57314 SQLITE_PRIVATE int sqlite3VdbeCheckFk(Vdbe *p, int deferred){
57316 if( (deferred && db->nDeferredCons>0) || (!deferred && p->nFkConstraint>0) ){
57431 ** or hit an 'OR FAIL' constraint and there are no deferred foreign
63094 ** too. If it is a ROLLBACK TO, then set the number of deferred
63248 /* Store the current value of the database handles deferred constraint
63845 ** This is actually a deferred seek. Nothing actually happens until
65533 ** (deferred foreign key constraints). Otherwise, if P1 is zero, the
65552 ** is zero (the one that counts deferred constraint violations). If P1 is
72520 ** the dallocation is deferred until the column cache line that uses
76980 ** to sqlite3DeferForeignKey() might change this to DEFERRED.
77096 ** This routine is called when an INITIALLY IMMEDIATE or INITIALLY DEFERRED
77098 ** parameter is 1 for INITIALLY DEFERRED and 0 for INITIALLY IMMEDIATE.
81256 ** Deferred and Immediate FKs
81259 ** Foreign keys in SQLite come in two flavours: deferred and immediate.
81262 ** deferred foreign key constraint is violated, no action is taken
81266 ** Deferred constraints are implemented using a simple counter associated
81275 ** * When a commit fails due to a deferred foreign key constraint,
81543 ** INSERT deferred Increment the "deferred constraint counter".
81545 ** DELETE deferred Decrement the "deferred constraint counter".
81668 ** deferred, when a row is inserted into the same table. When generating
81684 ** DELETE deferred Increment the "deferred constraint counter".
81688 ** INSERT deferred Decrement the "deferred constraint counter".
81701 int nIncr /* Amount to increment deferred counter by */
81784 ** clause. If the constraint is not deferred, throw an exception for
81785 ** each row found. Otherwise, for deferred constraints, increment the
81786 ** deferred constraint counter by nIncr for each row selected. */
81850 ** (b) The table is the child table of a deferred FK constraint and it is
81851 ** determined at runtime that there are outstanding deferred FK
81866 /* Search for a deferred foreign key constraint for which this table
81869 ** the entire DELETE if there are no outstanding deferred constraints
82049 ** deferred trigger. That's what RESTRICT means. To defer checking
82412 ** classified as either immediate or deferred.
94675 ** the disconnect is deferred until all locks have been removed.
99233 sqlite3VdbeAddOp2(v, OP_Seek, iCur, iRowidReg); /* Deferred seek */
100980 26, /* DEFERRED => ID */
101118 "PLAN", "BEGIN", "TRANSACTION", "DEFERRED",
101201 /* 14 */ "transtype ::= DEFERRED",
101273 /* 86 */ "init_deferred_pred_opt ::= INITIALLY DEFERRED",
102304 case 14: /* transtype ::= DEFERRED */
102361 case 86: /* init_deferred_pred_opt ::= INITIALLY DEFERRED */ yytestcase(yyruleno==86);
103943 testcase( i==98 ); /* DEFERRED */
105612 /* Any deferred constraint violations have now been resolved. */
108502 Fts3DeferredToken *pDeferred; /* Deferred search tokens, if any */
108548 ** are deferred, the nDocMatch and nMatch variables are populated based
108557 Fts3DeferredToken *pDeferred; /* Deferred token object for this token */
114650 Fts3DeferredToken *pNext; /* Next in list of deferred tokens */
117227 ** Return the deferred doclist associated with deferred token pDeferred.
117242 ** references to deferred doclists from within the tree of Fts3Expr
117261 ** Delete all cached deferred doclists. Deferred doclists are cached
117291 ** Generate deferred-doclists for all tokens in the pCsr->pDeferred list
117294 ** A deferred-doclist is like any other doclist with position information
117303 Fts3DeferredToken *pDef; /* Used to iterate through deferred tokens */
118312 ** If the phrase pExpr consists entirely of deferred tokens, then all X and
118316 ** not available for deferred tokens.
