SQLite

Timeline
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

264 events for the month beginning 2009-10-01

Following month ↑
2009-10-30
14:27
Increase the version number to 3.6.20. (check-in: 61295274 user: drh tags: trunk)
14:05 Fixed ticket [6b00e0a3]: The great OP_If bug plus 3 other changes (artifact: a67b11ba user: drh) ... 1 similar event omitted.
13:27 Edit [2a832b19b657ba02|2a832b19]: Timestamp 2009-10-30 13:26:54. Add tag "release". (artifact: 9bac7e4d user: drh)
13:26
Version 3.6.16.1 (Leaf check-in: 2a832b19 user: drh tags: release, branch_3_6_16)
13:25
Avoid storing the result register for EXISTS and SELECT in any field of the Expr object - simply return the register number as the return value of the function that codes those expressions. (check-in: 7253f8fa user: drh tags: trunk)
2009-10-29
18:43 Edit [65a1f1334d92873e|65a1f133]: Change branch background color to "#fff0c0". Edit check-in comment. Timestamp 2009-10-29 18:38:22. (artifact: 865f94ad user: drh)
18:38
Fix a 16-bit integer overflow that might occur in statements that use both an EXISTS clause and IN operator with a RHS holding in excess of 32K entries. (check-in: 65a1f133 user: drh tags: branch_3_6_16)
13:48
Reduce the memory required by prepared statements that use the IN operator with a list on the right and an INTEGER PRIMARY KEY on the left. (check-in: e7984ad2 user: drh tags: trunk)
2009-10-28
18:23 Ticket [aad47726] Generator of sqlite3UpperToLower[] and sqlite3CtypeMap[] for single lang status still Closed with 1 other change (artifact: c9898866 user: rogerb) ... 2 similar events omitted.
2009-10-27
21:17 Ticket [c25aab7e] The ".import" command does not parse CSV correctly. status still Open with 1 other change (artifact: 6df67dd6 user: rogerb) ... 1 similar event omitted.
19:51 Ticket [293860ac] Allow triggers to reference other databases status still Open with 3 other changes (artifact: c0bba80e user: rogerb) ... 1 similar event omitted.
18:06
Minor updates and corrections to comments in btreeInt.h. No changes to code. (check-in: ad949fa1 user: drh tags: trunk)
2009-10-26
22:32
Remove additional obsolete code from the sqlite3_release_memory() logic. (check-in: 2eeb6ed8 user: drh tags: trunk)
22:08
Remove some obsolete code within #if 0 that was causing developer concern. (check-in: 1d64e945 user: drh tags: trunk)
08:30 Ticket [d82e3f37] VACUUM corrupts database when MAIN and TEMP table names overlap. status still Fixed with 1 other change (artifact: f9ff61b4 user: rogerb) ... 1 similar event omitted.
02:45 New ticket [0841d0f5] Exclusive transactions do not work if same database multiply attached. (artifact: ae886736 user: rogerb)
02:33 New ticket [65a1fd4b] Shell should call rl_readline_name. (artifact: a57a34fa user: rogerb)
02:15 New ticket [bcff482d] Explicit extended error code for deadlock with sqlite_busy. (artifact: 5b874c1a user: rogerb)
01:57 New ticket [5896edbe] List available SQL functions. (artifact: 03997a69 user: rogerb)
01:55 Ticket [24666532] Various dump issues status still Open with 1 other change (artifact: 1f7b39d0 user: rogerb) ... 1 similar event omitted.
2009-10-25
20:26 New ticket [c276ee2e] null should not be allowed in primary key. (artifact: fc4d7e2f user: rogerb)
2009-10-24
15:51
Fix a compiler warning that occurs when building the TCL interface. (check-in: fc36034b user: drh tags: trunk)
03:04
Another attempt at getting the pTail pointer computations correct for sqlite3_prepare16(). Ticket [3fe897352e]. (check-in: a96b4e8c user: drh tags: trunk)
02:06 Fixed ticket [2cb66577]: Diagnostic message is unintentionally printed in batch mode plus 3 other changes (artifact: f04adecb user: shane)
02:06
In shell, modified to not print informational messages during startup while in "batch mode". Ticket [2cb66577f6]. (check-in: e3898e25 user: shane tags: trunk)
02:00 Fixed ticket [6da68f69]: tables says you provide a like pattern but it adds % in code plus 3 other changes (artifact: ac365444 user: shane)
02:00
In shell, changed ".tables" command to not add '%' to specified pattern. This is consistent with other commands that take a LIKE pattern (.dump, .schema, .indices). Updated internal help to better describe LIKE pattern usage. Fixed a few more inconsistencies in error messages. Ticket [6da68f691b]. (check-in: 7201244e user: shane tags: trunk)
01:55
Check-in [19064d7cea] broke the pTail return on sqlite3_prepare16() when the SQL contained surrogates. This check-in restores correct function. Part of ticket [3fe897352e]. (check-in: 65b1e3a4 user: drh tags: trunk)
01:48 Ticket [3fe89735] Malformed UTF16 leads to a 2-byte buffer overread status still Fixed with 1 other change (artifact: 1b24ca61 user: shane)
01:40 Ticket [4c9223e3] Vacuum fails within transaction but also rolls it back status still Open with 3 other changes (artifact: cfe528a0 user: rogerb)
01:07 New ticket [0c80ff9f] Quickstart missing include of stdlib.h. (artifact: 5bacd2ef user: rogerb)
01:04 New ticket [f711d5a9] Windows DLL should have versioninfo resource. (artifact: 2105fd2b user: rogerb)
00:49 New ticket [54831703] H35230 & H35240 refer incorrectly to H35230 - should be H35220. (artifact: 0c363276 user: rogerb)
2009-10-23
18:16 Fixed ticket [3fe89735]: Malformed UTF16 leads to a 2-byte buffer overread plus 1 other change (artifact: dcecbfdd user: drh)
18:15
Make sure that UTF16 to UTF8 conversions to not read past the end of the UTF16 input buffer if the last two bytes of the UTF16 happen to be the first half of a surrogate pair. Ticket [3fe897352e] (check-in: 19064d7c user: drh tags: trunk)
17:23 Ticket [3fe89735] Malformed UTF16 leads to a 2-byte buffer overread status still Open with 3 other changes (artifact: 5db5602a user: drh) ... 1 similar event omitted.
12:22 Closed ticket [f80d443a]: pragma cache size doesn report actual size (min is 10) plus 1 other change (artifact: d6a5b1fe user: drh)
09:31 New ticket [4c9223e3] Vacuum fails within transaction but also rolls it back. (artifact: a63f8a14 user: rogerb)
08:36 New ticket [36769f69] termDataCmp in FTS3 should be __cdecl on Windows. (artifact: 091cb975 user: rogerb)
08:31 New ticket [61d35ac2] A way to tell if a journal should exist. (artifact: 7b540e42 user: rogerb)
02:11 Open ticket [f80d443a]: pragma cache size doesn report actual size (min is 10) plus 1 other change (artifact: 62f1778f user: shane)
01:27
In shell, ensure that do_meta_command() returns consistent error values. Adjusted the text of some error message to be more consistent. Ticket [beb2dd69ad]. (check-in: 1ebac9ed user: shane tags: trunk)
01:27 Fixed ticket [beb2dd69]: do_meta_command inconsistent return values plus 3 other changes (artifact: 9521cb1f user: shane)
00:37
In shell, modified "import" handling to ensure error code returned correctly on exit. Ticket [bd770b2c52]. (check-in: 009efad0 user: shane tags: trunk)
00:37 Fixed ticket [bd770b2c]: shell doesn't return error exit code on import errors plus 3 other changes (artifact: aeaae621 user: shane)
2009-10-22
21:27 Ticket [7b61b6c6] insert mode is incorrectly converting text to numbers status still Fixed with 1 other change (artifact: b8c779e7 user: shane)
21:27 Ticket [72adc99d] shell mode insert doesn't output blobs as blobs status still Fixed with 1 other change (artifact: b4739ea6 user: shane)
21:26 Fixed ticket [eb620916]: Shell doesn't print header if multiple statements on one line plus 3 other changes (artifact: 8b2e3b3d user: shane)
21:23
In shell, reworked .header and .echo handling. Updated shell_exec() to (really) handle multiple statements. Tickets [72adc99de9], [7b61b6c6ce], and [eb620916be]. (check-in: 790402c1 user: shane tags: trunk)
20:52
Merge the MD5 checksum logic into the TCL interface. This facilitates building a tclsh that contains both SQLite and MD5. The plan is to use this augmented tclsh to help build the documentation. (check-in: a024c0a8 user: drh tags: trunk)
20:50
Add some sample requirement implementation comments to where.c. (check-in: 9854ad00 user: drh tags: trunk)
19:38 Fixed ticket [7b61b6c6]: insert mode is incorrectly converting text to numbers plus 4 other changes (artifact: 91fba9fd user: shane)
19:37 Edit [ab99faca6ce57a5e|ab99faca]: Edit check-in comment. Timestamp 2009-10-22 18:12:59. (artifact: 7fd5f024 user: shane)
18:15 Fixed ticket [72adc99d]: shell mode insert doesn't output blobs as blobs (artifact: 9e482027 user: shane) ... 1 similar event omitted.
18:12
In shell, in shell_exec() logic, use type info if available when outputting in "insert" mode for other types in addition to blobs. Changed shell_exec() to use sqlite_prepare_v2(). Ticket [72adc99de9] and [7b61b6c6ce]. (check-in: ab99faca user: shane tags: trunk)
17:30 Review ticket [72adc99d]: shell mode insert doesn't output blobs as blobs plus 3 other changes (artifact: 4eac1d23 user: shane)
17:30
Updated shell to output blobs in X'1234' form when in "insert" mode. Ticket [72adc99de9]. (check-in: a2ad9e63 user: shane tags: trunk)
00:20
Add markings on test evidence for R-30323-21917. (check-in: e51af74c user: drh tags: trunk)
00:14
Mention the sqlite3_column_count() function on the same documentation page with all of the other sqlite3_column... interfaces. (check-in: 5354ace5 user: drh tags: trunk)
2009-10-21
14:33
Merge accidental fork back to trunk. (check-in: f63397ad user: shane tags: trunk)
14:11
Modified shell to call output_html_string() for header values in .mode html. Updated output_html_string() to support the 5 basic HTML entities (<,>,&,',"). Ticket [dc3a6e5b31]. (check-in: c8815fcd user: shane tags: trunk)
14:09 Fixed ticket [dc3a6e5b]: Shell doesn't htmlify column headers plus 3 other changes (artifact: 7cdb6d1d user: shane)
13:53
Made detectSchemaProblem function and aSchemaTable array static. Ticket [6f8b0c5855]. (check-in: c6f22f3e user: shane tags: trunk)
13:50 Fixed ticket [6f8b0c58]: Some minor genfkey fixups plus 3 other changes (artifact: 3466fb4d user: shane) ... 1 similar event omitted.
13:48
Add evidence marks to parse.y. Fix a broken evidence link in e_fkey.tcl. (check-in: 0441d28e user: drh tags: trunk)
04:39 New ticket [78e04e52] Assertion failure dropping table with zero length name. (artifact: 5cb1c290 user: rogerb)
03:56
For the shell, changed the output of the errors on lines 2910 and 2914 to goto stderr. I left the timer values going to stdout as all of the other interactive shell commands (startup banner, help, etc.) go to stdout and I felt this was more consistent. Ticket [43db771bb2]. (check-in: 8a8eeb0c user: shane tags: trunk)
03:56 Ticket [39c85e8a] FormatMessage incorrectly used (Windows VFS) status still Fixed with 2 other changes (artifact: 93778e67 user: shane)
03:55 Ticket [89668ca1] shell can support .timer on Windows status still Fixed with 2 other changes (artifact: 6af2d6e1 user: shane)
03:55 Fixed ticket [43db771b]: Sqlite shell prints some error messages to stdout plus 4 other changes (artifact: 37488ae4 user: shane)
03:54 Edit [761396f8cb79be34|761396f8]: Edit check-in comment. Timestamp 2009-10-21 02:00:48. (artifact: 82e7acd8 user: shane)
03:53 Edit [83216fbe904425f5|83216fbe]: Edit check-in comment. Timestamp 2009-10-21 03:42:58. (artifact: 32bc50da user: shane)
03:53 Edit [8a8eeb0c5af4bbea|8a8eeb0c]: Edit check-in comment. Timestamp 2009-10-21 03:56:55. (artifact: eacb8e82 user: shane)
03:42
For Windows version of shell, add support for .timer command using the GetProcessTimes() API if available (in the same way getrusage() is used on UNIX.) Ticket [89668ca167]. (check-in: 83216fbe user: shane tags: trunk)
03:39 Fixed ticket [89668ca1]: shell can support .timer on Windows plus 3 other changes (artifact: e0b743a3 user: shane)
02:00
For Windows VFS, modified xGetLastError() to call FormatMessage() with the FORMAT_MESSAGE_IGNORE_INSERTS option. Additionally updated to ensure strings are returned as UTF8. Ticket [39c85e8a4e]. (check-in: 761396f8 user: shane tags: trunk)
01:59 Fixed ticket [39c85e8a]: FormatMessage incorrectly used (Windows VFS) plus 3 other changes (artifact: 4d0dea8d user: shane)
2009-10-20
18:18 Ticket [f80d443a] pragma cache size doesn report actual size (min is 10) status still Closed with 1 other change (artifact: f4adfa0f user: rogerb)
18:13 Ticket [8440a8e2] LENGTH & QUOTE stop at first zero status still Closed with 1 other change (artifact: 0382b1a9 user: rogerb) ... 1 similar event omitted.
15:28 Fixed ticket [f9af981d]: sqlite3_shutdown documentation needs to mention danger plus 3 other changes (artifact: 9bae21ee user: drh)
15:27
Clarify the use of sqlite3_shutdown(). Ticket [f9af981dd2a2]. Comment changes only - no changes to code. (check-in: b2aa48b5 user: drh tags: trunk)
15:06 Fixed ticket [d82e3f37]: VACUUM corrupts database when MAIN and TEMP table names overlap. plus 5 other changes (artifact: b986bc7f user: drh)
15:01
Fix the VACUUM command so that when the MAIN and TEMP databases have identically named tables, content from the TEMP database does not accidently overwrite MAIN database content. Ticket [d82e3f3721296e905d7e8c9dee718f71a826b0eb]. Note that this bug could potentially lead to database corruption. (check-in: 0bbd8d72 user: drh tags: trunk)
14:24 Fixed ticket [1751725c]: sqlite_close doc should qualify advice plus 3 other changes (artifact: 27fd2602 user: drh)
14:23
Remove all mention of sqlite3_next_stmt() from the documentation of sqlite3_close(). (check-in: f494ed38 user: drh tags: trunk)
14:15 Ticket [4d5c039d] Truncated database not detected well status still Open with 2 other changes (artifact: a1539567 user: drh)
14:08
Update documentation on the sqlite3_prepare_v2() interface. No changes to code. (check-in: 3b00e769 user: drh tags: trunk)
13:49 Closed ticket [f80d443a]: pragma cache size doesn report actual size (min is 10) plus 4 other changes (artifact: 426c6a96 user: drh)
13:27 Closed ticket [8d510499]: Repreparation errors are always returned as SQLITE_SCHEMA plus 2 other changes (artifact: 0e10289d user: drh)
07:01
Fix cases where modifying bound variables using the clear_bindings() or transfer_bindings() APIs can invalidate a query plan. (check-in: e6808c98 user: dan tags: trunk)
06:31 New ticket [f80d443a] pragma cache size doesn report actual size (min is 10). (artifact: 2f6d46c0 user: rogerb)
06:14 Ticket [de3ae967] Insert multiple rows at once status still Open with 3 other changes (artifact: c6b3d9ad user: rogerb) ... 1 similar event omitted.
05:58 New ticket [d214d7b1] FTS3 virtual table fails when names are quoted. (artifact: 105e0722 user: rogerb)
00:38 Ticket [8d510499] Repreparation errors are always returned as SQLITE_SCHEMA status still Open with 1 other change (artifact: 6763db5c user: rogerb)
2009-10-19
22:41
Remove an unreachable condition in the WHERE clause processing of bound parameters and replace it with an assert(), for test coverage. (check-in: 3bcd78a1 user: drh tags: trunk)
21:05 Fixed ticket [b73fb0bd]: Natural self-join defect plus 2 other changes (artifact: 39153355 user: drh)
20:15
Fix an incorrect assert() in vdbeUnbind(). (check-in: 651c1efb user: drh tags: trunk)
19:47 Ticket [b73fb0bd] Natural self-join defect status still Open with 3 other changes (artifact: 1a3635f5 user: drh)
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)
11:43 Deferred ticket [897b96d4]: SQLITE_CANTOPEN when using journal_mode=persist and async IO plus 1 other change (artifact: 433a58d3 user: dan) ... 1 similar event omitted.
10:04 Closed ticket [94c04eaa]: Crash in asyncRead() with large (>2GB) database file plus 2 other changes (artifact: 5332bbd4 user: dan)
07:50
Use 64-bit arithmetic in the xRead() method of asyncRead. Fix for [94c04eaadb]. (check-in: ca3e41b0 user: dan tags: trunk)
07:50 Changes to wiki page "Bug Reports" (artifact: e6be9a5f user: rogerb)
06:14 New ticket [39c85e8a] FormatMessage incorrectly used (Windows VFS). (artifact: 74e44cf7 user: rogerb)
05:48 New ticket [d82e3f37] temporary tables stay in sqlite_sequence over a vacuum and close. (artifact: 1a8a9f5f user: rogerb)
05:31 Ticket [eb620916] Shell doesn't print header if multiple statements on one line status still Open with 1 other change (artifact: 1c57be17 user: rogerb)
05:28 Ticket [8d510499] Repreparation errors are always returned as SQLITE_SCHEMA status still Open with 3 other changes (artifact: 22707dc0 user: rogerb) ... 1 similar event omitted.
05:17 Ticket [c060923a] VFS filename truncation issues status still Open with 3 other changes (artifact: c2f7e29d user: rogerb)
05:12 New ticket [f6ee7c19] Negative widths should right justify. (artifact: 38ce6815 user: rogerb)
04:50 Changes to wiki page "Bug Reports" (artifact: a871380a user: rogerb)
2009-10-18
18:19 New ticket [b73fb0bd] Natural self-join defect. (artifact: b9586609 user: drh)
08:29 Ticket [4d5c039d] Truncated database not detected well status still Open with 3 other changes (artifact: 9dcd9bbb user: rogerb)
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
20:55 Fixed ticket [f777251d]: Assertion fault following ROLLBACK with running queries plus 3 other changes (artifact: d0214927 user: drh)
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:39 Edit [c304b44caebc0666|c304b44c]: Mark "Closed". Edit check-in comment. Timestamp 2009-10-15 19:45:50. (artifact: fc8fc963 user: drh)
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)
11:10 Edit [f256bc0796ca8bd4|f256bc07]: Change branch background color to "#f0ffc0". Mark "Closed". Edit check-in comment. Timestamp 2009-10-15 23:03:11. Add tag "experimental". (artifact: abb64a26 user: drh)
2009-10-15
23:06 Edit [9bd6f3d8864d422f|9bd6f3d8]: Change branch background color to "#f0ffc0". Move to branch experimental. Timestamp 2009-10-15 18:35:39. (artifact: 14c4941e user: drh)
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)
21:01 New ticket [1751725c] sqlite_close doc should qualify advice. (artifact: fa644bfd user: rogerb)
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)
18:06 Ticket [f777251d] Assertion fault following ROLLBACK with running queries status still Open with 1 other change (artifact: c960b09e user: drh) ... 3 similar events omitted.
2009-10-14
14:33 Edit [1841aee6045b00cf|1841aee6]: Change background color to "#ffc0d0". Timestamp 2008-07-16 14:44:40. Add tag "release". (artifact: ced7ec47 user: drh)
14:33 Edit [65ab777fd0a29ca9|65ab777f]: Change background color to "#ffc0d0". Timestamp 2008-08-06 10:50:00. Add tag "release". (artifact: 62cceefd user: drh)
14:32 Edit [88c51b9f1579707a|88c51b9f]: Change background color to "#ffc0d0". Timestamp 2008-08-30 16:34:19. Add tag "release". (artifact: 8ed98749 user: drh)
14:32 Edit [1634fd223d65a6ad|1634fd22]: Change background color to "#ffc0d0". Timestamp 2008-09-22 10:44:32. Add tag "release". (artifact: 95075048 user: drh)
14:31 Edit [cd73cffab39d8039|cd73cffa]: Change background color to "#ffc0d0". Timestamp 2008-10-15 11:59:24. Add tag "release". (artifact: 46a78f33 user: drh)
14:31 Edit [369f74983bb1b6a6|369f7498]: Change background color to "#ffc0d0". Timestamp 2008-11-12 15:38:53. Add tag "release". (artifact: 94b14272 user: drh)
14:30 Edit [01a6e2820af0729f|01a6e282]: Change background color to "#ffc0d0". Timestamp 2008-11-19 21:03:38. Add tag "release". (artifact: d93831bf user: drh)
14:30 Edit [f4f40370fb83d677|f4f40370]: Change background color to "#ffc0d0". Timestamp 2008-12-16 18:15:59. Add tag "release". (artifact: 1527f823 user: drh)
14:29 Edit [8ca0b7c13620c8e2|8ca0b7c1]: Change background color to "#ffc0d0". Timestamp 2009-01-12 15:46:57. Add tag "release". (artifact: c8b64ca7 user: drh)
14:29 Edit [b6ce8199a9286eb2|b6ce8199]: Change background color to "#ffc0d0". Timestamp 2009-01-14 04:09:36. Add tag "release". (artifact: 413e43c7 user: drh)
13:53 Edit [21b720cc9b9f88b8|21b720cc]: Change background color to "#ffc0d0". Timestamp 2009-01-15 17:04:24. Add tag "release". (artifact: 6317841c user: drh)
13:52 Edit [6abd630c8703ed09|6abd630c]: Change background color to "#ffc0d0". Timestamp 2009-02-18 00:00:04. Add tag "release". (artifact: 40bba6a7 user: drh)
13:51 Edit [0db862a23aa4aae9|0db862a2]: Change background color to "#ffc0d0". Timestamp 2009-03-31 13:16:56. Add tag "release". (artifact: 4f5435a7 user: drh)
13:51 Edit [982cc7f4e7e2d8ab|982cc7f4]: Change background color to "#ffc0d0". Timestamp 2009-04-13 09:29:05. Add tag "release". (artifact: f5a889ac user: drh)
13:50 Edit [469ad1ded35f5ff8|469ad1de]: Change background color to "#ffc0d0". Timestamp 2009-05-07 02:26:08. (artifact: 7c961759 user: drh)
13:50 Edit [469ad1ded35f5ff8|469ad1de]: Change background color to "#ffc0ff". Timestamp 2009-05-07 02:26:08. Add tag "release". (artifact: e9d0f4e5 user: drh)
13:48 Edit [aff34826aa4667d2|aff34826]: Change background color to "#ffc0d0". Timestamp 2009-06-15 03:28:58. Add tag "release". (artifact: c098b036 user: drh)
13:47 Edit [ff691a6b2a302fe7|ff691a6b]: Change background color to "#ffc0d0". Timestamp 2009-06-27 14:10:30. Add tag "release". (artifact: e310bc0b user: drh)
13:47 Edit [36650102285ef966|36650102]: Timestamp 2009-08-10 15:16:27. Add tag "release". (artifact: ab5e1bff user: drh)
13:45 Edit [b084828a771ec40b|b084828a]: Timestamp 2009-09-11 14:05:07. Add tag "release". (artifact: 847dedc6 user: drh)
13:43 Edit [c1d499afc50d54b3|c1d499af]: Change background color to "#ffc0d0". Edit check-in comment. Timestamp 2009-10-14 11:33:55. Add tag "release". (artifact: 51ce4d77 user: drh)
11:33
Version 3.6.19 (check-in: c1d499af user: drh tags: trunk, release)
11:15 Ticket [c25aab7e] The ".import" command does not parse CSV correctly. status still Open with 1 other change (artifact: 7466c100 user: anonymous)
2009-10-13
22:47
Update the configure script for version 3.6.19. (check-in: ac19dbc6 user: drh tags: trunk)
19:19 Edit [e0aa50c382a56bb0|e0aa50c3]: Timestamp 2009-10-13 19:19:24. Change user to "shane". (artifact: c66cf6d2 user: drh)
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:44 Fixed ticket [5ee23731]: assert() failure (or invalid error code) caused by opening statement transaction on read-only database with active read statements plus 3 other changes (artifact: b7a954b4 user: drh)
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)
15:34 New ticket [5ee23731] assert() failure (or invalid error code) caused by opening statement transaction on read-only database with active read statements. (artifact: dee8fcc8 user: dan)
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)
21:22 New ticket [7b61b6c6] insert mode is incorrectly converting text to numbers. (artifact: 7ec8cb6e user: rogerb)
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)
04:26 New ticket [ee19e690] If shell is interrupted while dumping it still produces commit (and invalid dump). (artifact: c283c86d user: rogerb)
04:24 Ticket [ba7fdb56] Page size should auto default to file system block size status still Open with 3 other changes (artifact: 6fbe2d87 user: rogerb)
04:15 New ticket [ac55d88a] H10336 is no longer applicable. (artifact: fed2312b user: rogerb)
04:12 New ticket [4d5c039d] Truncated database not detected well. (artifact: d1730fa4 user: rogerb)
2009-10-11
07:36 Ticket [ee4b2b48] Prepared statement cache status still Open with 4 other changes (artifact: b9ba3cb6 user: rogerb) ... 1 similar event omitted.
06:21 New ticket [beb2dd69] do_meta_command inconsistent return values. (artifact: e428590b user: rogerb)
06:04 New ticket [08595ca4] INTERSECT operator should have higher precedence. (artifact: da23ad28 user: rogerb)
05:44 New ticket [ed2ff2f4] Call progress callback while doing pragma integrity_check. (artifact: 64e43de7 user: rogerb)
05:33 New ticket [2cb66577] Diagnostic message is unintentionally printed in batch mode. (artifact: a3219b56 user: rogerb)
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)
03:18 New ticket [c060923a] VFS filename truncation issues. (artifact: 2b6ea725 user: rogerb)
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)
11:54 Ticket [ebde3f66] Shared cache has different busy behaviour than non-shared status still Open with 3 other changes (artifact: 63736641 user: drh)
11:23 Ticket [23b21282] Uninformative error message on check constraint failure status still Open with 1 other change (artifact: 79a907ef user: anonymous)
08:15 New ticket [897b96d4] SQLITE_CANTOPEN when using journal_mode=persist and async IO. (artifact: ae7a158a user: dan)
06:59 Ticket [23b21282] Uninformative error message on check constraint failure status still Open with 3 other changes (artifact: 18b14039 user: rogerb)
06:46 New ticket [d8fe6cef] Error return from VFS xUnlock ignored. (artifact: af15aaed user: rogerb)
06:39 New ticket [23b21282] Meangingless error message on check constraint failure. (artifact: addfa3c6 user: rogerb)
06:26 New ticket [ebde3f66] Shared cache has different busy behaviour than non-shared. (artifact: 2a700451 user: rogerb)
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:43 Fixed ticket [8550ecca]: findLockInfo uses memcmp on non-zeroed, = assigned struct plus 3 other changes (artifact: 0eeaeb30 user: drh)
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)
22:34 New ticket [8550ecca] findLockInfo uses memcmp on non-zeroed, = assigned struct. (artifact: c15f59e3 user: aswift)
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)
13:55 New ticket [94c04eaa] Crash in asyncRead() with large (>2GB) database file. (artifact: 46c84add user: dan)
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
18:10 Ticket [c25aab7e] The ".import" command does not parse CSV correctly. status still Open with 2 other changes (artifact: 1a724b75 user: rogerb)
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
23:10 New ticket [f9af981d] sqlite3_shutdown documentation needs to mention danger. (artifact: 857d880d user: rogerb)
22:23 Ticket [24666532] Various dump issues status still Open with 3 other changes (artifact: 37405da9 user: rogerb) ... 1 similar event omitted.
18:18 Ticket [0322cd49] create_function_v2 that takes destructor status still Open with 3 other changes (artifact: fe12bfe1 user: rogerb)
18:05 New ticket [1c67bd6c] Shell Control-C (break) handling could be better. (artifact: 4896d7b3 user: rogerb)
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)
04:16 Ticket [6da68f69] tables says you provide a like pattern but it adds % in code status still Open with 3 other changes (artifact: af7ddd7d user: rogerb)
2009-10-04
23:37 New ticket [ba7fdb56] Page size should auto default to file system block size. (artifact: 1ddcd201 user: rogerb)
23:03 New ticket [0322cd49] create_function_v2 that takes destructor. (artifact: 1f590b75 user: rogerb)
22:55 Ticket [4776dee0] Documentation and code about registering functions status still Open with 2 other changes (artifact: 2ab6434e user: rogerb) ... 2 similar events omitted.
20:35 New ticket [89668ca1] shell can support .timer on Windows. (artifact: 66f863a4 user: rogerb)
2009-10-03
23:25 New ticket [1a1790ca] No way to signal an error in collation callback. (artifact: 0210d47e user: rogerb)
07:56 New ticket [6da68f69] tables says you provide a like pattern but it adds % in code. (artifact: 8d9b39b2 user: rogerb)
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)
04:05 New ticket [8f81455b] fts3GetVarint32 sets random number on error. (artifact: d84ee80c user: rogerb)
02:08 New ticket [bd770b2c] shell doesn't return error exit code on import errors. (artifact: 47ac7ead user: rogerb)
02:02 New ticket [2e047cbe] select DISTINCT performance could be better. (artifact: f967d12b user: rogerb)
2009-10-02
19:54 New ticket [f5cb008a] Shell silently ignores extra parameters. (artifact: f0d1a7a8 user: rogerb)
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)
07:27 Ticket [2fd50fa6] cygwin-1.7 issues: winFullPathname and tempname status still Open with 4 other changes (artifact: 07b92392 user: rogerb)
07:23 New ticket [43d2aa29] H13015 needs to be completed. (artifact: ac8d312a user: rogerb)
07:17 New ticket [3211d778] replace function works on blobs. (artifact: b3d4e9eb user: rogerb)
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)
Previous month ↓