/ All files named "test/fkey1.test"
Login

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

History for test/fkey1.test

2018-01-08
17:12
[d11dbb8a] part of check-in [7182591d] Add an "ifcapable trace {}" block to a test in fkey1.test that uses SQL tracing. (check-in: [7182591d] user: dan branch: trunk, size: 6327)
2017-12-27
21:30
[9d7e3a0d] part of check-in [fda08e3d] Omit all sqlite3_trace() output from the triggers associated with foreign key constraints. (check-in: [fda08e3d] user: drh branch: span-refactor, size: 6287)
2016-12-13
16:57
[ba64806f] part of check-in [850877d1] Fix a problem causing SQLite to return false "foreign key violation" errors when there is a partial (i.e. WHERE constrained) UNIQUE index on the parent key columns. This bug did not cause SQLite to allow illegal data to be inserted into the database, only to reject legal operations. (check-in: [850877d1] user: dan branch: trunk, size: 5840)
2015-09-30
12:59
[13e3d482] part of check-in [a6d5e4e8] Clear the BTCF_ValidNKey flag when putting a cursor into REQUIRESEEK state. Fix for [1b266395]. (check-in: [a6d5e4e8] user: dan branch: trunk, size: 5285)
2015-05-21
02:20
[fcaff62a] part of check-in [9e3f64a4] Ensure that tables names are dequoted exactly once by the trigger logic. Cherrypick [59e92bd9521f1e8] and [9d887b92f8086961e]. (check-in: [9e3f64a4] user: drh branch: branch-3.7.11, size: 4001)
2015-04-21
03:13
[de5b287f] part of check-in [59e92bd9] Fix some identifier name de-quoting issues in the foreign key and trigger logic. (check-in: [59e92bd9] user: drh branch: trunk, size: 4078)
2013-07-11
13:49
[e1d1fa84] part of check-in [d39e65fe] 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: [d39e65fe] user: drh branch: sessions, size: 2947)
2009-09-19
17:00
[01c7de57] part of check-in [d5d39981] Check in implementation of foreign key constraints. (check-in: [d5d39981] user: dan branch: trunk, size: 2870)
2009-01-09
21:41
[78506fa5] part of check-in [64c56226] Coverage improvements in pragma.c. Change the __DARWIN__ macro to __APPLE__, which is available by default on Leopard. (CVS 6153) (check-in: [64c56226] user: drh branch: trunk, size: 2825)
2008-10-10
17:47
[c373e4f1] part of check-in [3bb33cf5] Change 'pragma foreign_key_list' to return some extra information. (CVS 5795) (check-in: [3bb33cf5] user: danielk1977 branch: trunk, size: 2514)
2007-04-06
11:26
[dcb4f28e] part of check-in [8e2559b4] The FOR EACH STATEMENT clause in a trigger is now a syntax error. It used to be silently ignored. STATEMENT is no longer a keyword. (CVS 3821) (check-in: [8e2559b4] user: drh branch: trunk, size: 1646)
2005-08-20
03:03
[15300443] part of check-in [f786f37a] Increased test coverage. Some malloc tests now fail though this is believed to be an instrumentation problem not a real error. (CVS 2604) (check-in: [f786f37a] user: drh branch: trunk, size: 1627)
2004-11-03
16:27
[81bb13ca] part of check-in [b11fc9b3] Update tests to work even if some features of the library are disabled. (CVS 2050) (check-in: [b11fc9b3] user: drh branch: trunk, size: 1196)
2002-12-04
13:40
[d65c8244] part of check-in [0ad1d938] Add the sqliteBtreePrevious() routine to the BTree module API. This is in anticipation of implementing reverse order searching of a table. (CVS 794) (check-in: [0ad1d938] user: drh branch: trunk, size: 1144)
2002-08-31
18:53
Added: [33c85020] part of check-in [170711ca] Parse foreign key constraints and populate internal data structures appropriately. Constraints are still not enforced. (CVS 738) (check-in: [170711ca] user: drh branch: trunk, size: 967)