SQLite

All files named ”test/fkey6.test”
Login

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

History for test/fkey6.test

2025-02-17
19:44
[668a7299e7] part of check-in [088e476519] Fix problems in test script fkey6.test. (check-in: [088e476519] user: dan branch: trunk, size: 7311)
2025-02-13
14:47
[1e0874ba15] part of check-in [c5190b0fd9] Ensure the counts of "deferred FK violations" and "deferred immediate FK violations" are kept separate when "PRAGMA defer_foreign_keys" is used. (check-in: [c5190b0fd9] user: dan branch: trunk, size: 7169)
2025-01-20
18:26
[ebd11efb00] part of check-in [39bdbb3f6d] Fix an assert() that could fail if a virtual table called sqlite3_step() from within the xSync() method while committing a "PRAGMA defer_foreign_keys=1" transaction. (check-in: [39bdbb3f6d] user: dan branch: trunk, size: 6434)
2025-01-04
16:30
[bdb9c80834] part of check-in [e09a0c0229] Fix a problem in the sessions extension allowing changesets containing foreign key violations to be committed under some circumstances. (check-in: [e09a0c0229] user: dan branch: trunk, size: 6027)
2016-02-25
20:17
[ce3c39cd4f] part of check-in [9ffff484bb] Disable the RESTRICT foreign key action if "PRAGMA defer_foreign_keys" is set. (check-in: [9ffff484bb] user: dan branch: trunk, size: 5387)
2016-01-21
17:25
[d078a1e323] part of check-in [82470d1c3a] Disable the RESTRICT foreign key action if "PRAGMA defer_foreign_keys" is set. (check-in: [82470d1c3a] user: dan branch: disable-restrict, size: 5393)
2013-11-11
22:55
[6697550baa] part of check-in [5addd1234d] Merge in the WITHOUT ROWID changes. A few tests are failing now. They will be fixed in a follow-on check-in. (check-in: [5addd1234d] user: drh branch: sessions, size: 4150)
2013-11-05
13:33
[abb59f866c] part of check-in [54b2219297] Standardize the error messages generated by constraint failures to a format of "$TYPE constraint failed: $DETAIL". This involves many changes to the expected output of test cases. (check-in: [54b2219297] user: drh branch: omit-rowid, size: 4144)
2013-10-15
14:10
[cd81be336e] part of check-in [e111e4edf9] Merge the latest trunk changes into the sessions branch. This merge should fix the build for WinRT. (check-in: [e111e4edf9] user: drh branch: sessions, size: 4151)
2013-10-12
15:12
[18e8c024d3] part of check-in [27001356ed] Fix handling of "DROP TABLE" commands when "PRAGMA defer_foreign_keys=1" is set. (check-in: [27001356ed] user: dan branch: trunk, size: 4145)
13:16
[aaf64e18e6] part of check-in [67e28a11de] Add tests that demonstrate that PRAGMA defer_foreign_keys will reset to off at the conclusion of the next transaction. (check-in: [67e28a11de] user: drh branch: trunk, size: 3125)
2013-10-11
20:14
[c1d7cb1766] part of check-in [5e0d43ab55] Add requirements marks. No code changes. (check-in: [5e0d43ab55] user: drh branch: trunk, size: 2758)
2013-07-11
15:22
[c555f7fc45] part of check-in [6557c40798] Add the experimental "query_only" pragma. (check-in: [6557c40798] user: drh branch: trunk, size: 2332)
13:49
Added: [2d76497c54] part of check-in [d39e65fe70] Remove the undocumented sqlite3_foreign_key_check() API and replace it with sqlite3_db_status(db, SQLITE_DBSTATUS_DEFERRED_FKS, ...). Add test cases for the new functionality. (check-in: [d39e65fe70] user: drh branch: sessions, size: 2338)