Lines Matching full:deferred
5099 ** to modify the database connection must be deferred until after the
5158 ** to modify the database connection must be deferred until after the
9799 i64 nDeferredCons; /* Net deferred constraints this transaction. */
9978 i64 nDeferredCons; /* Number of deferred fk violations */
10254 u8 isDeferred; /* True if constraint checking is deferred till COMMIT */
10280 ** same as ROLLBACK for DEFERRED keys. SETNULL means that the foreign
10295 #define OE_Restrict 6 /* OE_Abort for IMMEDIATE, OE_Rollback for DEFERRED */
12896 i64 movetoTarget; /* Argument to the deferred sqlite3BtreeMoveto() */
25967 ** to close() the file descriptor is deferred until all of the locks clear.
26773 ** was deferred because of outstanding locks.
30624 ** this reason, the division that implements of proxy locking is deferred
61570 ** database handles deferred constraint counter to the value it had when
61582 ** committed. If there are outstanding deferred foreign key constraint
61590 SQLITE_PRIVATE int sqlite3VdbeCheckFk(Vdbe *p, int deferred){
61592 if( (deferred && db->nDeferredCons>0) || (!deferred && p->nFkConstraint>0) ){
61711 ** or hit an 'OR FAIL' constraint and there are no deferred foreign
67624 ** too. If it is a ROLLBACK TO, then set the number of deferred
67790 /* Store the current value of the database handles deferred constraint
68418 ** This is actually a deferred seek. Nothing actually happens until
70171 ** (deferred foreign key constraints). Otherwise, if P1 is zero, the
70190 ** is zero (the one that counts deferred constraint violations). If P1 is
78381 ** the dallocation is deferred until the column cache line that uses
83389 ** to sqlite3DeferForeignKey() might change this to DEFERRED.
83506 ** This routine is called when an INITIALLY IMMEDIATE or INITIALLY DEFERRED
83508 ** parameter is 1 for INITIALLY DEFERRED and 0 for INITIALLY IMMEDIATE.
87761 ** Deferred and Immediate FKs
87764 ** Foreign keys in SQLite come in two flavours: deferred and immediate.
87767 ** deferred foreign key constraint is violated, no action is taken
87771 ** Deferred constraints are implemented using a simple counter associated
87780 ** * When a commit fails due to a deferred foreign key constraint,
88048 ** INSERT deferred Increment the "deferred constraint counter".
88050 ** DELETE deferred Decrement the "deferred constraint counter".
88185 ** deferred, when a row is inserted into the same table. When generating
88201 ** DELETE deferred Increment the "deferred constraint counter".
88205 ** INSERT deferred Decrement the "deferred constraint counter".
88218 int nIncr /* Amount to increment deferred counter by */
88301 ** clause. If the constraint is not deferred, throw an exception for
88302 ** each row found. Otherwise, for deferred constraints, increment the
88303 ** deferred constraint counter by nIncr for each row selected. */
88367 ** (b) The table is the child table of a deferred FK constraint and it is
88368 ** determined at runtime that there are outstanding deferred FK
88383 /* Search for a deferred foreign key constraint for which this table
88386 ** the entire DELETE if there are no outstanding deferred constraints
88581 ** deferred trigger. That's what RESTRICT means. To defer checking
88946 ** classified as either immediate or deferred.
101567 ** the disconnect is deferred until all locks have been removed.
106755 sqlite3VdbeAddOp2(v, OP_Seek, iCur, iRowidReg); /* Deferred seek */
108572 26, /* DEFERRED => ID */
108711 "PLAN", "BEGIN", "TRANSACTION", "DEFERRED",
108794 /* 14 */ "transtype ::= DEFERRED",
108866 /* 86 */ "init_deferred_pred_opt ::= INITIALLY DEFERRED",
109898 case 14: /* transtype ::= DEFERRED */
109955 case 86: /* init_deferred_pred_opt ::= INITIALLY DEFERRED */ yytestcase(yyruleno==86);
111566 testcase( i==98 ); /* DEFERRED */
113316 /* Any deferred constraint violations have now been resolved. */
116657 Fts3DeferredToken *pDeferred; /* Deferred search tokens, if any */
116723 Fts3DeferredToken *pDeferred; /* Deferred token object for this token */
116774 u8 bDeferred; /* True if this expression is entirely deferred */
120337 ** does not take deferred tokens into account.
120369 ** any deferred tokens have been loaded into memory. It updates the phrases
120371 ** instances of the phrase (after considering deferred tokens). If this
120379 char *aPoslist = 0; /* Position list for deferred tokens */
120381 int iPrev = -1; /* Token number of previous deferred token */
120652 ** expressions for which all descendent tokens are deferred.
120656 ** each phrase in the expression (subject to deferred token processing).
120818 ** deferred. The array aTC[] has already been populated when this is
120846 /* Tokens are never deferred for FTS tables created using the content=xxx
120849 ** causing any problems, the deferred token optimization is completely
120886 ** one or more tokens will not be deferred.
120910 ** that will be loaded if all subsequent tokens are deferred.
120968 /* Determine which, if any, tokens in the expression should be deferred. */
121094 ** 1. Deferred tokens are not taken into account. If a phrase consists
121095 ** entirely of deferred tokens, it is assumed to match every row in
121098 ** Or, if a phrase contains one or more deferred tokens and one or
121099 ** more non-deferred tokens, then the expression is advanced to the
121100 ** next possible match, considering only non-deferred tokens. In other
121101 ** words, if the phrase is "A B C", and "B" is deferred, the expression
121110 ** really a match, taking into account deferred tokens and NEAR operators.
121130 /* LHS is entirely deferred. So we assume it matches every row.
121136 /* RHS is entirely deferred. So we assume it matches every row.
121142 /* Neither the RHS or LHS are deferred. */
121412 ** * Deferred tokens have not yet been considered.
121416 ** operators and deferred tokens the current row is still a match for the
121421 ** 2. After scanning the current FTS table row for the deferred tokens,
121432 /* If there are one or more deferred tokens, load the current row into
121433 ** memory and scan it to determine the position list for each deferred
121434 ** token. Then, see if this row is really a match, considering deferred
121446 /* Free the position-lists accumulated for each deferred token above. */
121669 ** * If a phrase consists entirely of deferred tokens, then all output
121674 ** * If a phrase contains some deferred tokens (and some non-deferred
121676 ** the non-deferred tokens instead of actual phrase occurrences.
121726 ** This function works regardless of whether or not the phrase is deferred,
125147 Fts3DeferredToken *pNext; /* Next in list of deferred tokens */
128265 ** Delete all cached deferred doclists. Deferred doclists are cached
128292 ** Generate deferred-doclists for all tokens in the pCsr->pDeferred list
128295 ** A deferred-doclist is like any other doclist with position information
128304 Fts3DeferredToken *pDef; /* Used to iterate through deferred tokens */
129356 ** If the phrase pExpr consists entirely of deferred tokens, then all X and
129360 ** not available for deferred tokens.
