SQLite

Timeline
Login

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

95 events for the month beginning 2009-10-01 by user drh

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
16:00 Ticket [aad47726] Generator of sqlite3UpperToLower[] and sqlite3CtypeMap[] for single lang status still Closed with 1 other change (artifact: 5503f0dd user: drh)
2009-10-27
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)
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)
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)
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)
2009-10-22
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)
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
13:48
Add evidence marks to parse.y. Fix a broken evidence link in e_fkey.tcl. (check-in: 0441d28e user: drh tags: trunk)
2009-10-20
15:31 Closed ticket [8440a8e2]: LENGTH & QUOTE stop at first zero plus 3 other changes (artifact: 350ec879 user: drh)
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)
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) ... 1 similar event omitted.
2009-10-17
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)
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:39 Edit [c304b44caebc0666|c304b44c]: Mark "Closed". Edit check-in comment. Timestamp 2009-10-15 19:45:50. (artifact: fc8fc963 user: drh)
15:05
Comment cleanup in btree.c. (check-in: 32966ba4 user: drh 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)
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: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)
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)
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)
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)
2009-10-10
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-08
11:54 Ticket [ebde3f66] Shared cache has different busy behaviour than non-shared status still Open with 3 other changes (artifact: 63736641 user: drh)
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)
Previous month ↓