Lines Matching full:constraints
1939 ** the count does not include changes used to implement [REPLACE] constraints,
4714 ** ^(The aConstraint[] array records WHERE clause constraints of the form:
4762 } *aConstraint; /* Table of WHERE clause constraints */
4943 ** key for writing. ^If [foreign key constraints] are enabled, it is
8391 i64 nDeferredCons; /* Net deferred constraints this transaction. */
8434 #define SQLITE_IgnoreChecks 0x00040000 /* Do not enforce check constraints */
8442 #define SQLITE_ForeignKeys 0x04000000 /* Enforce foreign key constraints */
8760 Expr *pCheck; /* The AND of all CHECK constraints */
9355 u32 nEq; /* Number of == constraints */
9644 int ckBase; /* Base register of data during check constraints */
10508 ** provided (enforcement of FK constraints requires the triggers sub-system).
17833 i64 nFkConstraint; /* Number of imm. FK constraints this VM */
17834 i64 nStmtDefCons; /* Number of def. constraints when stmt started */
49509 ** key constraints to hold up the transaction. This means a commit
53519 /* If this statement has violated immediate foreign key constraints, do
57464 ** (deferred foreign key constraints). Otherwise, if P1 is zero, the
57465 ** statement counter is incremented (immediate foreign key constraints).
59884 sqlite3ErrorMsg(pParse,"subqueries prohibited in CHECK constraints");
59898 sqlite3ErrorMsg(pParse,"parameters prohibited in CHECK constraints");
62809 /* This only happens when coding check constraints */
64329 ** of any foreign key constraints that use the table being renamed as the
64512 ** tables that have foreign key constraints that refer to table pTab (i.e.
64513 ** constraints for which pTab is the parent table) from the sqlite_master
64718 ** statements corresponding to all child tables of foreign key constraints
69135 ** Two UNIQUE or PRIMARY KEY constraints are considered equivalent
69140 ** the constraint occur in different orders, then the constraints are
69955 ** rollback the whole transaction. For operations where all constraints
71157 /* Do FK processing. This call checks that any FK constraints that
71158 ** refer to this table (i.e. constraints attached to other tables)
72822 ** Deferred constraints are implemented using a simple counter associated
72866 ** for FK constraints for which the affected columns are actually
72872 ** For the purposes of immediate FK constraints, the OR REPLACE conflict
72878 ** Immediate constraints are usually handled similarly. The only difference
73123 ** outstanding constraints to resolve. If there are not, there is no need
73340 ** each row found. Otherwise, for deferred constraints, increment the
73360 ** constraints for which table pTab is the parent table. For example,
73369 ** NULL pointer (as there are no FK constraints for which t2 is the parent
73424 ** the entire DELETE if there are no outstanding deferred constraints
73497 /* Loop through all the foreign key constraints for which pTab is the
73567 /* Loop through all the foreign key constraints that refer to this table */
73858 ** tables do not have foreign key constraints. Hence, pTab->dbMem
74949 /* Generate code to check constraints and generate index keys and
74961 int isReplace; /* Set to true if constraints may cause a replace */
75077 ** This routine also generates code to check constraints. NOT NULL,
75078 ** CHECK, and UNIQUE constraints are all checked. If a constraint fails,
75152 /* Test all NOT NULL constraints.
75197 /* Test all CHECK constraints
75279 /* Test all UNIQUE constraints by creating entries for each UNIQUE
75553 ** same indices and constraints
75704 return 0; /* Tables have different CHECK constraints. Ticket #2252 */
85252 /* Fire any BEFORE UPDATE triggers. This happens before constraints are
85587 ** disable CHECK and foreign key constraints. */
86970 constraints.
86971 ** ISNULL constraints will then not be used on the right table of a left
87360 ** can be optimized using inequality constraints. Return TRUE if it is
87970 /* Add constraints to reduce the search space on a LIKE or GLOB
87973 ** A like pattern of the form "x LIKE 'abc%'" is changed into constraints
88099 ** constraints. Any of these columns may be missing from the ORDER BY
88114 int nEqCol, /* Number of index columns with == constraints */
88194 ** equality constraints are all either DESC or ASC. */
88403 /* Count the number of possible WHERE clause constraints referring
88600 ** aConstraint[].usable is true for constraints where the right-hand
88610 ** The aConstraints[] array contains entries for all constraints
88822 ** range constraint. Or, equivalently, the number of equality constraints
88838 ** constraints (if any). A return value of 100 indicates that it is expected
88840 ** constraints.
88972 ** use an index to satisfy IS NULL constraints on that table. This is
89063 ** value of 100 means the entire table is searched. Range constraints
89068 ** nBound to 33. Two constraints (x>? AND x<?) reduce nBound to 11.
89195 ** that are excluded by range constraints.
89382 ** result is left on the stack. For constraints of the form X IN (...)
89440 ** Generate code that will evaluate all == and IN constraints for an
89445 ** The index has as many as three equality constraints, but in this
89447 ** constraints are coded. This routine will generate code to evaluate
89466 ** with equality constraints that use NONE affinity are set to
89486 int nEq = pLevel->plan.nEq; /* The number of == or IN constraints to code */
89511 /* Evaluate the equality constraints
89591 ** there are no IN operators in the constraints, the "addrNxt" label
89747 ** inequality constraints (>, <, >= or <=) on the indexed
89765 ** N may be zero if there are inequality constraints.
89766 ** If there are no inequality constraints, then N is at
89770 ** constraints but an index is selected anyway, in order
89806 k = pIdx->aiColumn[nEq]; /* Column for inequality constraints */
89813 ** the first one after the nEq equality constraints in the index,
89936 /* If there are inequality constraints, check that the value
90431 ** pWInfo->a[].nEq The number of == and IN constraints
90575 ** The one-pass algorithm only works if the WHERE clause constraints
99423 ** so search through the constraints to see if a more efficient
107657 RtreeConstraint *aConstraint; /* Search constraints. */
108243 ** (excluded) by the constraints in the pCursor->aConstraint[]
108275 ** would be filtered (excluded) by the constraints in the
108310 ** configured constraints.
108407 /* Move to the next entry that matches the configured constraints. */
108521 ** with the configured constraints.
110036 rtreeFilter, /* xFilter - configure scan constraints */
