lib/sqlite/sqlite3.c

4940 ** to modify the database connection must be deferred until after the
4998 ** to modify the database connection must be deferred until after the
9534   i64 nDeferredCons;            /* Net deferred constraints this transaction. */
9715   i64 nDeferredCons;                  /* Number of deferred fk violations */
10002   u8 isDeferred;    /* True if constraint checking is deferred till COMMIT */
12610   i64 movetoTarget;     /* Argument to the deferred sqlite3BtreeMoveto() */
25489 ** to close() the file descriptor is deferred until all of the locks clear.
26308     ** was deferred because of outstanding locks.
30069 ** this reason, the division that implements of proxy locking is deferred
60366     ** database handles deferred constraint counter to the value it had when
60378 ** committed. If there are outstanding deferred foreign key constraint
60386 SQLITE_PRIVATE int sqlite3VdbeCheckFk(Vdbe *p, int deferred){
60388   if( (deferred && db->nDeferredCons>0) || (!deferred && p->nFkConstraint>0) ){
60507           ** or hit an 'OR FAIL' constraint and there are no deferred foreign
66277       ** too. If it is a ROLLBACK TO, then set the number of deferred
66440       /* Store the current value of the database handles deferred constraint
67068 ** This is actually a deferred seek.  Nothing actually happens until
68816 ** (deferred foreign key constraints). Otherwise, if P1 is zero, the
68835 ** is zero (the one that counts deferred constraint violations). If P1 is
76735 ** the dallocation is deferred until the column cache line that uses
85683 ** Foreign keys in SQLite come in two flavours: deferred and immediate.
85686 ** deferred foreign key constraint is violated, no action is taken
85699 **   * When a commit fails due to a deferred foreign key constraint,
85967 **   INSERT      deferred    Increment the "deferred constraint counter".
85969 **   DELETE      deferred    Decrement the "deferred constraint counter".
86104 ** deferred, when a row is inserted into the same table. When generating
86120 **   DELETE      deferred    Increment the "deferred constraint counter".
86124 **   INSERT      deferred    Decrement the "deferred constraint counter".
86137   int nIncr                       /* Amount to increment deferred counter by */
86220   ** clause. If the constraint is not deferred, throw an exception for
86221   ** each row found. Otherwise, for deferred constraints, increment the
86222   ** deferred constraint counter by nIncr for each row selected.  */
86286 **   (b) The table is the child table of a deferred FK constraint and it is
86287 **       determined at runtime that there are outstanding deferred FK
86302       /* Search for a deferred foreign key constraint for which this table
86305       ** the entire DELETE if there are no outstanding deferred constraints
86500         ** deferred trigger. That's what RESTRICT means. To defer checking
86864     ** classified as either immediate or deferred.
99381 ** the disconnect is deferred until all locks have been removed.
110987   /* Any deferred constraint violations have now been resolved. */
114365   u8 bDeferred;              /* True if this expression is entirely deferred */
117619 ** does not take deferred tokens into account.
117651 ** any deferred tokens have been loaded into memory. It updates the phrases
117653 ** instances of the phrase (after considering deferred tokens). If this
117662   char *aPoslist = 0;             /* Position list for deferred tokens */
117664   int iPrev = -1;                 /* Token number of previous deferred token */
117934 ** expressions for which all descendent tokens are deferred.
117938 ** each phrase in the expression (subject to deferred token processing).
118095 ** deferred. The array aTC[] has already been populated when this is
118154   ** one or more tokens will not be deferred.
118178       ** that will be loaded if all subsequent tokens are deferred.
118232   /* Determine which, if any, tokens in the expression should be deferred. */
118359 **      entirely of deferred tokens, it is assumed to match every row in
118362 **      Or, if a phrase contains one or more deferred tokens and one or
118363 **      more non-deferred tokens, then the expression is advanced to the
118364 **      next possible match, considering only non-deferred tokens. In other
118365 **      words, if the phrase is "A B C", and "B" is deferred, the expression
118374 ** really a match, taking into account deferred tokens and NEAR operators.
118394           /* LHS is entirely deferred. So we assume it matches every row.
118400           /* RHS is entirely deferred. So we assume it matches every row.
118406           /* Neither the RHS or LHS are deferred. */
118677 ** operators and deferred tokens the current row is still a match for the
118682 **   2. After scanning the current FTS table row for the deferred tokens,
118693     /* If there are one or more deferred tokens, load the current row into
118694     ** memory and scan it to determine the position list for each deferred
118695     ** token. Then, see if this row is really a match, considering deferred
118707     /* Free the position-lists accumulated for each deferred token above. */
118930 **   * If a phrase consists entirely of deferred tokens, then all output
118935 **   * If a phrase contains some deferred tokens (and some non-deferred
118937 **     the non-deferred tokens instead of actual phrase occurrences.
118987 ** This function works regardless of whether or not the phrase is deferred,
122349   Fts3DeferredToken *pNext;       /* Next in list of deferred tokens */
125206 ** Delete all cached deferred doclists. Deferred doclists are cached
125233 ** Generate deferred-doclists for all tokens in the pCsr->pDeferred list
125236 ** A deferred-doclist is like any other doclist with position information
125245     Fts3DeferredToken *pDef;      /* Used to iterate through deferred tokens */
126273 ** If the phrase pExpr consists entirely of deferred tokens, then all X and
126277 ** not available for deferred tokens.