Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 events occurring around 71ac8e28e55ff025.
2009-09-26
| ||
09:31 | • Ticket [d77ffcd7] Memory leak on failing INSERT statements on tables with UNIQUE INDEX status still Open with 1 other change (artifact: 1c0ad2ba user: anonymous) ... 3 similar events omitted. | |
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) | |
15:48 | • New ticket [58a75d62] encoding failure. (artifact: 4b0b5f55 user: anonymous) | |
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) | |
10:35 | • Closed ticket [860d129c]: builds with sqlite 3.6.18 depends on tchsh plus 2 other changes (artifact: 3e93f829 user: drh) ... 2 similar events omitted. | |
02:01 | • Closed ticket [f7e3d17a]: Memory accumulate without commit plus 5 other changes (artifact: 690b6b2c user: drh) ... 2 similar events omitted. | |
01:05 | • Ticket [3338b3fa] ambiguous column name when using multiple JOIN USING clauses and WHERE clause status still Open with 3 other changes (artifact: 1494b2de user: drh) ... 1 similar event omitted. | |
2009-09-24
| ||
18:42 | • Fixed ticket [4a03edc4]: Index corruption following aggressive use of ON CONFLICT clause. plus 3 other changes (artifact: cd3aa8c6 user: drh) | |
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) | |
16:48 | • Ticket [702bbe75] Invalid VDBE program built if ORDER BY used status still Open with 1 other change (artifact: c10814b9 user: anonymous) | |
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) | |
12:25 | • Closed ticket [c9394a56]: Sqlite reading all column data on selects. plus 4 other changes (artifact: 3378c847 user: drh) ... 1 similar event omitted. | |
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
| ||
19:16 | • New ticket [4a03edc4] Index corruption following aggressive use of ON CONFLICT clause.. (artifact: 360b4639 user: drh) | |
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:52 | • Ticket [702bbe75] Invalid VDBE program built if ORDER BY used status still Open with 1 other change (artifact: 54f202b4 user: drh) | |
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) | |
15:41 | • Ticket [702bbe75] Invalid VDBE program built if ORDER BY used status still Open with 1 other change (artifact: 58649bce user: anonymous) | |
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:42 | • Ticket [702bbe75] Invalid VDBE program built if ORDER BY used status still Open with 1 other change (artifact: ef1b5a65 user: drh) | |
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) | |
11:54 | • Ticket [f51d9501] memset warning with gcc 4.3.3 status still Closed with 1 other change (artifact: 9a6159ee user: drh) ... 1 similar event omitted. | |
11:22 | • Closed ticket [98f156c7]: plus 2 other changes (artifact: 586dfe12 user: drh) | |
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) | |
08:32 | • New ticket [f51d9501] memset warning with gcc 4.3.3. (artifact: ac551f6d user: anonymous) | |
07:39 | • New ticket [98f156c7] . (artifact: 98fde032 user: anonymous) | |
04:12 | • Ticket [702bbe75] Invalid VDBE program built if ORDER BY used status still Open with 1 other change (artifact: 8b058ffd user: anonymous) | |
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) | |
19:47 | • Ticket [702bbe75] Invalid VDBE program built if ORDER BY used status still Open with 1 other change (artifact: 6d6ea850 user: anonymous) | |
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) | |
15:03 | • Ticket [702bbe75] Invalid VDBE program built if ORDER BY used status still Open with 1 other change (artifact: 9cb27e4d user: drh) ... 1 similar event omitted. | |
13:32 | • Closed ticket [0bc616a2]: In wince 6.0, I can not compile sqlite. plus 4 other changes (artifact: 160f84c7 user: shane) | |
13:25 | Allow specific exclusion of localtime_s() usage on Windows. (check-in: 216bcda7 user: shane tags: trunk) | |
13:10 | • Ticket [702bbe75] Invalid VDBE program built if ORDER BY used status still Open with 3 other changes (artifact: 9c25e7f5 user: anonymous) ... 1 similar event omitted. | |
13:00 | • Closed ticket [a8b1e82b]: CAST failing for numeric plus 3 other changes (artifact: 6d7d0423 user: drh) ... 1 similar event omitted. | |
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) | |
13:18 | • Ticket [c472df6c] Segmentation fault by instead of insert triggers status still Closed with 1 other change (artifact: c0e263ac user: anonymous) ... 2 similar events omitted. | |
2009-09-20
| ||
08:02 | • Ticket [1ff6d290] Compile fails with SQLITE_OMIT_TRIGGER status still Open with 4 other changes (artifact: fbfe47f8 user: anonymous) | |
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) | |
14:06 | • Ticket [56928bd0] Cannot compile with SQLITE_OMIT_UTF16 and SQLITE_ENABLE_STAT2 status still Open with 1 other change (artifact: bae6a405 user: drh) | |
09:30 | • New ticket [aad47726] Generator of sqlite3UpperToLower[] and sqlite3CtypeMap[] for single lang. (artifact: 92cd2993 user: anonymous) | |
09:03 | • New ticket [0bc616a2] In wince 6.0, I can not compile sqlite.. (artifact: 40ad5afe user: anonymous) | |
07:25 | • Ticket [56928bd0] Cannot compile with SQLITE_OMIT_UTF16 and SQLITE_ENABLE_STAT2 status still Open with 3 other changes (artifact: b7035268 user: anonymous) | |
07:19 | • New ticket [6f8b0c58] Some minor genfkey fixups. (artifact: 0af7a330 user: anonymous) | |
2009-09-18
| ||
23:53 | • New ticket [56928bd0] Cannot compile with SQLITE_OMIT_UTF16 and SQLITE_ENABLE_STAT2. (artifact: 68e33d04 user: anonymous) | |
12:06 | • Ticket [15e11a2c] IfEmpty(a,b) : a function like IfNull(a,b) but for empty strings status still Open with 3 other changes (artifact: b75af9a3 user: anonymous) | |
2009-09-17
| ||
21:22 | • Ticket [f76cabeb] xBestIndex/xFilter slight interface improvement status still Closed with 1 other change (artifact: c7a39ecf user: anonymous) | |
21:01 | • Ticket [eaa105fe] (...) WHERE col IN (val1) not reflected in xBestIndex status still Open with 1 other change (artifact: 2074da8b user: anonymous) | |
18:55 | • New ticket [af3450b7] Recursive virtual tables. (artifact: 8b2bd18c user: anonymous) | |
12:50 | • New ticket [15e11a2c] IfEmpty(a,b) : a function like IfNull(a,b) but for empty strings. (artifact: 79ae2f13 user: anonymous) | |
12:41 | • New ticket [b803a45d] Feature Request: MATCHES(VAL1%, VAL2, %VALn%, ...). (artifact: dcae36aa user: anonymous) | |
11:09 | • Ticket [1ff6d290] Compile fails with SQLITE_OMIT_TRIGGER status still Open with 3 other changes (artifact: c18f7408 user: anonymous) ... 1 similar event omitted. | |
00:47 | • Fixed ticket [e25d9ea7]: Cascading delete trigger fails. plus 4 other changes (artifact: df2f80f3 user: drh) | |
00:41 | When coding a trigger, assume that the "oldmask" requires all columns until we know otherwise. That pessimistic assumption assures that all necessary parameters are available on a cascading delete trigger. Ticket [e25d9ea771f] (check-in: 03e464be user: drh tags: trunk) | |
2009-09-16
| ||
21:31 | • Ticket [e25d9ea7] recursive_triggers=1 failed to work for delete trigger status still Open with 3 other changes (artifact: 60ac7546 user: drh) ... 1 similar event omitted. | |
16:14 | • New ticket [f1c2a689] configure script ignores ``--with-tcl'' option when tclsh8.4 is installed.. (artifact: 1fd89115 user: anonymous) | |
12:10 | • Closed ticket [832b2f3e]: integrity_check error after backup restore plus 2 other changes (artifact: 8a05c5ea user: drh) | |
10:26 | • Ticket [08494146] Some minor asyncvfs issues status still Open with 3 other changes (artifact: 780b0f58 user: anonymous) | |
07:40 | • Ticket [832b2f3e] integrity_check error after backup restore status still Open with 1 other change (artifact: 29caa961 user: anonymous) | |