Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
59 events for the month beginning 2009-09-01 by user dan
Following month ↑|
2009-09-30
| ||
| 08:11 | Remove unreachable branches from fkey.c. Add a few tests to cover the remaining branches. (check-in: 0a0a17d8 user: dan tags: trunk) | |
| 04:28 | Change a couple of comments to use "SQLITE_MUTEX_OMIT" instead of OMIT_MUTEX. (check-in: b733e939 user: dan tags: trunk) | |
|
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. (check-in: 9a4b7ec2 user: dan tags: trunk) | |
| 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. (check-in: 64154174 user: dan tags: trunk) | |
| 11:28 | Remove an unused variable from fkey.c. (check-in: 582bd768 user: dan tags: trunk) | |
| 06:33 | Various fixes so that "make test" works with OMIT_FOREIGN_KEY, OMIT_TRIGGER and OMIT_ALTER_TABLE. (check-in: e4eb227b user: dan tags: trunk) | |
|
2009-09-28
| ||
| 18:52 | Ignore foreign key mismatch errors while compiling DROP TABLE commands. (check-in: 5b4d4637 user: dan tags: trunk) | |
| 14:49 | Fix the DROP TABLE command so that it cannot be used to bypass foreign key constraints (if foreign key support is enabled). (check-in: 8353808c user: dan tags: trunk) | |
| 11:54 | Fix some foreign key constraint related problems that occur when a row refers to itself. (check-in: 9e503e2d user: dan tags: trunk) | |
|
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. (check-in: b4a10c39 user: dan tags: trunk) | |
|
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. (check-in: 519144ac user: dan tags: trunk) | |
| 12:00 | Fix comments in fkey2.c to reflect the immediate-constraint-counter approach. (check-in: 9fd54b0a user: dan tags: trunk) | |
| 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. (check-in: 353b1b18 user: dan tags: trunk) | |
|
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. (check-in: 76e8e74b user: dan tags: trunk) | |
| 16:52 | Fix a bug in the code for REPLACE conflict handling on IPK columns when there are no indexes on the table. Triggers and foreign key processing were being bypassed. (check-in: beb2094f user: dan tags: trunk) | |
| 15:16 | Fix a problem in fkey.c when a child key is the IPK of its table. (check-in: 8a000a8a user: dan tags: trunk) | |
| 11:31 | Ensure foreign key related processing takes place when rows are deleted from the database by REPLACE conflict handling. (check-in: 3f40c142 user: dan tags: trunk) | |
| 10:42 | Use sqlite3FkOldmask() in delete.c instead of assuming that foreign key constraints always require all columns of the deleted row to be stored in registers. (check-in: ce554a39 user: dan tags: trunk) | |
| 09:05 | Remove unused parameter from sqlite3CodeRowTrigger(). Fix header comments for this function and CodeRowTriggerDirect(). (check-in: 0443f7c9 user: dan tags: trunk) | |
|
2009-09-23
| ||
| 18:07 | Fix a problem with FK constraints that implicitly map to a composite primary key. (check-in: e0a48d53 user: dan tags: trunk) | |
| 17:31 | Fix a problem in the fkey_malloc.test script. (check-in: 0ce1efa4 user: dan tags: trunk) | |
| 17:30 | Do not check immediate foreign key constraints until the end of the statement. This matches the postgres behaviour. (check-in: 1a32149c user: dan tags: trunk) | |
| 13:59 | Disallow using the implicit rowid column as the parent key of an FK constraint. (check-in: a5f7e71f user: dan tags: trunk) | |
| 12:06 | Add extra tests for foreign key support. (check-in: 7d086afe user: dan tags: trunk) | |
| 08:43 | 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. (check-in: 540c2d18 user: dan tags: trunk) | |
|
2009-09-22
| ||
| 16:55 | Fix another OOM related problem in fkey.c. (check-in: e2bc51bc user: dan tags: trunk) | |
| 16:08 | Fix a problem with ON DELETE SET DEFAULT actions. (check-in: 94069950 user: dan tags: trunk) | |
| 15:53 | Fix an OOM related crash in fkey.c. (check-in: 635d6a77 user: dan tags: trunk) | |
| 07:13 | Fix compilation errors when OMIT_FOREIGN_KEY is defined. (check-in: c447cb37 user: dan tags: trunk) | |
|
2009-09-21
| ||
| 18:56 | Fix a problem with foreign key constraints that map from and IPK column. (check-in: 84129052 user: dan tags: trunk) | |
| 16:34 | • Closed ticket [56928bd0]: Cannot compile with SQLITE_OMIT_UTF16 and SQLITE_ENABLE_STAT2 plus 2 other changes (artifact: 73b70a0e user: dan) | |
| 16:34 | Fix compilation with both OMIT_UTF16 and ENABLE_STAT2 defined. Ticket [56928bd084]. (check-in: cd850d49 user: dan tags: trunk) | |
| 16:14 | • Ticket [c472df6c] Segmentation fault by instead of insert triggers status still Closed with 1 other change (artifact: 3b35f100 user: dan) | |
| 16:08 | • Closed ticket [1ff6d290]: Compile fails with SQLITE_OMIT_TRIGGER plus 2 other changes (artifact: e3a1dc15 user: dan) | |
| 16:06 | Fix compilation with OMIT_TRIGGER defined. Ticket [1ff6d29030]. (check-in: fb6ceed3 user: dan tags: trunk) | |
|
2009-09-19
| ||
| 17:59 | Add fkey.c to the autoconf and amalgamation build systems. (check-in: aab7a4b3 user: dan tags: trunk) | |
| 17:00 | Check in implementation of foreign key constraints. (check-in: d5d39981 user: dan tags: trunk) | |
|
2009-09-10
| ||
| 18:26 | Update an r-tree test to account for changes in the query planner. (check-in: e5ce66d4 user: dan tags: trunk) | |
| 18:17 | Define SQLITE_TEST when compiling mem5.c for testfixture. (check-in: 6b16f3c9 user: dan tags: trunk) | |
| 18:04 | Fix a problem in test script corrupt.test. (check-in: dad2b74a user: dan tags: trunk) | |
| 16:14 | Fix a problem with the sqlite3VdbeMayAbort() assert failing following an OOM. (check-in: b3027863 user: dan tags: trunk) | |
| 10:15 | Remove an ALWAYS macro around an expression that is sometimes false. (check-in: f2a9ee72 user: dan tags: trunk) | |
|
2009-09-09
| ||
| 18:46 | Trying to open a transaction in one thread and close it in another is a misuse with LinuxThreads. Doing so may cause memory and file-descriptors to be leaked. Update an assert() and some test cases to account for this. (check-in: ef99eb57 user: dan tags: trunk) | |
| 15:06 | Add some tests that involve BEFORE UPDATE or BEFORE DELETE triggers messing with the row being updated or deleted. SQLite behaviour in this scenario is undefined, so the tests just check that the behaviour is relatively sane and there are no crashes. (check-in: 9a4c59a2 user: dan tags: trunk) | |
| 11:47 | • Closed ticket [29ab7be9]: Hitting NOT NULL constraint does not roll back statement transaction plus 3 other changes (artifact: 2e3bbe70 user: dan) | |
| 11:43 | Add a test case to show that 29ab7be99f is fixed. (check-in: 135d656a user: dan tags: trunk) | |
| 11:37 | Add a complicated assert() to check that statement transactions are opened when required. (check-in: 28aa1f4e user: dan tags: trunk) | |
| 10:31 | • New ticket [29ab7be9] Hitting NOT NULL constraint does not roll back statement transaction. (artifact: b37d2263 user: dan) | |
| 05:39 | • Ticket [eaa105fe] (...) WHERE col IN (val1) not reflected in xBestIndex status still Open with 1 other change (artifact: b2bdc091 user: dan) | |
|
2009-09-08
| ||
| 19:15 | Combine the OP_Statement and OP_Transaction opcodes. (check-in: aec9dbd8 user: dan tags: trunk) | |
| 15:55 | If recursive-triggers are enabled, fire DELETE triggers if database rows are removed as a result of OR REPLACE conflict resolution. (check-in: 85cb0c94 user: dan tags: trunk) | |
|
2009-09-07
| ||
| 17:41 | Merge 1958db4493 and 26cd015c0e. (check-in: ecbe0832 user: dan tags: trunk) | |
| 17:32 | Fix a bug where a condition was incorrectly being compiled out when SQLITE_OMIT_VIRTUALTABLE was defined. (check-in: 1958db44 user: dan tags: trunk) | |
| 14:43 | • Fixed ticket [df2c3ad1]: free() on unallocated memory when fts3 match phrase contains terms after "-" modifier plus 3 other changes (artifact: dfef7edd user: dan) | |
|
2009-09-01
| ||
| 17:28 | Fix a problem in main.c. SQLITE_NoRecTriggers -> SQLITE_RecTriggers. (check-in: 5ac69ed6 user: dan tags: trunk) | |
| 17:11 | Change "PRAGMA disable_recursive_triggers" to "PRAGMA recursive_triggers". Also a fix for compiling with OMIT_TRIGGER defined. (check-in: e016cca3 user: dan tags: trunk) | |
| 16:39 | Merge in changes to support recursive invocation of triggers (disabled by default). (check-in: c1b388c3 user: dan tags: trunk) | |
| 16:19 | Add new test script triggerC.test. (check-in: a2a062a4 user: dan tags: trunk) | |
| 12:16 | More fixes and comment updates. (check-in: 38a9327b user: dan tags: trunk) | |