Morph MORPH
SIGN IN SIGN UP
dhruvhead / sqlite UNCLAIMED
0 0 243 C

COMMITS

/ test/fkey2.test
autosetup
August 27, 2020
D
Include the original text of the CHECK constraint in the error message for
drh committed
92e21ef
May 8, 2020
D
Release some restrictions on columns added by ALTER TABLE so that they
drh committed
9e5fdc4
January 1, 2020
D
New test-only SQL functions: implies_nonnull_row(), expr_compare(), and
drh committed
171c50e
November 26, 2018
D
Do not allow direct access to internal-use SQL functions such as
drh committed
eea8eb6
September 5, 2018
D
Fix some test script errors. And an incorrect assert() in fts5.
dan committed
5921f2b
August 31, 2018
D
Ensure b-tree mutexes are always held when sqlite3FindTable() is called. Do
dan committed
141e119
December 16, 2016
D
All temp.sqlite_master to be used as an alias for sqlite_temp_master.
drh committed
e0a04a3
April 16, 2015
D
Make sure all cursors are closed when returning from a VDBE subprogram that
drh committed
ab4e7f3
D
Make sure errors in coding triggers are propagated back up to the parser.
drh committed
e06874e
April 10, 2015
D
Fix foreign key CASCADE for cases where the parent key is an INTEGER PRIMARY
drh committed
e918aab
September 11, 2014
D
Add support for the extra parameter on the sqlite3_set_authorizer() callback
drh committed
32c6a48
November 5, 2013
D
Standardize the error messages generated by constraint failures to a format
drh committed
f9c8ce3
D
Add the conflict2.test script. Fix issues discovered by this script.
drh committed
00012df
February 9, 2013
D
Rename SQLITE_CONSTRAINT_RAISE to SQLITE_CONSTRAINT_TRIGGER. Put the
drh committed
433dccf
December 17, 2012
D
Enhance the error message for "foreign key mismatch" to include the names of
drh committed
9148def
January 17, 2011
D
Add the SQLITE_OMIT_AUTORESET compile-time option which if enabled causes
drh committed
602acb4
July 29, 2010
D
Correct handling of compound foreign key constraints that include the
drh committed
6cbda64
May 29, 2010
D
Add tests to fkey2.test to check that ON CONFLICT clauses do not affect SQLite's behaviour when an FK constraint is violated.
dan committed
a7a0c61
May 14, 2010
D
Make sure the value of an INTEGER PRIMARY KEY column supplied to triggers
drh committed
5c092e8
April 29, 2010
D
Zero the "immediate FK constraint counter" associated with a statement object when sqlite3_reset() is called. Fix for [c39ff61c43].
dan committed
6908343
April 17, 2010
D
Change sqlite3_step() so that it automatically calls sqlite3_reset() instead
drh committed
3674bfd
February 15, 2010
D
Fix the ALTER TABLE RENAME command so that it converts FOREIGN KEY constraints
drh committed
9a6ffc8
October 7, 2009
D
Add some tests of statements in foreignkeys.html.
dan committed
f589450
October 3, 2009
D
Handle an SQLITE_IGNORE returned when requesting authorization to read parent key columns by pretending the parent key columns contain NULL values.
dan committed
02470b2
October 2, 2009
D
Add one more authentication test to fkey2.test to cover an untested branch.
dan committed
251ad6e
D
When inserting a row into a child table, invoke the authorization callback to request permission to read the parent key columns.
dan committed
47a0634
October 1, 2009
D
Add test cases to cover the branches added by the previous commit.
dan committed
3d7b046
D
If an update does not modify any child or parent key columns, omit foreign key processing for the statement.
dan committed
e7a94d8
D
Add tests to check that FK support interacts with count-changes correctly.
dan committed
d583502
September 30, 2009
D
Remove unreachable branches from fkey.c. Add a few tests to cover the remaining branches.
dan committed
f7a9454
September 29, 2009
D
Use the affinity and collation sequence associated with the parent key when finding child table rows to apply a foreign key action to.
dan committed
652ac1d
D
Check that a unique index uses the default collation sequences for each column before using it as part of a foreign key constraint operation.
dan committed
9707c7b
D
Remove an unused variable from fkey.c.
dan committed
792e920
D
Various fixes so that "make test" works with OMIT_FOREIGN_KEY, OMIT_TRIGGER and OMIT_ALTER_TABLE.
dan committed
856ef1a
September 28, 2009
D
Ignore foreign key mismatch errors while compiling DROP TABLE commands.
dan committed
f066256
D
Fix the DROP TABLE command so that it cannot be used to bypass foreign key constraints (if foreign key support is enabled).
dan committed
d66c830
D
Fix some foreign key constraint related problems that occur when a row refers to itself.
dan committed
9277efa
September 26, 2009
D
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.
dan committed
432cc5b
September 25, 2009
D
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.
dan committed
0ff297e
D
Fix comments in fkey2.c to reflect the immediate-constraint-counter approach.
dan committed
bd74783
D
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.
dan committed
53c3fa8
September 24, 2009
D
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.
dan committed
140026b
D
Ensure foreign key related processing takes place when rows are deleted from the database by REPLACE conflict handling.
dan committed
1bea559
September 23, 2009
D
Do not check immediate foreign key constraints until the end of the statement. This matches the postgres behaviour.
dan committed
32b09f2
D
Disallow using the implicit rowid column as the parent key of an FK constraint.
dan committed
d981d44
D
Add extra tests for foreign key support.
dan committed
a8f0bf6
September 22, 2009
D
Fix a problem with ON DELETE SET DEFAULT actions.
dan committed
934ce30
D
Fix an OOM related crash in fkey.c.
dan committed
29c7f9c
September 21, 2009
D
Fix a problem with foreign key constraints that map from and IPK column.
dan committed
3606264
D
Fix compilation with OMIT_TRIGGER defined. Ticket [1ff6d29030e9757d052af0f394e56bea96b8b59b|1ff6d29030].
dan committed
75cbd98