aboutsummaryrefslogtreecommitdiff
path: root/src/fkey.c
Commit message (Collapse)AuthorAge
...
* Experimental changes to improve optimization of DISTINCT queries.dan2011-06-30
| | | FossilOrigin-Name: f7ba0219ef2f235543c258be736955d91ca5ecce
* Fix minor problems with foreign key constraints where the parent table is ↵dan2011-06-10
| | | | | the same as the child table. FossilOrigin-Name: 442d8d8bfe443797482354ba8766d97d3d6acaae
* Merge the scheme-parse-refactor changes into trunk: (1) addeddrh2011-04-05
|\ | | | | | | | | | | sqlite3SchemaMutexHeld() asserts, (2) Use -1 instead of 0 to mean "all" in sqlite3ResetInternalSchema(), and other cosmetic changes. FossilOrigin-Name: 5db4511d8a77b74be3503a7c34257ef6b07541f5
| * Add a description of access rules for the Schema object and lots of assertsdrh2011-04-04
| | | | | | | | | | to verify that the access rules are followed. FossilOrigin-Name: ae8374af057b6e6546e9265148cfffe32fcb0849
* | Fix the P4_TRANSIENT constant so that it works correct - so that it reallydrh2011-04-05
|/ | | | | | makes a copy of the string for the P4 argument. Use P4_TRANSIENT wherever appropriate. Change P4_STATICs of schema names to P4_TRANSIENT. FossilOrigin-Name: bf664b206bf6f5c1941da1986dfe2c0d1831d5e4
* Remove dead code identified by the clang static analyzer.drh2011-03-06
| | | FossilOrigin-Name: 01a79d5a7af48fb7e50291c0c7c6283d3fb359d0
* Continuing work toward detecting and fixing shallow-copy misuse.drh2010-09-28
| | | FossilOrigin-Name: d0342f4bb9d25dd1dba3957778faa993fb9cc81c
* Correct handling of compound foreign key constraints that include the drh2010-07-29
| | | | | | integer primary key as one of the columns. Ticket [ce7c133ea6cc9ccdc1] FossilOrigin-Name: 53902f7d4a46aa70ecc5bf180a01ff888d52686a
* Experimental code to measure memory consumed by database schemas and ↵dan2010-07-24
| | | | | prepared statements. FossilOrigin-Name: 9aa30342f4de4eff630520ea8e07ad253d3f0877
* Remove additional traces (mostly in comments) of the Table.dbMem field.drh2010-07-23
| | | FossilOrigin-Name: 5c58f44aeb224e106497368d9290d75a08807761
* Remove the Table.dbMem variable, as it is no longer being used for its ↵dan2010-07-23
| | | | | original purpose. FossilOrigin-Name: 6eddc6e601cf8f585c6c2cf79f36fcbfe98a307e
* Enhance the OP_Found and OP_NotFound opcodes so that they can accept andrh2009-11-12
| | | | | | | array of registers as an unpacked record in addition to a record built using OP_MakeRecord. Use this to avoid OP_MakeRecord calls during IN expression processing. FossilOrigin-Name: b9eab885cd2ca1a1633329e7036c125e8dba62c5
* Suppress some harmless compiler warnings.drh2009-10-13
| | | FossilOrigin-Name: 5d381daa6e5248ec171aa682e2dad058d4012f24
* Add asserts as evidence that all FK constraints are either immediate ordrh2009-10-12
| | | | | deferred. FossilOrigin-Name: 634ef4fc9f4051245b38f558bb1c733031548c2f
* When processing FK constraints on changes to parent tables, make sure thedrh2009-10-12
| | | | | names of child tables appear correctly in the output of EXPLAIN QUERY PLAN. FossilOrigin-Name: a4ab5215fed231c8e5f8714f5cadafd1209b362a
* Add a missing OP_Close opcode to VDBE programs that check for FK constraint ↵dan2009-10-07
| | | | | violations. FossilOrigin-Name: 5caa4a2b050d5743b1407485cf419aa36cf16ac6
* Handle an SQLITE_IGNORE returned when requesting authorization to read ↵dan2009-10-03
| | | | | parent key columns by pretending the parent key columns contain NULL values. FossilOrigin-Name: 3c24df38e6ae5dfe999bbf3133b65df0074c6a50
* When inserting a row into a child table, invoke the authorization callback ↵dan2009-10-02
| | | | | to request permission to read the parent key columns. FossilOrigin-Name: 9842f2d5f606eb8f641ecae9fbc5368b8d7e4286
* If an update does not modify any child or parent key columns, omit foreign ↵dan2009-10-01
| | | | | key processing for the statement. FossilOrigin-Name: edff3500058eb8ad2381f855ef7a09ecb680f7b8
* Remove unreachable branches from fkey.c. Add a few tests to cover the ↵dan2009-09-30
| | | | | remaining branches. FossilOrigin-Name: 0a0a17d87c990a811a2755b9d9d4141b611b49db
* Use the affinity and collation sequence associated with the parent key when ↵dan2009-09-29
| | | | | finding child table rows to apply a foreign key action to. FossilOrigin-Name: 9a4b7ec2928307e88783223903c842accaff7ccf
* Check that a unique index uses the default collation sequences for each ↵dan2009-09-29
| | | | | column before using it as part of a foreign key constraint operation. FossilOrigin-Name: 64154174cf8a53bd9be818db53cb0e586c5d24cb
* Remove an unused variable from fkey.c.dan2009-09-29
| | | FossilOrigin-Name: 582bd7682831362cd0e2f91ac0dba5ab2b7e2983
* Ignore foreign key mismatch errors while compiling DROP TABLE commands.dan2009-09-28
| | | FossilOrigin-Name: 5b4d46374a8e808246a1813c12c36c4a75371898
* Fix the DROP TABLE command so that it cannot be used to bypass foreign key ↵dan2009-09-28
| | | | | constraints (if foreign key support is enabled). FossilOrigin-Name: 8353808c9e70412fdee31bfda7810e948f1c7485
* Fix some foreign key constraint related problems that occur when a row ↵dan2009-09-28
| | | | | refers to itself. FossilOrigin-Name: 9e503e2d0428c9e8df878c7c6594790232cca4e0
* When ALTER TABLE RENAME TO is used to change the name of a table that is the ↵dan2009-09-26
| | | | | parent table of a foreign key constraint, modify that foreign key constraint to use the new table name. FossilOrigin-Name: b4a10c39e726dc190e9597e382baddc034294114
* Avoid checking if an insert or delete has "fixed" an outstanding FK ↵dan2009-09-25
| | | | | constraint violation if the constraint counter indicates that the database contains no such violations. FossilOrigin-Name: 519144ac437b5842e4213f0e81e05c709939c2ab
* Fix comments in fkey2.c to reflect the immediate-constraint-counter approach.dan2009-09-25
| | | FossilOrigin-Name: 9fd54b0aa73ed74c65f7db53cb666752f13263f9
* Fixes and test cases to make sure the affinity and collation sequence ↵dan2009-09-24
| | | | | associated with the parent key is used when comparing it with a child key value. FossilOrigin-Name: 76e8e74b49be4c80b9fb20d52e9b39db8001362e
* Fix a problem in fkey.c when a child key is the IPK of its table.dan2009-09-24
| | | FossilOrigin-Name: 8a000a8aae4d356e68acf2bc1788d2c40279522c
* Remove the ALWAYS() added by the previous check-in. It is not needed.drh2009-09-24
| | | FossilOrigin-Name: 36568963356e3919e8b862e7e40ded2eae7ce187
* Comment enhancements. Add an ALWAYS macro in fkey.c to indicate a branchdrh2009-09-24
| | | | | that is always taken. FossilOrigin-Name: d5b714cffffe588dd4dd10e0b82df8d99657be88
* Fix a problem with FK constraints that implicitly map to a composite primary ↵dan2009-09-23
| | | | | key. FossilOrigin-Name: e0a48d53110130de75602603f524539e421a9dba
* Do not check immediate foreign key constraints until the end of the ↵dan2009-09-23
| | | | | statement. This matches the postgres behaviour. FossilOrigin-Name: 1a32149cc3c722058f4ed4c81edadeb6ce5bc9e4
* Disallow using the implicit rowid column as the parent key of an FK constraint.dan2009-09-23
| | | FossilOrigin-Name: a5f7e71f424900071a3925e53e9128c9148ea2e8
* Add extra tests for foreign key support.dan2009-09-23
| | | FossilOrigin-Name: 7d086afe69da4d03bd1de5408626858273f91e8f
* Add missing comments to fkey.c. Also, change the terminology used for ↵dan2009-09-23
| | | | | comments and names in fkey.c from "referenced/referencing" to "parent/child". This is arguably less correct, but is easier to follow. FossilOrigin-Name: 540c2d18e14c277b55f95729fbafc04ca66466b2
* Do not run ON UPDATE actions of a foreign key constraint unless at least onedrh2009-09-23
| | | | | column value really does change. FossilOrigin-Name: 71ac8e28e55ff0250ebe2fe239159ce2458d9165
* Fix another OOM related problem in fkey.c.dan2009-09-22
| | | FossilOrigin-Name: e2bc51bc61d54d103ccffd12106c27a574e4e997
* Fix a problem with ON DELETE SET DEFAULT actions.dan2009-09-22
| | | FossilOrigin-Name: 9406995055f53639b0af46985c7b0a24a80308ae
* Fix an OOM related crash in fkey.c.dan2009-09-22
| | | FossilOrigin-Name: 635d6a775a3f192d4292738905f5e01bc956a712
* Fix a problem with foreign key constraints that map from and IPK column.dan2009-09-21
| | | FossilOrigin-Name: 84129052623dc6a175c76db602ab07fa3e57f1eb
* Fix compilation with OMIT_TRIGGER defined. Ticket ↵dan2009-09-21
| | | | | [1ff6d29030e9757d052af0f394e56bea96b8b59b|1ff6d29030]. FossilOrigin-Name: fb6ceed388f6d75bdc2ac2f43e5c98da74e2a448
* Check in implementation of foreign key constraints.dan2009-09-19
FossilOrigin-Name: d5d399811876391642937edeb9e8434dd9e356f5
generated by cgit v1.2.3 (git 2.25.1) at 2025-07-18 01:36:44 +0000