/ File History
Login

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