Lines Matching refs:R

51 # EVIDENCE-OF: R-37672-59189 In order to use foreign key constraints in
72 # EVIDENCE-OF: R-10109-20452 If SQLITE_OMIT_TRIGGER is defined but
81 # EVIDENCE-OF: R-22567-44039 The PRAGMA foreign_keys command is a no-op
84 # EVIDENCE-OF: R-41784-13339 Tip: If the command "PRAGMA foreign_keys"
115 # EVIDENCE-OF: R-58428-36660 If OMIT_FOREIGN_KEY is defined, then
149 # EVIDENCE-OF: R-07280-60510 Assuming the library is compiled with
155 # EVIDENCE-OF: R-44261-39702 Foreign key constraints are disabled by
183 # EVIDENCE-OF: R-08013-37737 The application can also use a PRAGMA
190 # EVIDENCE-OF: R-11255-19907
213 # EVIDENCE-OF: R-46649-58537 It is not possible to enable or disable
258 # EVIDENCE-OF: R-04042-24825 To do so, a foreign key definition may be
280 # EVIDENCE-OF: R-61362-32087 Attempting to insert a row into the track
299 # EVIDENCE-OF: R-24401-52400 as will attempting to delete a row from the
316 # EVIDENCE-OF: R-23980-48859 There is one exception: if the foreign key
353 # EVIDENCE-OF: R-52486-21352 Expressed in SQL, this means that for every
359 # R-52486-21352 is true after executing the SQL statement passed.
384 # the two tables in the example schema. Test that R-52486-21352
408 # EVIDENCE-OF: R-42412-59321 Tip: If the application requires a stricter
433 # EVIDENCE-OF: R-16127-35442
477 # EVIDENCE-OF: R-15958-50233
506 # EVIDENCE-OF: R-56032-24923 The foreign key constraint is satisfied if
515 # EVIDENCE-OF: R-57765-12380 In the above paragraph, the term "equal"
557 # EVIDENCE-OF: R-15796-47513 When comparing text values, the collating
588 # EVIDENCE-OF: R-04240-13860 When comparing values, if the parent key
623 # EVIDENCE-OF: R-13435-26311 Usually, the parent key of a foreign key
633 # EVIDENCE-OF: R-00376-39212 If the parent key columns have a UNIQUE
671 # EVIDENCE-OF: R-27484-01467
677 # EVIDENCE-OF: R-51039-44840 The foreign key declared as part of table
683 # EVIDENCE-OF: R-01060-48788 The foreign key for table child5 is an
689 # EVIDENCE-OF: R-63088-37469 Tables child6 and child7 are incorrect
736 # EVIDENCE-OF: R-45488-08504 If the database schema contains foreign key
741 # EVIDENCE-OF: R-48391-38472 Instead, such errors prevent the
745 # EVIDENCE-OF: R-03108-63659 The English language error message for
749 # EVIDENCE-OF: R-35763-48267 Foreign key DML errors are reported if: The
818 # EVIDENCE-OF: R-19353-43643
866 # EVIDENCE-OF: R-23682-59820 By contrast, if foreign key errors can be
873 # EVIDENCE-OF: R-33883-28833 Foreign key DDL errors are reported
901 # EVIDENCE-OF: R-43879-08025 Attaching a "REFERENCES <parent-table>"
931 # EVIDENCE-OF: R-15417-28014 Indices are not required for child key
937 # EVIDENCE-OF: R-15741-50893 The child key index does not have to be
965 # EVIDENCE-OF: R-00279-52283
972 # EVIDENCE-OF: R-23302-30956 If this SELECT returns any rows at all,
1034 # EVIDENCE-OF: R-47936-10044 Or, more generally:
1050 # EVIDENCE-OF: R-61616-46700 Similar queries may be run if the content
1093 # EVIDENCE-OF: R-14553-34013
1138 # EVIDENCE-OF: R-41062-34431 Parent and child keys must have the same
1184 # EVIDENCE-OF: R-24676-09859
1223 # EVIDENCE-OF: R-33626-48418 In SQLite, if any of the child key columns
1244 # EVIDENCE-OF: R-09323-30470 If a statement modifies the contents of the
1299 # EVIDENCE-OF: R-49178-21358 By contrast, if a statement modifies the
1303 # EVIDENCE-OF: R-39692-12488 Deferred foreign key constraints are not
1306 # EVIDENCE-OF: R-55147-47664 For as long as the user has an open
1310 # EVIDENCE-OF: R-29604-30395 However, COMMIT will fail as long as
1337 # EVIDENCE-OF: R-56844-61705 If the current statement is not inside an
1364 # EVIDENCE-OF: R-12782-61841
1371 # EVIDENCE-OF: R-09005-28791
1385 # EVIDENCE-OF: R-35290-16460 Foreign key constraints are immediate by
1388 # EVIDENCE-OF: R-30323-21917 Each foreign key constraint in SQLite is
1486 # EVIDENCE-OF: R-24499-57071
1523 # EVIDENCE-OF: R-07223-48323 A nested savepoint transaction may be
1562 # EVIDENCE-OF: R-44295-13823 A transaction savepoint (a non-nested
1604 # EVIDENCE-OF: R-37736-42616 If a COMMIT statement (or the RELEASE of a
1668 # EVIDENCE-OF: R-48270-44282 Foreign key ON DELETE and ON UPDATE clauses
1676 # EVIDENCE-OF: R-48124-63225 A single foreign key constraint may have
1721 # EVIDENCE-OF: R-33326-45252 The ON DELETE and ON UPDATE action
1727 # EVIDENCE-OF: R-19803-45884 If an action is not explicitly specified,
1772 # EVIDENCE-OF: R-19971-54976 Configuring "NO ACTION" means just that:
1812 # EVIDENCE-OF: R-04272-38653 The "RESTRICT" action means that the
1850 # EVIDENCE-OF: R-37997-42187 The difference between the effect of a
1939 # EVIDENCE-OF: R-24179-60523 Even if the foreign key constraint it is
2015 # EVIDENCE-OF: R-03353-05327 If the configured action is "SET NULL",
2058 # EVIDENCE-OF: R-55814-22637 The "SET DEFAULT" actions are similar to
2100 # EVIDENCE-OF: R-61376-57267 A "CASCADE" action propagates the delete or
2103 # EVIDENCE-OF: R-61809-62207 For an "ON DELETE CASCADE" action, this
2141 # EVIDENCE-OF: R-13877-64542 For an "ON UPDATE CASCADE" action, it means
2145 # EVIDENCE-OF: R-61376-57267 A "CASCADE" action propagates the delete or
2185 # EVIDENCE-OF: R-65058-57158
2227 # EVIDENCE-OF: R-53968-51642 Configuring an ON UPDATE or ON DELETE
2264 # EVIDENCE-OF: R-11856-19836
2269 # (R-28220-46694).
2271 # EVIDENCE-OF: R-28220-46694 For example, if an "ON DELETE SET DEFAULT"
2310 # EVIDENCE-OF: R-09564-22170
2367 # EVIDENCE-OF: R-27383-10246 An ON UPDATE action is only taken if the
2418 # EVIDENCE-OF: R-35129-58141
2454 # EVIDENCE-OF: R-36018-21755 The parent key definitions of foreign key
2457 # EVIDENCE-OF: R-25384-39337 There is nothing stopping the user from
2471 # EVIDENCE-OF: R-08908-23439 A CREATE TABLE command operates the same
2501 # EVIDENCE-OF: R-47952-62498 It is not possible to use the "ALTER TABLE
2526 # EVIDENCE-OF: R-47080-02069 If an "ALTER TABLE ... RENAME TO" command
2533 # EVIDENCE-OF: R-43040-62530 The text of the child CREATE TABLE
2581 # EVIDENCE-OF: R-14208-23986 If foreign key constraints are enabled when
2585 # EVIDENCE-OF: R-11078-03945 The implicit DELETE does not cause any SQL
2652 # EVIDENCE-OF: R-32768-47925 If an immediate foreign key constraint is
2685 # EVIDENCE-OF: R-05903-08460 If a deferred foreign key constraint is
2720 # EVIDENCE-OF: R-57242-37005 Any "foreign key mismatch" errors
2773 # EVIDENCE-OF: R-54142-41346 The properties of the DROP TABLE and ALTER
2848 # EVIDENCE-OF: R-24728-13230 SQLite parses MATCH clauses (i.e. does not
2851 # EVIDENCE-OF: R-24450-46174 All foreign key constraints in SQLite are
2884 # EVIDENCE-OF: R-21599-16038 In SQLite, a foreign key constraint is
2926 # EVIDENCE-OF: R-42264-30503 The SQLITE_MAX_TRIGGER_DEPTH and
3018 # EVIDENCE-OF: R-44355-00270 The PRAGMA recursive_triggers setting does