Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for test/fkey2.test
2020-08-27
| ||
18:36 | [1063d65e59] part of check-in [5ce34a955b] Include the original text of the CHECK constraint in the error message for anonymous CHECK constraints. (check-in: [5ce34a955b] user: drh branch: trunk, size: 62240) | |
2020-05-08
| ||
19:02 | [b1b6a8c555] part of check-in [3a16c0ce4d] Release some restrictions on columns added by ALTER TABLE so that they only apply if the table contains one or more rows. (check-in: [3a16c0ce4d] user: drh branch: trunk, size: 62236) | |
2020-01-01
| ||
15:43 | [65c86b1112] part of check-in [473892a8ec] New test-only SQL functions: implies_nonnull_row(), expr_compare(), and expr_implies_expr(). The SQLITE_TESTCTRL_INTERNAL_FUNCTIONS test-control is modified to toggle internal function access on and off for a single database connection. (check-in: [473892a8ec] user: drh branch: trunk, size: 62120) | |
2018-11-26
| ||
18:09 | [d35d1c81e7] part of check-in [6e1330545e] Do not allow direct access to internal-use SQL functions such as sqlite_rename_column() and sqlite3_rename_table() except when the new SQLITE_TESTCTRL_INTERNAL_FUNCTIONS flag is set. (check-in: [6e1330545e] user: drh branch: trunk, size: 62114) | |
2018-09-05
| ||
17:45 | [6206484a0e] part of check-in [f804336f08] Fix some test script errors. And an incorrect assert() in fts5. (check-in: [f804336f08] user: dan branch: alter-table-rename-column, size: 61754) | |
2018-08-31
| ||
18:23 | [f2e5a7691c] part of check-in [eac2aa7dce] Ensure b-tree mutexes are always held when sqlite3FindTable() is called. Do not invoke the authorizer callback when parsing schema items as part of ALTER TABLE commands. Fix test script issues. (check-in: [eac2aa7dce] user: dan branch: alter-table-rename-table, size: 61725) | |
2016-12-16
| ||
01:00 | [155809016f] part of check-in [8d646905b8] All temp.sqlite_master to be used as an alias for sqlite_temp_master. (check-in: [8d646905b8] user: drh branch: trunk, size: 61715) | |
2015-04-16
| ||
18:11 | [f3d27ecba4] part of check-in [d04d354d8e] Make sure all cursors are closed when returning from a VDBE subprogram that implements a foreign-key construct. (check-in: [d04d354d8e] user: drh branch: trunk, size: 61715) | |
15:47 | [043692a609] part of check-in [928f973ca9] Make sure errors in coding triggers are propagated back up to the parser. (check-in: [928f973ca9] user: drh branch: trunk, size: 61561) | |
2015-04-10
| ||
12:04 | [223c624e7e] part of check-in [ed3cbaab6a] Fix foreign key CASCADE for cases where the parent key is an INTEGER PRIMARY KEY and the parent table contains other columns named "rowid", "_rowid_", and "oid". (check-in: [ed3cbaab6a] user: drh branch: trunk, size: 61113) | |
2014-09-11
| ||
13:44 | [1db212cda8] part of check-in [596e728b0e] Add support for the extra parameter on the sqlite3_set_authorizer() callback and support for failing an ATTACH with an authentication-required database using bad credentials. The extension is now feature complete, but much testing and bug-fixing remains. (check-in: [596e728b0e] user: drh branch: user-auth, size: 61071) | |
2013-11-05
| ||
13:33 | [32ca728bcb] 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: 61059) | |
01:59 | [c9b3a4f1e6] part of check-in [294ed33756] Add the conflict2.test script. Fix issues discovered by this script. (check-in: [294ed33756] user: drh branch: omit-rowid, size: 61028) | |
2013-02-09
| ||
15:37 | [06e0b4cc9e] part of check-in [3f67437536] Rename SQLITE_CONSTRAINT_RAISE to SQLITE_CONSTRAINT_TRIGGER. Put the extended constraint error codes in alphabetical order. Add many test cases for the extended constraint error codes. (check-in: [3f67437536] user: drh branch: constraint-error-codes, size: 61029) | |
2012-12-17
| ||
20:40 | [5aa44e7153] part of check-in [0f9963526c] Enhance the error message for "foreign key mismatch" to include the names of the child and parent tables. Begin adding test cases for PRAGMA foreign_key_check. Make sure PRAGMA foreign_key_check gets all necessary table locks. (check-in: [0f9963526c] user: drh branch: foreign-key-check, size: 60602) | |
2011-01-17
| ||
17:42 | [080969fe21] part of check-in [053ce76deb] Add the SQLITE_OMIT_AUTORESET compile-time option which if enabled causes the sqlite3_step() routine to return SQLITE_MISUSE if it is called after it has previously returned anything other than SQLITE_ROW, SQLITE_BUSY, or SQLITE_LOCKED. (check-in: [053ce76deb] user: drh branch: trunk, size: 59181) | |
2011-01-11
| ||
01:42 | [64cf8ff5f9] part of check-in [d1b3c54f42] A proposed change to the sqlite3_step() API such that it will only auto-reset following an SQLITE_BUSY or SQLITE_LOCKED error. Calls after any other result other than SQLITE_ROW will return SQLITE_MISUSE. (check-in: [d1b3c54f42] user: drh branch: step-autoreset, size: 59070) | |
2010-07-29
| ||
01:50 | [e028cd80aa] part of check-in [53902f7d4a] Correct handling of compound foreign key constraints that include the integer primary key as one of the columns. Ticket [ce7c133ea6cc9ccdc1] (check-in: [53902f7d4a] user: drh branch: trunk, size: 59074) | |
2010-05-29
| ||
08:40 | [098c06c139] part of check-in [e9e5b10019] Add tests to fkey2.test to check that ON CONFLICT clauses do not affect SQLite's behaviour when an FK constraint is violated. (check-in: [e9e5b10019] user: dan branch: trunk, size: 57668) | |
2010-05-14
| ||
19:24 | [4369be5ef6] part of check-in [636f86095e] Make sure the value of an INTEGER PRIMARY KEY column supplied to triggers and especially to FK constraints really contains the ROWID and not the NULL that is stored in the column itself. Ticket [dd08e5a988d00dec]. (check-in: [636f86095e] user: drh branch: trunk, size: 55366) | |
2010-04-30
| ||
05:57 | [d5e065ede2] part of check-in [f660be615a] Zero the "immediate FK constraint counter" associated with a statement object when sqlite3_reset() is called. Fix for [c39ff61c43]. (check-in: [f660be615a] user: dan branch: trunk, size: 54232) | |
2010-04-17
| ||
12:53 | [82652daf32] part of check-in [3e646e3f4c] Change sqlite3_step() so that it automatically calls sqlite3_reset() instead of returning SQLITE_MISUSE when invoked on a prepared statement that previously returned any value other than SQLITE_ROW. (check-in: [3e646e3f4c] user: drh branch: trunk, size: 53636) | |
2010-02-15
| ||
18:03 | [e71f5baf9b] part of check-in [ab197d0aaf] Fix the ALTER TABLE RENAME command so that it converts FOREIGN KEY constraints in ATTACH-ed and in TEMP tables as well as in the main database. Ticket [13336e9c3c8c3f]. (check-in: [ab197d0aaf] user: drh branch: trunk, size: 53632) | |
2009-10-07
| ||
18:41 | [add654160d] part of check-in [8382867956] Add some tests of statements in foreignkeys.html. (check-in: [8382867956] user: dan branch: trunk, size: 47229) | |
2009-10-03
| ||
07:04 | [2220d73846] part of check-in [3c24df38e6] Handle an SQLITE_IGNORE returned when requesting authorization to read parent key columns by pretending the parent key columns contain NULL values. (check-in: [3c24df38e6] user: dan branch: trunk, size: 47519) | |
2009-10-02
| ||
15:29 | [10ac5a185b] part of check-in [e4fa8be770] Add one more authentication test to fkey2.test to cover an untested branch. (check-in: [e4fa8be770] user: dan branch: trunk, size: 47095) | |
14:23 | [e4bc39a77e] part of check-in [9842f2d5f6] When inserting a row into a child table, invoke the authorization callback to request permission to read the parent key columns. (check-in: [9842f2d5f6] user: dan branch: trunk, size: 46764) | |
2009-10-01
| ||
17:13 | [8a3620f0f2] part of check-in [aaa005b6da] Add test cases to cover the branches added by the previous commit. (check-in: [aaa005b6da] user: dan branch: trunk, size: 44523) | |
16:09 | [695b21b57e] part of check-in [edff350005] If an update does not modify any child or parent key columns, omit foreign key processing for the statement. (check-in: [edff350005] user: dan branch: trunk, size: 44377) | |
04:35 | [7ca63ae078] part of check-in [5b8366154b] Add tests to check that FK support interacts with count-changes correctly. (check-in: [5b8366154b] user: dan branch: trunk, size: 43986) | |
2009-09-30
| ||
08:11 | [023917f6d1] part of check-in [0a0a17d87c] Remove unreachable branches from fkey.c. Add a few tests to cover the remaining branches. (check-in: [0a0a17d87c] user: dan branch: trunk, size: 40673) | |
2009-09-29
| ||
16:38 | [df3c11ad1e] part of check-in [9a4b7ec292] Use the affinity and collation sequence associated with the parent key when finding child table rows to apply a foreign key action to. (check-in: [9a4b7ec292] user: dan branch: trunk, size: 37951) | |
15:41 | [dbed32250f] part of check-in [64154174cf] Check that a unique index uses the default collation sequences for each column before using it as part of a foreign key constraint operation. (check-in: [64154174cf] user: dan branch: trunk, size: 36997) | |
11:28 | [73f7f72f98] part of check-in [582bd76828] Remove an unused variable from fkey.c. (check-in: [582bd76828] user: dan branch: trunk, size: 35768) | |
06:33 | [3efd8c692e] part of check-in [e4eb227b14] Various fixes so that "make test" works with OMIT_FOREIGN_KEY, OMIT_TRIGGER and OMIT_ALTER_TABLE. (check-in: [e4eb227b14] user: dan branch: trunk, size: 35606) | |
2009-09-28
| ||
18:52 | [a041806ef6] part of check-in [5b4d46374a] Ignore foreign key mismatch errors while compiling DROP TABLE commands. (check-in: [5b4d46374a] user: dan branch: trunk, size: 35416) | |
14:49 | [d26f490838] part of check-in [8353808c9e] Fix the DROP TABLE command so that it cannot be used to bypass foreign key constraints (if foreign key support is enabled). (check-in: [8353808c9e] user: dan branch: trunk, size: 34445) | |
11:54 | [b879ba9581] part of check-in [9e503e2d04] Fix some foreign key constraint related problems that occur when a row refers to itself. (check-in: [9e503e2d04] user: dan branch: trunk, size: 34366) | |
2009-09-26
| ||
17:51 | [13e99ef0ca] part of check-in [b4a10c39e7] When ALTER TABLE RENAME TO is used to change the name of a table that is the parent table of a foreign key constraint, modify that foreign key constraint to use the new table name. (check-in: [b4a10c39e7] user: dan branch: trunk, size: 32774) | |
2009-09-25
| ||
17:03 | [4b22c954c3] part of check-in [519144ac43] Avoid checking if an insert or delete has "fixed" an outstanding FK constraint violation if the constraint counter indicates that the database contains no such violations. (check-in: [519144ac43] user: dan branch: trunk, size: 30823) | |
12:00 | [8f857439fe] part of check-in [9fd54b0aa7] Fix comments in fkey2.c to reflect the immediate-constraint-counter approach. (check-in: [9fd54b0aa7] user: dan branch: trunk, size: 29087) | |
11:26 | [ad58088fbc] part of check-in [353b1b1825] Prevent ALTER TABLE from being used to add a column with a REFERENCES clause and a non-NULL default value while foreign key support is enabled. (check-in: [353b1b1825] user: dan branch: trunk, size: 28454) | |
2009-09-24
| ||
18:19 | [c81035086c] part of check-in [76e8e74b49] Fixes and test cases to make sure the affinity and collation sequence associated with the parent key is used when comparing it with a child key value. (check-in: [76e8e74b49] user: dan branch: trunk, size: 26952) | |
11:31 | [30dedac189] part of check-in [3f40c142c8] Ensure foreign key related processing takes place when rows are deleted from the database by REPLACE conflict handling. (check-in: [3f40c142c8] user: dan branch: trunk, size: 25599) | |
2009-09-23
| ||
17:30 | [d1d78b106d] part of check-in [1a32149cc3] Do not check immediate foreign key constraints until the end of the statement. This matches the postgres behaviour. (check-in: [1a32149cc3] user: dan branch: trunk, size: 24149) | |
13:59 | [9f451a4769] part of check-in [a5f7e71f42] Disallow using the implicit rowid column as the parent key of an FK constraint. (check-in: [a5f7e71f42] user: dan branch: trunk, size: 23851) | |
12:06 | [24668ccff4] part of check-in [7d086afe69] Add extra tests for foreign key support. (check-in: [7d086afe69] user: dan branch: trunk, size: 23601) | |
2009-09-22
| ||
16:08 | [b752d02908] part of check-in [9406995055] Fix a problem with ON DELETE SET DEFAULT actions. (check-in: [9406995055] user: dan branch: trunk, size: 21125) | |
15:53 | [968812cf06] part of check-in [635d6a775a] Fix an OOM related crash in fkey.c. (check-in: [635d6a775a] user: dan branch: trunk, size: 20153) | |
2009-09-21
| ||
18:56 | [a8055d90ee] part of check-in [8412905262] Fix a problem with foreign key constraints that map from and IPK column. (check-in: [8412905262] user: dan branch: trunk, size: 18886) | |
16:06 | [62d02fb2c0] part of check-in [fb6ceed388] Fix compilation with OMIT_TRIGGER defined. Ticket [1ff6d29030]. (check-in: [fb6ceed388] user: dan branch: trunk, size: 17816) | |
2009-09-19
| ||
17:00 | Added: [207e2cc4bc] part of check-in [d5d3998118] Check in implementation of foreign key constraints. (check-in: [d5d3998118] user: dan branch: trunk, size: 17326) | |