Lines Matching full:deferred
4659 ** to modify the database connection must be deferred until after the
4717 ** to modify the database connection must be deferred until after the
9009 i64 nDeferredCons; /* Net deferred constraints this transaction. */
9187 i64 nDeferredCons; /* Number of deferred fk violations */
9472 u8 isDeferred; /* True if constraint checking is deferred till COMMIT */
9498 ** same as ROLLBACK for DEFERRED keys. SETNULL means that the foreign
9513 #define OE_Restrict 6 /* OE_Abort for IMMEDIATE, OE_Rollback for DEFERRED */
12024 i64 movetoTarget; /* Argument to the deferred sqlite3BtreeMoveto() */
23670 ** to close() the file descriptor is deferred until all of the locks clear.
24437 ** was deferred because of outstanding locks.
28149 ** this reason, the division that implements of proxy locking is deferred
57260 ** database handles deferred constraint counter to the value it had when
57299 ** committed. If there are outstanding deferred foreign key constraint
57307 SQLITE_PRIVATE int sqlite3VdbeCheckFk(Vdbe *p, int deferred){
57309 if( (deferred && db->nDeferredCons>0) || (!deferred && p->nFkConstraint>0) ){
57424 ** or hit an 'OR FAIL' constraint and there are no deferred foreign
63087 ** too. If it is a ROLLBACK TO, then set the number of deferred
63241 /* Store the current value of the database handles deferred constraint
63838 ** This is actually a deferred seek. Nothing actually happens until
65526 ** (deferred foreign key constraints). Otherwise, if P1 is zero, the
65545 ** is zero (the one that counts deferred constraint violations). If P1 is
72513 ** the dallocation is deferred until the column cache line that uses
76973 ** to sqlite3DeferForeignKey() might change this to DEFERRED.
77089 ** This routine is called when an INITIALLY IMMEDIATE or INITIALLY DEFERRED
77091 ** parameter is 1 for INITIALLY DEFERRED and 0 for INITIALLY IMMEDIATE.
81249 ** Deferred and Immediate FKs
81252 ** Foreign keys in SQLite come in two flavours: deferred and immediate.
81255 ** deferred foreign key constraint is violated, no action is taken
81259 ** Deferred constraints are implemented using a simple counter associated
81268 ** * When a commit fails due to a deferred foreign key constraint,
81536 ** INSERT deferred Increment the "deferred constraint counter".
81538 ** DELETE deferred Decrement the "deferred constraint counter".
81661 ** deferred, when a row is inserted into the same table. When generating
81677 ** DELETE deferred Increment the "deferred constraint counter".
81681 ** INSERT deferred Decrement the "deferred constraint counter".
81694 int nIncr /* Amount to increment deferred counter by */
81777 ** clause. If the constraint is not deferred, throw an exception for
81778 ** each row found. Otherwise, for deferred constraints, increment the
81779 ** deferred constraint counter by nIncr for each row selected. */
81843 ** (b) The table is the child table of a deferred FK constraint and it is
81844 ** determined at runtime that there are outstanding deferred FK
81859 /* Search for a deferred foreign key constraint for which this table
81862 ** the entire DELETE if there are no outstanding deferred constraints
82042 ** deferred trigger. That's what RESTRICT means. To defer checking
82405 ** classified as either immediate or deferred.
94668 ** the disconnect is deferred until all locks have been removed.
99226 sqlite3VdbeAddOp2(v, OP_Seek, iCur, iRowidReg); /* Deferred seek */
100973 26, /* DEFERRED => ID */
101111 "PLAN", "BEGIN", "TRANSACTION", "DEFERRED",
101194 /* 14 */ "transtype ::= DEFERRED",
101266 /* 86 */ "init_deferred_pred_opt ::= INITIALLY DEFERRED",
102297 case 14: /* transtype ::= DEFERRED */
102354 case 86: /* init_deferred_pred_opt ::= INITIALLY DEFERRED */ yytestcase(yyruleno==86);
103936 testcase( i==98 ); /* DEFERRED */
105599 /* Any deferred constraint violations have now been resolved. */
108474 Fts3DeferredToken *pDeferred; /* Deferred search tokens, if any */
108520 ** are deferred, the nDocMatch and nMatch variables are populated based
108529 Fts3DeferredToken *pDeferred; /* Deferred token object for this token */
114619 Fts3DeferredToken *pNext; /* Next in list of deferred tokens */
117196 ** Return the deferred doclist associated with deferred token pDeferred.
117211 ** references to deferred doclists from within the tree of Fts3Expr
117230 ** Delete all cached deferred doclists. Deferred doclists are cached
117260 ** Generate deferred-doclists for all tokens in the pCsr->pDeferred list
117263 ** A deferred-doclist is like any other doclist with position information
117272 Fts3DeferredToken *pDef; /* Used to iterate through deferred tokens */
118281 ** If the phrase pExpr consists entirely of deferred tokens, then all X and
118285 ** not available for deferred tokens.
