Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 events occurring around 9fd54b0aa73ed74c.
|
2009-10-01
| ||
| 07:07 | • New ticket [8440a8e2] LENGTH & QUOTE stop at first zero. (artifact: 7a9cbc2f user: rogerb) | |
| 06:47 | • Ticket [19b44e35] sqlite3_bind_text inconsistent with NULL pointers, zero length etc status still Open with 3 other changes (artifact: 4fc1eaf9 user: rogerb) ... 1 similar event omitted. | |
| 06:31 | • New ticket [72adc99d] shell mode insert doesn't output blobs as blobs. (artifact: 7fb1b8cb user: rogerb) | |
| 04:35 | Add tests to check that FK support interacts with count-changes correctly. (check-in: 5b836615 user: dan tags: trunk) | |
| 02:05 | • Ticket [e063139e] Download .zip excludes shell but .tar includes it status still Open with 1 other change (artifact: 053b43a0 user: rogerb) | |
| 02:04 | • Ticket [f12a9eee] Shell command argument parsing is lax status still Open with 3 other changes (artifact: 8d0a5cd2 user: rogerb) | |
|
2009-09-30
| ||
| 16:07 | • Ticket [e123bd22] POSIX File handles aren't always immediately released on sqlite3_close status still Open with 3 other changes (artifact: 4a094ade user: drh) | |
| 09:01 | • Ticket [e063139e] Download .zip excludes shell but .tar includes it status still Open with 3 other changes (artifact: 4bd0b350 user: rogerb) ... 1 similar event omitted. | |
| 08:55 | • New ticket [e123bd22] POSIX File handles aren't always immediately released on sqlite3_close. (artifact: cad71b4d user: rogerb) | |
| 08:45 | • New ticket [35c54c87] Some os win symbols should be declared static. (artifact: e01d2e6b user: rogerb) | |
| 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
| ||
| 18:26 | • Closed ticket [668fe226]: pragma table_info doesn't accept database names plus 2 other changes (artifact: 8a03db8f user: rogerb) | |
| 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:58 | • Ticket [668fe226] pragma table_info doesn't accept database names status still Open with 3 other changes (artifact: dec53170 user: ralfjunker) | |
| 11:28 | Remove an unused variable from fkey.c. (check-in: 582bd768 user: dan tags: trunk) | |
| 09:25 | • New ticket [668fe226] pragma table_info doesn't accept database names. (artifact: bdb4713b user: rogerb) | |
| 07:35 | • New ticket [dc3a6e5b] Shell doesn't htmlify column headers. (artifact: faa7bbfe user: rogerb) | |
| 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) | |
| 04:17 | • Ticket [eb620916] Shell doesn't print header if multiple statements on one line status still Open with 3 other changes (artifact: cc4a5b28 user: rogerb) | |
| 03:58 | • New ticket [f12a9eee] Shell command argument parsing is lax. (artifact: a4c95c9f user: rogerb) | |
| 03:33 | • New ticket [eb620916] Shell doesn't print header if multiple statements on one line. (artifact: 6438035f user: rogerb) | |
|
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) | |
| 05:32 | • New ticket [7d32c69b] sqlite3LoadExtension truncates file names. (artifact: 5e9b7187 user: rogerb) | |
| 05:05 | • New ticket [0b803bff] Return (error code) of xCurrentTime is always ignored. (artifact: c4d1bfb5 user: rogerb) | |
| 05:02 | • New ticket [20f9d4fb] sqlite3_overload_function ignores errors. (artifact: e2015031 user: rogerb) | |
| 04:58 | • New ticket [62359d65] xGetLastError should be dumped. (artifact: 148039b2 user: rogerb) | |
| 04:49 | • New ticket [efeeb90f] error messages should be per-thread not global. (artifact: 0abb0211 user: rogerb) | |
|
2009-09-27
| ||
| 01:18 | • Changes to wiki page "Bug Reports" (artifact: 1f0f337b user: rogerb) | |
|
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) | |
| 15:14 | • Closed ticket [58a75d62]: encoding failure plus 3 other changes (artifact: 683a4293 user: drh) | |
| 14:40 | • Added wiki page "Bug Reports" (artifact: 8646127e user: drh) | |
| 14:20 | • Closed ticket [cff1a529]: sqlite3_get_table() returns wrong result when using where clause plus 3 other changes (artifact: 0d93ca47 user: drh) | |
| 13:57 | • Closed ticket [d77ffcd7]: Memory leak on failing INSERT statements on tables with UNIQUE INDEX plus 2 other changes (artifact: 10890730 user: drh) ... 2 similar events omitted. | |
| 10:28 | • New ticket [cff1a529] sqlite3_get_table() returns wrong result when using where clause. (artifact: 504f4a73 user: anonymous) | |
| 10:16 | • Ticket [d77ffcd7] Memory leak on failing INSERT statements on tables with UNIQUE INDEX status still Open with 1 other change (artifact: d8074b88 user: anonymous) ... 4 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) | |