๐ AIๆ็ดข & ไปฃ็
๐
ไธป้กต
Sign in
chromium
/
external
/
github.com
/
sqlite
/
sqlite
/
refs/heads/wal
/
src
/
fkey.c
8cff69d
Enhance the OP_Found and OP_NotFound opcodes so that they can accept an
by drh
ยท 16 years ago
d3ceeb5
Suppress some harmless compiler warnings.
by drh
ยท 16 years ago
4c42983
Add asserts as evidence that all FK constraints are either immediate or
by drh
ยท 16 years ago
9a616f5
When processing FK constraints on changes to parent tables, make sure the
by drh
ยท 16 years ago
ed81bf6
Add a missing OP_Close opcode to VDBE programs that check for FK constraint violations.
by dan
ยท 16 years ago
02470b2
Handle an SQLITE_IGNORE returned when requesting authorization to read parent key columns by pretending the parent key columns contain NULL values.
by dan
ยท 16 years ago
47a0634
When inserting a row into a child table, invoke the authorization callback to request permission to read the parent key columns.
by dan
ยท 16 years ago
e7a94d8
If an update does not modify any child or parent key columns, omit foreign key processing for the statement.
by dan
ยท 16 years ago
f7a9454
Remove unreachable branches from fkey.c. Add a few tests to cover the remaining branches.
by dan
ยท 16 years ago
652ac1d
Use the affinity and collation sequence associated with the parent key when finding child table rows to apply a foreign key action to.
by dan
ยท 16 years ago
9707c7b
Check that a unique index uses the default collation sequences for each column before using it as part of a foreign key constraint operation.
by dan
ยท 16 years ago
792e920
Remove an unused variable from fkey.c.
by dan
ยท 16 years ago
f066256
Ignore foreign key mismatch errors while compiling DROP TABLE commands.
by dan
ยท 16 years ago
d66c830
Fix the DROP TABLE command so that it cannot be used to bypass foreign key constraints (if foreign key support is enabled).
by dan
ยท 16 years ago
9277efa
Fix some foreign key constraint related problems that occur when a row refers to itself.
by dan
ยท 16 years ago
432cc5b
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.
by dan
๏ฟฝ๏ฟฝ 16 years ago
0ff297e
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.
by dan
ยท 16 years ago
bd74783
Fix comments in fkey2.c to reflect the immediate-constraint-counter approach.
by dan
ยท 16 years ago
140026b
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.
by dan
ยท 16 years ago
8c43004
Fix a problem in fkey.c when a child key is the IPK of its table.
by dan
ยท 16 years ago
46803c3
Remove the ALWAYS() added by the previous check-in. It is not needed.
by drh
ยท 16 years ago
1f638ce
Comment enhancements. Add an ALWAYS macro in fkey.c to indicate a branch
by drh
ยท 16 years ago
8a2fff7
Fix a problem with FK constraints that implicitly map to a composite primary key.
by dan
ยท 16 years ago
32b09f2
Do not check immediate foreign key constraints until the end of the statement. This matches the postgres behaviour.
by dan
ยท 16 years ago
d981d44
Disallow using the implicit rowid column as the parent key of an FK constraint.
by dan
ยท 16 years ago
a8f0bf6
Add extra tests for foreign key support.
by dan
ยท 16 years ago
8099ce6
Add missing comments to fkey.c. Also, change the terminology used for comments and names in fkey.c from "referenced/referencing" to "parent/child". This is arguably less correct, but is easier to follow.
by dan
ยท 16 years ago
788536b
Do not run ON UPDATE actions of a foreign key constraint unless at least one
by drh
ยท 16 years ago
f59c5ca
Fix another OOM related problem in fkey.c.
by dan
ยท 16 years ago
934ce30
Fix a problem with ON DELETE SET DEFAULT actions.
by dan
ยท 16 years ago
29c7f9c
Fix an OOM related crash in fkey.c.
by dan
ยท 16 years ago
3606264
Fix a problem with foreign key constraints that map from and IPK column.
by dan
ยท 16 years ago
75cbd98
Fix compilation with OMIT_TRIGGER defined. Ticket [1ff6d29030e9757d052af0f394e56bea96b8b59b|1ff6d29030].
by dan
ยท 16 years ago
1da40a3
Check in implementation of foreign key constraints.
by dan
ยท 16 years ago