SQLite

Timeline
Login

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

100 events occurring around 174477bca05d019e.

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)