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() */
25978 ** to close() the file descriptor is deferred until all of the locks clear.
26784 ** was deferred because of outstanding locks.
30635 ** this reason, the division that implements of proxy locking is deferred
61581 ** database handles deferred constraint counter to the value it had when
61593 ** committed. If there are outstanding deferred foreign key constraint
61601 SQLITE_PRIVATE int sqlite3VdbeCheckFk(Vdbe *p, int deferred){
61603 if( (deferred && db->nDeferredCons>0) || (!deferred && p->nFkConstraint>0) ){
61722 ** or hit an 'OR FAIL' constraint and there are no deferred foreign
67635 ** too. If it is a ROLLBACK TO, then set the number of deferred
67801 /* Store the current value of the database handles deferred constraint
68429 ** This is actually a deferred seek. Nothing actually happens until
70182 ** (deferred foreign key constraints). Otherwise, if P1 is zero, the
70201 ** is zero (the one that counts deferred constraint violations). If P1 is
78392 ** the dallocation is deferred until the column cache line that uses
83400 ** to sqlite3DeferForeignKey() might change this to DEFERRED.
83517 ** This routine is called when an INITIALLY IMMEDIATE or INITIALLY DEFERRED
83519 ** parameter is 1 for INITIALLY DEFERRED and 0 for INITIALLY IMMEDIATE.
87772 ** Deferred and Immediate FKs
87775 ** Foreign keys in SQLite come in two flavours: deferred and immediate.
87778 ** deferred foreign key constraint is violated, no action is taken
87782 ** Deferred constraints are implemented using a simple counter associated
87791 ** * When a commit fails due to a deferred foreign key constraint,
88059 ** INSERT deferred Increment the "deferred constraint counter".
88061 ** DELETE deferred Decrement the "deferred constraint counter".
88196 ** deferred, when a row is inserted into the same table. When generating
88212 ** DELETE deferred Increment the "deferred constraint counter".
88216 ** INSERT deferred Decrement the "deferred constraint counter".
88229 int nIncr /* Amount to increment deferred counter by */
88312 ** clause. If the constraint is not deferred, throw an exception for
88313 ** each row found. Otherwise, for deferred constraints, increment the
88314 ** deferred constraint counter by nIncr for each row selected. */
88378 ** (b) The table is the child table of a deferred FK constraint and it is
88379 ** determined at runtime that there are outstanding deferred FK
88394 /* Search for a deferred foreign key constraint for which this table
88397 ** the entire DELETE if there are no outstanding deferred constraints
88592 ** deferred trigger. That's what RESTRICT means. To defer checking
88957 ** classified as either immediate or deferred.
101578 ** the disconnect is deferred until all locks have been removed.
106766 sqlite3VdbeAddOp2(v, OP_Seek, iCur, iRowidReg); /* Deferred seek */
108583 26, /* DEFERRED => ID */
108722 "PLAN", "BEGIN", "TRANSACTION", "DEFERRED",
108805 /* 14 */ "transtype ::= DEFERRED",
108877 /* 86 */ "init_deferred_pred_opt ::= INITIALLY DEFERRED",
109909 case 14: /* transtype ::= DEFERRED */
109966 case 86: /* init_deferred_pred_opt ::= INITIALLY DEFERRED */ yytestcase(yyruleno==86);
111577 testcase( i==98 ); /* DEFERRED */
113327 /* Any deferred constraint violations have now been resolved. */
116683 Fts3DeferredToken *pDeferred; /* Deferred search tokens, if any */
116749 Fts3DeferredToken *pDeferred; /* Deferred token object for this token */
116800 u8 bDeferred; /* True if this expression is entirely deferred */
120366 ** does not take deferred tokens into account.
120398 ** any deferred tokens have been loaded into memory. It updates the phrases
120400 ** instances of the phrase (after considering deferred tokens). If this
120408 char *aPoslist = 0; /* Position list for deferred tokens */
120410 int iPrev = -1; /* Token number of previous deferred token */
120681 ** expressions for which all descendent tokens are deferred.
120685 ** each phrase in the expression (subject to deferred token processing).
120847 ** deferred. The array aTC[] has already been populated when this is
120875 /* Tokens are never deferred for FTS tables created using the content=xxx
120878 ** causing any problems, the deferred token optimization is completely
120915 ** one or more tokens will not be deferred.
120939 ** that will be loaded if all subsequent tokens are deferred.
120997 /* Determine which, if any, tokens in the expression should be deferred. */
121123 ** 1. Deferred tokens are not taken into account. If a phrase consists
121124 ** entirely of deferred tokens, it is assumed to match every row in
121127 ** Or, if a phrase contains one or more deferred tokens and one or
121128 ** more non-deferred tokens, then the expression is advanced to the
121129 ** next possible match, considering only non-deferred tokens. In other
121130 ** words, if the phrase is "A B C", and "B" is deferred, the expression
121139 ** really a match, taking into account deferred tokens and NEAR operators.
121159 /* LHS is entirely deferred. So we assume it matches every row.
121165 /* RHS is entirely deferred. So we assume it matches every row.
121171 /* Neither the RHS or LHS are deferred. */
121441 ** * Deferred tokens have not yet been considered.
121445 ** operators and deferred tokens the current row is still a match for the
121450 ** 2. After scanning the current FTS table row for the deferred tokens,
121461 /* If there are one or more deferred tokens, load the current row into
121462 ** memory and scan it to determine the position list for each deferred
121463 ** token. Then, see if this row is really a match, considering deferred
121475 /* Free the position-lists accumulated for each deferred token above. */
121698 ** * If a phrase consists entirely of deferred tokens, then all output
121703 ** * If a phrase contains some deferred tokens (and some non-deferred
121705 ** the non-deferred tokens instead of actual phrase occurrences.
121755 ** This function works regardless of whether or not the phrase is deferred,
125176 Fts3DeferredToken *pNext; /* Next in list of deferred tokens */
128294 ** Delete all cached deferred doclists. Deferred doclists are cached
128321 ** Generate deferred-doclists for all tokens in the pCsr->pDeferred list
128324 ** A deferred-doclist is like any other doclist with position information
128333 Fts3DeferredToken *pDef; /* Used to iterate through deferred tokens */
129385 ** If the phrase pExpr consists entirely of deferred tokens, then all X and
129389 ** not available for deferred tokens.
