/ File History
Login

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

History of test/fkey1.test

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