Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 check-ins occurring around 3c24df38e6ae5dfe.
2009-10-19
| ||
18:30 | Fix an assert() that may fail if sqlite3_step() is called on a statement after a previous call has already returned SQLITE_SCHEMA. (check-in: 63bf7345 user: dan tags: trunk) | |
18:11 | Remove the sqlite3_reoptimize() API. The same functionality is now provided automatically to queries prepared using prepare_v2(). (check-in: 2c50b3d5 user: dan tags: trunk) | |
15:52 | When generating WHERE clause terms internally for NATURAL and USING joins, identify the table by its position in the FROM list, not by its name or alias. Fix for [b73fb0bd64]. (check-in: 6fe63711 user: dan tags: trunk) | |
07:50 | Use 64-bit arithmetic in the xRead() method of asyncRead. Fix for [94c04eaadb]. (check-in: ca3e41b0 user: dan tags: trunk) | |
2009-10-17
| ||
14:19 | Fix a problem in the icu.test script. (check-in: 8a21fdaf user: dan tags: trunk) | |
13:13 | Make sure the target register is allocated before adding the bogus OP_Variable opcode in isLikeOrGlob(). Bugfix for the new sqlite3_reoptimize() logic. (check-in: e74f8dc4 user: drh tags: trunk) | |
08:26 | Add documentation comment for new experimental API sqlite3_reoptimize(). (check-in: c48f8ffe user: dan tags: trunk) | |
2009-10-16
| ||
16:21 | Merge the sqlite3_reoptimize() changes into the trunk. (check-in: 50136840 user: drh tags: trunk) | |
15:59 | Fix a problem in the analyze3.test script. (Closed-Leaf check-in: 61174aea user: dan tags: experimental) | |
15:19 | Remove a mutex reference leak from sqlite3_reoptimize(). (check-in: 9f093706 user: dan tags: experimental) | |
15:05 | Comment cleanup in btree.c. (check-in: 32966ba4 user: drh tags: trunk) | |
14:55 | Experimental fix for [f777251dc7]. This may be changed yet. (check-in: 174477bc user: dan tags: trunk) | |
13:23 | Fix comment typos in btreeInt.h. (check-in: 550566a7 user: drh tags: trunk) | |
2009-10-15
| ||
23:03 | When a forced rollback occurs, cause all active statements on the same database connection to halt immediately with an SQLITE_ABORT error code. This is a partial fix to ticket [f777251dc7]. (Closed-Leaf check-in: f256bc07 user: drh tags: trunk, experimental) | |
19:45 | On any rollback, immediately interrupt all running statements on the same database connection. This is a partial fix for ticket [f777251dc7]. (Closed-Leaf check-in: c304b44c user: drh tags: experimental) | |
18:35 | Add the experimental sqlite3_reoptimize() API. (check-in: 9bd6f3d8 user: dan tags: experimental) | |
2009-10-14
| ||
11:33 | Version 3.6.19 (check-in: c1d499af user: drh tags: trunk, release) | |
2009-10-13
| ||
22:47 | Update the configure script for version 3.6.19. (check-in: ac19dbc6 user: drh tags: trunk) | |
19:19 | Fixed warnings with MSVC compile. (check-in: e0aa50c3 user: shane tags: trunk) | |
18:49 | Fix a typo in the test script added for ticket [5ee23731f15]. (check-in: d0f55b5c user: drh tags: trunk) | |
18:38 | Update the TCL wrapper to provide a non-NULL objProc pointer to the Tcl_NRCreateCommand() interface. The TCL gurus say this is needed to support legacy TCL extensions. (check-in: 1b3cfa01 user: drh tags: trunk) | |
15:42 | Add a test case to verify that ticket [5ee23731f15] has been fixed. (check-in: f894ebf8 user: drh tags: trunk) | |
15:36 | When a write transaction fails to being because the database is read-only, fail right away. Do not give the error code an opportunity to be overwritten with SQLITE_OK. Ticket [5ee23731f15]. (check-in: bc110117 user: drh tags: trunk) | |
13:08 | Suppress some harmless compiler warnings. (check-in: 5d381daa user: drh tags: trunk) | |
12:48 | Make sure mem3.c releases its mutex on an sqlite3_shutdown() call. (check-in: 16254ad5 user: drh tags: trunk) | |
10:39 | Add further test cases to e_fkey.test. (check-in: c85e5874 user: dan tags: trunk) | |
2009-10-12
| ||
22:30 | Add asserts as evidence that all FK constraints are either immediate or deferred. (check-in: 634ef4fc user: drh tags: trunk) | |
20:01 | When processing FK constraints on changes to parent tables, make sure the names of child tables appear correctly in the output of EXPLAIN QUERY PLAN. (check-in: a4ab5215 user: drh tags: trunk) | |
18:57 | Add more test cases to e_fkey.test. (check-in: 5633cb2b user: dan tags: trunk) | |
16:02 | Fix some mappings from e_fkey.test. (check-in: 171c6713 user: dan tags: trunk) | |
15:25 | Update e_fkey.test to match the latest version of foreignkeys.html. (check-in: a2ca9f1a user: dan tags: trunk) | |
11:27 | Extra test cases mapped to statements in foreignkeys.html. (check-in: ffa6207d user: dan tags: trunk) | |
08:41 | Add further test cases to e_fkey.test. (check-in: d61cc0e1 user: dan tags: trunk) | |
2009-10-10
| ||
15:49 | Add tests to e_fkey.test. (check-in: 5ec07fee user: dan tags: trunk) | |
14:29 | Update requirement text for sqlite3_open_blob(). Update evidence comment in e_fkey.test to conform to the latest requirement phrasing. (check-in: 89c548ac user: drh tags: trunk) | |
2009-10-09
| ||
18:16 | Add test cases to e_fkey.test. (check-in: e391dfe7 user: dan tags: trunk) | |
2009-10-08
| ||
19:02 | Test a couple of the examples in foreignkeys.html. (check-in: a2fb7902 user: dan tags: trunk) | |
17:42 | Add test cases to test file "e_fkey.test". (check-in: 23e0f61a user: dan tags: trunk) | |
13:42 | Fix a problem in the legacy genfkey code to do with column names that require quoting. (check-in: 273ccbf1 user: dan tags: trunk) | |
11:57 | Add tests to test/e_fkey.test. (check-in: 533703d7 user: dan tags: trunk) | |
06:24 | Update triggerC.test to match the change to the way the trigger-recursion limit is handled. (check-in: 58069252 user: dan tags: trunk) | |
01:43 | Fix a segfault that can occur following an OOM fault while renaming a table holding foreign key constraints. (check-in: 33973814 user: drh tags: trunk) | |
2009-10-07
| ||
23:42 | Use memcpy() rather than structure assignment so that memcmp() can later be used for comparison. Ticket [8550ecca70] (check-in: 56f609da user: drh tags: trunk) | |
18:41 | Add some tests of statements in foreignkeys.html. (check-in: 83828679 user: dan tags: trunk) | |
16:04 | Add a missing OP_Close opcode to VDBE programs that check for FK constraint violations. (check-in: 5caa4a2b user: dan tags: trunk) | |
11:29 | Update the header comment for sqlite3_blob_open to note that it is not possible to write to a column that is indexed, part of a primary key or, if foreign key support is enabled, part of a foreign key. (check-in: 2fd487fd user: dan tags: trunk) | |
10:43 | Update header file comments describing the sqlite3_changes and sqlite3_total_changes functions to describe how changes made by foreign key actions are handled. (check-in: 4c342c02 user: dan tags: trunk) | |
2009-10-06
| ||
14:59 | Change tclsqlite.c to use the Tcl_NRxxx() APIs in Tcl versions 8.6 and later. (check-in: e9f72f1d user: dan tags: trunk) | |
2009-10-05
| ||
05:40 | Fix some errors in the guttman versions (disabled by default) of the algorithms in rtree.c. (check-in: 64bad00b user: dan tags: trunk) | |
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. (check-in: 3c24df38 user: dan tags: trunk) | |
2009-10-02
| ||
15:29 | Add one more authentication test to fkey2.test to cover an untested branch. (check-in: e4fa8be7 user: dan tags: trunk) | |
14:23 | When inserting a row into a child table, invoke the authorization callback to request permission to read the parent key columns. (check-in: 9842f2d5 user: dan tags: trunk) | |
06:35 | Add a test to check that the incrblob API cannot be used to write to an IPK column. Also a comment to explain why the incrblob code does not need to check if a column is part of a parent key before writing to it. (check-in: dca2a7f6 user: dan tags: trunk) | |
2009-10-01
| ||
17:13 | Add test cases to cover the branches added by the previous commit. (check-in: aaa005b6 user: dan tags: trunk) | |
16:09 | If an update does not modify any child or parent key columns, omit foreign key processing for the statement. (check-in: edff3500 user: dan tags: trunk) | |
04:35 | Add tests to check that FK support interacts with count-changes correctly. (check-in: 5b836615 user: dan tags: trunk) | |
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) | |
14:27 | Remove the ALWAYS() added by the previous check-in. It is not needed. (check-in: 36568963 user: drh tags: trunk) | |
13:48 | Comment enhancements. Add an ALWAYS macro in fkey.c to indicate a branch that is always taken. (check-in: d5b714cf user: drh 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) | |
00:09 | Make sure a transaction is available for rollback whenever a REDUCE conflict resolution occurs and there is the possibility to ABORT. Ticket [4a03edc4c8c] (check-in: f0c56fa9 user: drh tags: trunk) | |
2009-09-23
| ||
18:49 | More fkey tests. (check-in: 2d544bd5 user: shane tags: trunk) | |
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) | |
15:51 | Modify the ".dump" command on the CLI so that it always issues a PRAGMA foreign_keys=OFF at the top of the output. (check-in: 0755b9b6 user: drh tags: trunk) | |
14:45 | Change the version number to 3.6.19. Fix a couple of incorrect testcase() macros associated with the new IS and IS NOT operators in expr.c. (check-in: e3b73394 user: drh 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) | |
13:39 | Add test cases for the IS and IS NOT operator. (check-in: 101ed58c user: drh 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) | |
03:01 | Do not run ON UPDATE actions of a foreign key constraint unless at least one column value really does change. (check-in: 71ac8e28 user: drh tags: trunk) | |
02:29 | Generalize the IS and IS NOT operators so that their right-hand side can be an arbitrary expression and not simple the constant NULL. They work like = and <> except that NULL values compare equal to one another an unequal to everything else. (check-in: 98853f61 user: drh tags: trunk) | |
2009-09-22
| ||
20:08 | Factor the UMINUS and UPLUS tokens out of the parser so that the parser tables can go back to using 8-bit values instead of 16-bit values. (check-in: 3fc938c9 user: drh tags: trunk) | |
19:53 | The NO ACTION action really should be no-action and not RESTRICT. (check-in: 55b263fa user: drh tags: trunk) | |
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) | |
13:25 | Allow specific exclusion of localtime_s() usage on Windows. (check-in: 216bcda7 user: shane 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 | Fix compilation with both OMIT_UTF16 and ENABLE_STAT2 defined. Ticket [56928bd084]. (check-in: cd850d49 user: dan tags: trunk) | |
16:06 | Fix compilation with OMIT_TRIGGER defined. Ticket [1ff6d29030]. (check-in: fb6ceed3 user: dan tags: trunk) | |