SQLite

All files named ”test/fkey5.test”
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

History for test/fkey5.test

2020-08-08
20:03
[6727452e16] part of check-in [d62d1711e2] Changes to busy2.test, corruptL.test and fkey5.test so that new test cases pass with all test permutations. (check-in: [d62d1711e2] user: dan branch: trunk, size: 13504)
15:40
[7309d9a42b] part of check-in [bf875a1c7f] Update requirement marks due to wording improvements in the documentation. (check-in: [bf875a1c7f] user: drh branch: trunk, size: 13385)
2020-07-03
12:32
[321fd41e87] part of check-in [07f849dee3] Fix the pragma_foreign_key_check virtual table so that it accepts arguments. (check-in: [07f849dee3] user: drh branch: trunk, size: 13350)
12:15
[bb2261477c] part of check-in [81bc4b65ae] Fix a problem with "PRAGMA foreign_key_check" where if a table in one schema appears to have foreign key constraints against another table in a different schema, the pragma will try to check the constraints even though they do not apply because they are in different schemas. (check-in: [81bc4b65ae] user: drh branch: trunk, size: 12241)
2017-05-06
17:12
[24dd28eb3d] part of check-in [198ff4c01d] Fix requirements marks and harmless compiler warnings. (check-in: [198ff4c01d] user: drh branch: trunk, size: 11445)
2017-04-17
18:42
[19a9b73baf] part of check-in [69f51f838a] Consolidate two branches of code in the "PRAGMA foreign_key_check" implementation. (check-in: [69f51f838a] user: dan branch: trunk, size: 11154)
18:02
[67eac5be27] part of check-in [690870bd7b] Fix a problem in "PRAGMA foreign_key_check" in handling a WITHOUT ROWID child table with an INTEGER PRIMARY KEY parent key. Also, if an FK violation is detected in a WITHOUT ROWID child table, do not try to read and return the rowid. The second column returned by "PRAGMA foreign_key_check" in this case (WITHOUT ROWID child table) is now always set to NULL. (check-in: [690870bd7b] user: dan branch: trunk, size: 10836)
2015-09-11
20:54
[5a373303f2] part of check-in [86781093bd] Update evidence marks due to wording changes in requirements text. No changes to code. (check-in: [86781093bd] user: drh branch: trunk, size: 10199)
2015-02-27
20:28
[56bcb5a6e8] part of check-in [8c2b29d9ac] New requirements marks and a few new test cases to go with them. No changes to code. (check-in: [8c2b29d9ac] user: drh branch: trunk, size: 10203)
2015-01-01
14:06
[488601fbda] part of check-in [5830c557f7] Fix the fkey-7.1 test so that it sorts its answer and hence always gives the same answer. (check-in: [5830c557f7] user: drh branch: trunk, size: 9606)
2013-10-12
19:06
[8a1fde4e77] part of check-in [8c13a7fd73] In "PRAGMA foreign_key_check", treat missing parent tables as empty (instead of as errors). (check-in: [8c13a7fd73] user: dan branch: fkc-missing-parent-tables, size: 9505)
2013-10-11
20:14
[2b8c761ad2] part of check-in [5e0d43ab55] Add requirements marks. No code changes. (check-in: [5e0d43ab55] user: drh branch: trunk, size: 8620)
2012-12-17
22:32
Added: [0bf64f2d19] part of check-in [25411f83f9] Added test cases for PRAGMA foreign_key_check. Fixed a bug that appears when the column order of the child and parent differ. (check-in: [25411f83f9] user: drh branch: foreign-key-check, size: 7903)