Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for test/fkey1.test
|
2024-02-29
| ||
| 13:44 | [6cf3fb520d] part of check-in [2266086cf0] Add the ability to DROP one or more objects of the same class in a single statement by listing the objects as multiple arguments to the DROP command. (check-in: [2266086cf0] user: drh branch: multi-drop, size: 8802) | |
|
2023-04-14
| ||
| 00:20 | [e563bcb4cb] part of check-in [bb2b5ab172] Avoid double de-quoting of table names when processing RESTRICT actions in foreign key constraints. Chromium 1405220. Problem introduced by [9e503e2d0428c9e8] 2009-09-28 for version 3.6.19. (check-in: [bb2b5ab172] user: drh branch: trunk, size: 8492) | |
|
2022-01-01
| ||
| 12:26 | [55663090ab] part of check-in [0dd6b5fccd] Fix a faulty assert() statement - adding a CORRUPT_DB term - based on a test case derived from [562805cf488a455c]. Also add a test case to that prior issue. (check-in: [0dd6b5fccd] user: drh branch: trunk, size: 8148) | |
|
2021-07-07
| ||
| 16:48 | [03503639d2] part of check-in [7072404ad0] Follow-up to [68db1ff9c44fa9c3]: The number of registers needed by PRAGMA foreign_key_check was increased too late for an assert() deep down inside of sqlite3ExprCode(). So move the size increase a little earlier. Forum post 79c9e4797d. (check-in: [7072404ad0] user: drh branch: trunk, size: 6951) | |
|
2021-07-03
| ||
| 02:55 | [a0a38fc7f1] part of check-in [68db1ff9c4] In the PRAGMA foreign_key_check, ensure that sufficient registers are allocated for the virtual machine, even if one or more foreign keys reuses the same column multiple times and has more columns than the table it is part of. Forum post a6b0c05277. (check-in: [68db1ff9c4] user: drh branch: trunk, size: 6742) | |
|
2018-01-08
| ||
| 17:12 | [d11dbb8a93] part of check-in [7182591d35] Add an "ifcapable trace {}" block to a test in fkey1.test that uses SQL tracing. (check-in: [7182591d35] user: dan branch: trunk, size: 6327) | |
|
2017-12-27
| ||
| 21:30 | [9d7e3a0d40] part of check-in [fda08e3d10] Omit all sqlite3_trace() output from the triggers associated with foreign key constraints. (check-in: [fda08e3d10] user: drh branch: span-refactor, size: 6287) | |
|
2016-12-13
| ||
| 16:57 | [ba64806ff9] part of check-in [850877d1ea] 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: [850877d1ea] user: dan branch: trunk, size: 5840) | |
|
2015-09-30
| ||
| 12:59 | [13e3d48236] part of check-in [a6d5e4e869] Clear the BTCF_ValidNKey flag when putting a cursor into REQUIRESEEK state. Fix for [1b266395]. (check-in: [a6d5e4e869] user: dan branch: trunk, size: 5285) | |
|
2015-05-21
| ||
| 02:20 | [fcaff62ae3] part of check-in [9e3f64a4f4] Ensure that tables names are dequoted exactly once by the trigger logic. Cherrypick [59e92bd9521f1e8] and [9d887b92f8086961e]. (check-in: [9e3f64a4f4] user: drh branch: branch-3.7.11, size: 4001) | |
|
2015-04-21
| ||
| 03:13 | [de5b287f6a] part of check-in [59e92bd952] Fix some identifier name de-quoting issues in the foreign key and trigger logic. (check-in: [59e92bd952] user: drh branch: trunk, size: 4078) | |
|
2013-07-11
| ||
| 13:49 | [e1d1fa84cd] 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: 2947) | |
|
2009-09-19
| ||
| 17:00 | [01c7de578e] part of check-in [d5d3998118] Check in implementation of foreign key constraints. (check-in: [d5d3998118] user: dan branch: trunk, size: 2870) | |
|
2009-01-09
| ||
| 21:41 | [78506fa558] part of check-in [64c56226b9] Coverage improvements in pragma.c. Change the __DARWIN__ macro to __APPLE__, which is available by default on Leopard. (CVS 6153) (check-in: [64c56226b9] user: drh branch: trunk, size: 2825) | |
|
2008-10-10
| ||
| 17:47 | [c373e4f1ec] part of check-in [3bb33cf59d] Change 'pragma foreign_key_list' to return some extra information. (CVS 5795) (check-in: [3bb33cf59d] user: danielk1977 branch: trunk, size: 2514) | |
|
2007-04-06
| ||
| 11:26 | [dcb4f28eb2] part of check-in [8e2559b4da] 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: [8e2559b4da] user: drh branch: trunk, size: 1646) | |
|
2005-08-20
| ||
| 03:03 | [153004438d] part of check-in [f786f37a5e] 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: [f786f37a5e] user: drh branch: trunk, size: 1627) | |
|
2004-11-03
| ||
| 16:27 | [81bb13caaa] part of check-in [b11fc9b3f3] Update tests to work even if some features of the library are disabled. (CVS 2050) (check-in: [b11fc9b3f3] user: drh branch: trunk, size: 1196) | |
|
2002-12-04
| ||
| 13:40 | [d65c824459] part of check-in [0ad1d93879] 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: [0ad1d93879] user: drh branch: trunk, size: 1144) | |
|
2002-08-31
| ||
| 18:53 | Added: [33c850201a] part of check-in [170711ca65] Parse foreign key constraints and populate internal data structures appropriately. Constraints are still not enforced. (CVS 738) (check-in: [170711ca65] user: drh branch: trunk, size: 967) | |