Lines Matching refs:or

20 # either SQLITE_OMIT_TRIGGER or SQLITE_OMIT_FOREIGN_KEY was defined
85 # returns no data instead of a single row containing "0" or "1", then
87 # (either because it is older than 3.6.19 or because it was compiled
88 # with SQLITE_OMIT_FOREIGN_KEY or SQLITE_OMIT_TRIGGER defined).
210 # Test that it is not possible to enable or disable foreign key support
213 # EVIDENCE-OF: R-46649-58537 It is not possible to enable or disable
383 # (some of which may fail due to FK or PK constraint violations) on 
507 # for each row in the child table either one or more of the child key
508 # columns are NULL, or there exists a row in the parent table for which
621 # constraint, or have a UNIQUE index created on it.
626 # to a UNIQUE constraint or have a UNIQUE index.
628 # Also test that if a parent key is not subject to a PRIMARY KEY or UNIQUE
734 # either "foreign key mismatch" or "no such table*" (using [string match]).
743 # the child or parent tables in ways that use the foreign keys.
750 # parent table does not exist, or The parent key columns named in the
751 # foreign key constraint do not exist, or The parent key columns named
754 # sequence specified in the CREATE TABLE, or The child table references
871 # These errors are reported whether or not FK support is enabled.
874 # regardless of whether or not foreign key constraints are enabled when
935 # not make a difference whether or not it is a UNIQUE index.
1043 # Also test that when a row is inserted into the parent table, or when the 
1051 # of the parent key is modified or a new row is inserted into the parent
1382 # Foreign keys are IMMEDIATE by default (if there is no DEFERRABLE or NOT
1389 # classified as either immediate or deferred.
1604 # EVIDENCE-OF: R-37736-42616 If a COMMIT statement (or the RELEASE of a
1666 # deleting or modifying rows of the parent table, respectively.
1670 # the parent table (ON DELETE), or modifying the parent key values of
1719 # either "NO ACTION", "RESTRICT", "SET NULL", "SET DEFAULT" or "CASCADE".
1723 # ACTION", "RESTRICT", "SET NULL", "SET DEFAULT" or "CASCADE".
1770 # it's parent row is updated or deleted.
1773 # when a parent key is modified or deleted from the database, no special
1809 # or updating a parent table row when there exists one or more child keys
1813 # application is prohibited from deleting (for ON DELETE RESTRICT) or
1815 # or more child keys mapped to it.
1854 # immediate constraint, or at the end of the current transaction as it
1942 # keys is deleted or modified.
2016 # then when a parent key is deleted (for ON DELETE SET NULL) or modified
2100 # EVIDENCE-OF: R-61376-57267 A "CASCADE" action propagates the delete or
2145 # EVIDENCE-OF: R-61376-57267 A "CASCADE" action propagates the delete or
2227 # EVIDENCE-OF: R-53968-51642 Configuring an ON UPDATE or ON DELETE
2312 # Check that the order of steps in an UPDATE or DELETE on a parent 
2317 #   3. Update or delete the row in the parent table,
2365 # is 'distinct' from the old or not.
2459 # does not exist, or to parent key columns that do not exist or are not
2460 # collectively bound by a PRIMARY KEY or UNIQUE constraint.
2467 # Also test that the above statements are true regardless of whether or not
2469 # or not foreign key constraints are enabled."
2472 # whether or not foreign key constraints are enabled.
2527 # is used to rename a table that is the parent table of one or more
2534 # statement or statements stored in the sqlite_schema table are modified
2586 # triggers to fire, but may invoke foreign key actions or constraint
2865     # MATCH SIMPLE behavior: Allow any child key that contains one or more
2885 # permanently marked as deferred or immediate when it is created.