Home
last modified time | relevance | path

Searched refs:constraints (Results 1 – 25 of 77) sorted by relevance

1234

/sqlite-3.40.0/test/
H A Dbestindex2.test32 # "=" constraints (but no others) may be optimized. The cost of a full table
37 # If one or more "=" constraints are in use, the cost and estimated number
39 # of constraints used. e.g.
51 set clist [$hdl constraints]
H A Dinsert4.test45 # does not violate constraints.
160 # CHECK constraints.
170 # any CHECK constraints regardless of whether or not there are CHECK
171 # constraints on the source table.
178 # NOT NULL constraints that the source table has.
185 # constraints that the source table lacks.
202 # source table have the same NOT NULL constraints or if the
203 # source table has extra NOT NULL constraints.
571 # optimization for tables with CHECK constraints.
H A Dcheck.test12 # focus of this file is testing CHECK constraints
19 # Only run these tests if the build includes support for CHECK constraints
226 } {1 {subqueries prohibited in CHECK constraints}}
363 } {1 {parameters prohibited in CHECK constraints}}
370 } {1 {parameters prohibited in CHECK constraints}}
484 # 2013-08-02: Silently ignore database name qualifiers in CHECK constraints.
491 # Make sure check constraints involving the ROWID are not ignored
H A Dbestindex8.test32 set clist [$hdl constraints]
124 foreach cons [$hdl constraints] {
187 set lCons [$hdl constraints]
253 set lCons [$hdl constraints]
306 set lCons [$hdl constraints]
H A Dbestindex1.test33 set clist [$hdl constraints]
83 set clist [$hdl constraints]
187 set clist [$hdl constraints]
300 set clist [$hdl constraints]
H A De_fkey.test76 # constraints are not enforced.
150 # foreign key constraints enabled, it must still be enabled by the
1308 # any number of deferred foreign key constraints.
1311 # foreign key constraints remain in violation.
1341 # immediate constraints.
1521 # deferred foreign key constraints.
1602 # constraints, any nested savepoints remain open.
2316 # 2. Check local (non foreign key) constraints,
2455 # constraints are not checked when a table is created.
2469 # or not foreign key constraints are enabled."
[all …]
H A Dbestindex4.test52 set clist [$hdl constraints]
142 set clist [$hdl constraints]
H A Dfkey6.test17 # enforcement of all foreign key constraints is delayed until the
21 # OFF so that foreign key constraints are only deferred if they are
H A DtriggerB.test12 # it tests updating tables with constraints within a trigger. Ticket #3055.
22 # Create test tables with constraints.
H A Dtrustschema1.test56 # edgy functions used in CHECK constraints
90 # edgy functions used in DEFAULT constraints
H A Dnotnullfault.test13 # and "IS NOT NULL" operators on columns with NOT NULL constraints.
H A Dorderby1.test117 } {~/ORDER BY/} ;# ORDER BY suppressed due to uniqueness constraints
134 } {~/ORDER BY/} ;# ORDER BY suppressed due to uniqueness constraints
401 } {~/ORDER BY/} ;# ORDER BY suppressed by uniqueness constraints
418 } {~/ORDER BY/} ;# ORDER BY suppressed by uniqueness constraints
H A DvtabF.test12 # This file checks to make sure IS NOT NULL constraints work on
H A Dwithout_rowid3.test29 # constraints work when not inside a transaction.
76 # FK constraints.
79 # do not affect the operation of FK constraints.
365 # multiple rows violates some foreign key constraints, then strikes a
391 # actions (CASCADE, SET DEFAULT, SET NULL etc.) or tests FK constraints
911 # TABLE" commands work as expected wrt foreign key constraints.
1406 # FOREIGN KEY constraints.
1492 # is turned on statements that violate immediate FK constraints return
1494 # Whereas statements that violate deferred FK constraints return the number
1639 # foreign key constraints. But not the child key of immediate constraints.
H A De_createtable.test685 # no PRIMARY KEY and no constraints of any kind. The default value of
690 # from tables that have primary keys, constraints and explicit default
1108 # Tests for statements regarding constraints (PRIMARY KEY, UNIQUE, NOT
1109 # NULL and CHECK constraints).
1319 # UNIQUE constraints.
1366 # EVIDENCE-OF: R-00404-17670 For the purposes of UNIQUE constraints,
1384 # constraints are implemented by creating a unique index in the
1418 # All the tests that deal with CHECK constraints below (4.11.* and
1518 # constraints may be explicitly assigned a default conflict resolution
1524 # and UNIQUE constraints, respectively.
[all …]
H A Dfkey2.test28 # constraints work when not inside a transaction.
75 # FK constraints.
78 # do not affect the operation of FK constraints.
365 # multiple rows violates some foreign key constraints, then strikes a
391 # actions (CASCADE, SET DEFAULT, SET NULL etc.) or tests FK constraints
945 # TABLE" commands work as expected wrt foreign key constraints.
1430 # is turned on statements that violate immediate FK constraints return
1432 # Whereas statements that violate deferred FK constraints return the number
1577 # foreign key constraints. But not the child key of immediate constraints.
H A Dschema5.test21 # Table constraints should be separated by commas, but they do not have
H A Dbestindex7.test32 set clist [$hdl constraints]
H A Dindex8.test26 # for index scans by taking into account WHERE clause constraints that can
H A Dbestindex6.test32 set clist [$hdl constraints]
H A Drowvalue5.test50 set clist [$hdl constraints]
H A Dwithout_rowid2.test14 # FOREIGN KEY constraints.
H A Dindexexpr1.test199 } {1 {expressions prohibited in PRIMARY KEY and UNIQUE constraints}}
202 } {1 {expressions prohibited in PRIMARY KEY and UNIQUE constraints}}
205 } {1 {expressions prohibited in PRIMARY KEY and UNIQUE constraints}}
/sqlite-3.40.0/tool/
H A Dgenfkey.README4 The SQLite library is capable of parsing SQL foreign key constraints
11 the foreign key constraints.
123 that implement the foreign key constraints found in the database schema are
/sqlite-3.40.0/ext/rtree/
H A Drtree4.test218 # constraints appear in a random order.
234 # constraints appear in a random order.

1234