contrib/sqlite3/sqlite3.c

865 ** of resources is deferred until all [prepared statements], [BLOB handles],
5325 ** to modify the database connection must be deferred until after the
5384 ** to modify the database connection must be deferred until after the
10121   i64 nDeferredCons;            /* Net deferred constraints this transaction. */
10320   i64 nDeferredCons;                  /* Number of deferred fk violations */
10586   u8 isDeferred;    /* True if constraint checking is deferred till COMMIT */
13321   i64 movetoTarget;     /* Argument to the deferred sqlite3BtreeMoveto() */
24098 ** to close() the file descriptor is deferred until all of the locks clear.
24947     ** was deferred because of outstanding locks.
29228 ** this reason, the division that implements of proxy locking is deferred
61997     ** database handles deferred constraint counter to the value it had when
62009 ** committed. If there are outstanding deferred foreign key constraint
62017 SQLITE_PRIVATE int sqlite3VdbeCheckFk(Vdbe *p, int deferred){
62019   if( (deferred && db->nDeferredCons>0) || (!deferred && p->nFkConstraint>0) ){
62138           ** or hit an 'OR FAIL' constraint and there are no deferred foreign
68158       ** too. If it is a ROLLBACK TO, then set the number of deferred
68324       /* Store the current value of the database handles deferred constraint
68955 ** This is actually a deferred seek.  Nothing actually happens until
70695 ** (deferred foreign key constraints). Otherwise, if P1 is zero, the
70714 ** is zero (the one that counts deferred constraint violations). If P1 is
79365 ** the dallocation is deferred until the column cache line that uses
88899 ** Foreign keys in SQLite come in two flavours: deferred and immediate.
88903 ** deferred foreign key constraint is violated, no action is taken
88916 **   * When a commit fails due to a deferred foreign key constraint,
89187 **   INSERT      deferred    Increment the "deferred constraint counter".
89189 **   DELETE      deferred    Decrement the "deferred constraint counter".
89324 ** deferred, when a row is inserted into the same table. When generating
89340 **   DELETE      deferred    Increment the "deferred constraint counter".
89344 **   INSERT      deferred    Decrement the "deferred constraint counter".
89357   int nIncr                       /* Amount to increment deferred counter by */
89443   ** clause. If the constraint is not deferred, throw an exception for
89444   ** each row found. Otherwise, for deferred constraints, increment the
89445   ** deferred constraint counter by nIncr for each row selected.  */
89509 **   (b) The table is the child table of a deferred FK constraint and it is
89510 **       determined at runtime that there are outstanding deferred FK
89525       /* Search for a deferred foreign key constraint for which this table
89528       ** the entire DELETE if there are no outstanding deferred constraints
89723         ** deferred trigger. That's what RESTRICT means. To defer checking
90089     ** classified as either immediate or deferred.
103377 ** the disconnect is deferred until all locks have been removed.
115820   /* Any deferred constraint violations have now been resolved. */
119413   u8 bDeferred;              /* True if this expression is entirely deferred */
123070 ** does not take deferred tokens into account.
123102 ** any deferred tokens have been loaded into memory. It updates the phrases
123104 ** instances of the phrase (after considering deferred tokens). If this
123112   char *aPoslist = 0;             /* Position list for deferred tokens */
123114   int iPrev = -1;                 /* Token number of previous deferred token */
123420 ** expressions for which all descendent tokens are deferred.
123424 ** each phrase in the expression (subject to deferred token processing).
123586 ** deferred. The array aTC[] has already been populated when this is
123614   /* Tokens are never deferred for FTS tables created using the content=xxx
123617   ** causing any problems, the deferred token optimization is completely
123654   ** one or more tokens will not be deferred.
123678       ** that will be loaded if all subsequent tokens are deferred.
123736   /* Determine which, if any, tokens in the expression should be deferred. */
123865 **      entirely of deferred tokens, it is assumed to match every row in
123868 **      Or, if a phrase contains one or more deferred tokens and one or
123869 **      more non-deferred tokens, then the expression is advanced to the
123870 **      next possible match, considering only non-deferred tokens. In other
123871 **      words, if the phrase is "A B C", and "B" is deferred, the expression
123880 ** really a match, taking into account deferred tokens and NEAR operators.
123900           /* LHS is entirely deferred. So we assume it matches every row.
123906           /* RHS is entirely deferred. So we assume it matches every row.
123912           /* Neither the RHS or LHS are deferred. */
124193 ** operators and deferred tokens the current row is still a match for the
124198 **   2. After scanning the current FTS table row for the deferred tokens,
124209     /* If there are one or more deferred tokens, load the current row into
124210     ** memory and scan it to determine the position list for each deferred
124211     ** token. Then, see if this row is really a match, considering deferred
124223     /* Free the position-lists accumulated for each deferred token above. */
124446 **   * If a phrase consists entirely of deferred tokens, then all output
124451 **   * If a phrase contains some deferred tokens (and some non-deferred
124453 **     the non-deferred tokens instead of actual phrase occurrences.
124503 ** This function works regardless of whether or not the phrase is deferred,
128747   Fts3DeferredToken *pNext;       /* Next in list of deferred tokens */
133693 ** Delete all cached deferred doclists. Deferred doclists are cached
133720 ** Generate deferred-doclists for all tokens in the pCsr->pDeferred list
133723 ** A deferred-doclist is like any other doclist with position information
133732     Fts3DeferredToken *pDef;      /* Used to iterate through deferred tokens */
134803 ** If the phrase pExpr consists entirely of deferred tokens, then all X and
134807 ** not available for deferred tokens.