Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History of test/fkey2.test
|
2018-11-26
| ||
| 18:09 | 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. file: [d35d1c81] check-in: [6e133054] user: drh branch: trunk, size: 62114 | |
|
2018-09-05
| ||
| 17:45 | Fix some test script errors. And an incorrect assert() in fts5. file: [6206484a] check-in: [f804336f] user: dan branch: alter-table-rename-column, size: 61754 | |
|
2018-08-31
| ||
| 18:23 | 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. file: [f2e5a769] check-in: [eac2aa7d] user: dan branch: alter-table-rename-table, size: 61725 | |
|
2016-12-16
| ||
| 01:00 | All temp.sqlite_master to be used as an alias for sqlite_temp_master. file: [15580901] check-in: [8d646905] user: drh branch: trunk, size: 61715 | |
|
2015-04-16
| ||
| 18:11 | Make sure all cursors are closed when returning from a VDBE subprogram that implements a foreign-key construct. file: [f3d27ecb] check-in: [d04d354d] user: drh branch: trunk, size: 61715 | |
| 15:47 | Make sure errors in coding triggers are propagated back up to the parser. file: [043692a6] check-in: [928f973c] user: drh branch: trunk, size: 61561 | |
|
2015-04-10
| ||
| 12:04 | 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". file: [223c624e] check-in: [ed3cbaab] user: drh branch: trunk, size: 61113 | |
|
2014-09-11
| ||
| 13:44 | 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. file: [1db212cd] check-in: [596e728b] user: drh branch: user-auth, size: 61071 | |
|
2013-11-05
| ||
| 13:33 | 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. file: [32ca728b] check-in: [54b22192] user: drh branch: omit-rowid, size: 61059 | |
| 01:59 | Add the conflict2.test script. Fix issues discovered by this script. file: [c9b3a4f1] check-in: [294ed337] user: drh branch: omit-rowid, size: 61028 | |
|
2013-02-09
| ||
| 15:37 | 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. file: [06e0b4cc] check-in: [3f674375] user: drh branch: constraint-error-codes, size: 61029 | |
|
2012-12-17
| ||
| 20:40 | 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. file: [5aa44e71] check-in: [0f996352] user: drh branch: foreign-key-check, size: 60602 | |
|
2011-01-17
| ||
| 17:42 | 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. file: [080969fe] check-in: [053ce76d] user: drh branch: trunk, size: 59181 | |
|
2011-01-11
| ||
| 01:42 | 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. file: [64cf8ff5] check-in: [d1b3c54f] user: drh branch: step-autoreset, size: 59070 | |
|
2010-07-29
| ||
| 01:50 | Correct handling of compound foreign key constraints that include the integer primary key as one of the columns. Ticket [ce7c133ea6cc9ccdc1] file: [e028cd80] check-in: [53902f7d] user: drh branch: trunk, size: 59074 | |
|
2010-05-29
| ||
| 08:40 | Add tests to fkey2.test to check that ON CONFLICT clauses do not affect SQLite's behaviour when an FK constraint is violated. file: [098c06c1] check-in: [e9e5b100] user: dan branch: trunk, size: 57668 | |
|
2010-05-14
| ||
| 19:24 | 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]. file: [4369be5e] check-in: [636f8609] user: drh branch: trunk, size: 55366 | |
|
2010-04-30
| ||
| 05:57 | Zero the "immediate FK constraint counter" associated with a statement object when sqlite3_reset() is called. Fix for [c39ff61c43]. file: [d5e065ed] check-in: [f660be61] user: dan branch: trunk, size: 54232 | |
|
2010-04-17
| ||
| 12:53 | 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. file: [82652daf] check-in: [3e646e3f] user: drh branch: trunk, size: 53636 | |
|
2010-02-15
| ||
| 18:03 | 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]. file: [e71f5baf] check-in: [ab197d0a] user: drh branch: trunk, size: 53632 | |
|
2009-10-07
| ||
| 18:41 | Add some tests of statements in foreignkeys.html. file: [add65416] check-in: [83828679] user: dan branch: trunk, size: 47229 | |
|
2009-10-03
| ||
| 07:04 | Handle an SQLITE_IGNORE returned when requesting authorization to read parent key columns by pretending the parent key columns contain NULL values. file: [2220d738] check-in: [3c24df38] user: dan branch: trunk, size: 47519 | |
|
2009-10-02
| ||
| 15:29 | Add one more authentication test to fkey2.test to cover an untested branch. file: [10ac5a18] check-in: [e4fa8be7] user: dan branch: trunk, size: 47095 | |
| 14:23 | When inserting a row into a child table, invoke the authorization callback to request permission to read the parent key columns. file: [e4bc39a7] check-in: [9842f2d5] user: dan branch: trunk, size: 46764 | |
|
2009-10-01
| ||
| 17:13 | Add test cases to cover the branches added by the previous commit. file: [8a3620f0] check-in: [aaa005b6] user: dan branch: trunk, size: 44523 | |
| 16:09 | If an update does not modify any child or parent key columns, omit foreign key processing for the statement. file: [695b21b5] check-in: [edff3500] user: dan branch: trunk, size: 44377 | |
| 04:35 | Add tests to check that FK support interacts with count-changes correctly. file: [7ca63ae0] check-in: [5b836615] user: dan branch: trunk, size: 43986 | |
|
2009-09-30
| ||
| 08:11 | Remove unreachable branches from fkey.c. Add a few tests to cover the remaining branches. file: [023917f6] check-in: [0a0a17d8] user: dan branch: trunk, size: 40673 | |
|
2009-09-29
| ||
| 16:38 | Use the affinity and collation sequence associated with the parent key when finding child table rows to apply a foreign key action to. file: [df3c11ad] check-in: [9a4b7ec2] user: dan branch: trunk, size: 37951 | |
| 15:41 | Check that a unique index uses the default collation sequences for each column before using it as part of a foreign key constraint operation. file: [dbed3225] check-in: [64154174] user: dan branch: trunk, size: 36997 | |
| 11:28 | Remove an unused variable from fkey.c. file: [73f7f72f] check-in: [582bd768] user: dan branch: trunk, size: 35768 | |
| 06:33 | Various fixes so that "make test" works with OMIT_FOREIGN_KEY, OMIT_TRIGGER and OMIT_ALTER_TABLE. file: [3efd8c69] check-in: [e4eb227b] user: dan branch: trunk, size: 35606 | |
|
2009-09-28
| ||
| 18:52 | Ignore foreign key mismatch errors while compiling DROP TABLE commands. file: [a041806e] check-in: [5b4d4637] user: dan branch: trunk, size: 35416 | |
| 14:49 | Fix the DROP TABLE command so that it cannot be used to bypass foreign key constraints (if foreign key support is enabled). file: [d26f4908] check-in: [8353808c] user: dan branch: trunk, size: 34445 | |
| 11:54 | Fix some foreign key constraint related problems that occur when a row refers to itself. file: [b879ba95] check-in: [9e503e2d] user: dan branch: trunk, size: 34366 | |
|
2009-09-26
| ||
| 17:51 | 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. file: [13e99ef0] check-in: [b4a10c39] user: dan branch: trunk, size: 32774 | |
|
2009-09-25
| ||
| 17:03 | 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. file: [4b22c954] check-in: [519144ac] user: dan branch: trunk, size: 30823 | |
| 12:00 | Fix comments in fkey2.c to reflect the immediate-constraint-counter approach. file: [8f857439] check-in: [9fd54b0a] user: dan branch: trunk, size: 29087 | |
| 11:26 | 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. file: [ad58088f] check-in: [353b1b18] user: dan branch: trunk, size: 28454 | |
|
2009-09-24
| ||
| 18:19 | 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. file: [c8103508] check-in: [76e8e74b] user: dan branch: trunk, size: 26952 | |
| 11:31 | Ensure foreign key related processing takes place when rows are deleted from the database by REPLACE conflict handling. file: [30dedac1] check-in: [3f40c142] user: dan branch: trunk, size: 25599 | |
|
2009-09-23
| ||
| 17:30 | Do not check immediate foreign key constraints until the end of the statement. This matches the postgres behaviour. file: [d1d78b10] check-in: [1a32149c] user: dan branch: trunk, size: 24149 | |
| 13:59 | Disallow using the implicit rowid column as the parent key of an FK constraint. file: [9f451a47] check-in: [a5f7e71f] user: dan branch: trunk, size: 23851 | |
| 12:06 | Add extra tests for foreign key support. file: [24668ccf] check-in: [7d086afe] user: dan branch: trunk, size: 23601 | |
|
2009-09-22
| ||
| 16:08 | Fix a problem with ON DELETE SET DEFAULT actions. file: [b752d029] check-in: [94069950] user: dan branch: trunk, size: 21125 | |
| 15:53 | Fix an OOM related crash in fkey.c. file: [968812cf] check-in: [635d6a77] user: dan branch: trunk, size: 20153 | |
|
2009-09-21
| ||
| 18:56 | Fix a problem with foreign key constraints that map from and IPK column. file: [a8055d90] check-in: [84129052] user: dan branch: trunk, size: 18886 | |
| 16:06 | Fix compilation with OMIT_TRIGGER defined. Ticket [1ff6d29030]. file: [62d02fb2] check-in: [fb6ceed3] user: dan branch: trunk, size: 17816 | |
|
2009-09-19
| ||
| 17:00 | Check in implementation of foreign key constraints. file: [207e2cc4] check-in: [d5d39981] user: dan branch: trunk, size: 17326 Added | |