SQLite

Timeline
Login

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

100 events occurring around 6fe6371175482d38.

2009-10-22
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: ab99faca6c user: shane tags: trunk)
17:30 Review ticket [72adc99de9]: shell mode insert doesn't output blobs as blobs plus 3 other changes (artifact: 4eac1d2339 user: shane)
17:30
Updated shell to output blobs in X'1234' form when in "insert" mode. Ticket [72adc99de9]. (check-in: a2ad9e6363 user: shane tags: trunk)
00:20
Add markings on test evidence for R-30323-21917. (check-in: e51af74c3a 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: 5354ace55f user: drh tags: trunk)
2009-10-21
14:33
Merge accidental fork back to trunk. (check-in: f63397ad6c 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: c8815fcd88 user: shane tags: trunk)
14:09 Fixed ticket [dc3a6e5b31]: Shell doesn't htmlify column headers plus 3 other changes (artifact: 7cdb6d1d87 user: shane)
13:53
Made detectSchemaProblem function and aSchemaTable array static. Ticket [6f8b0c5855]. (check-in: c6f22f3e38 user: shane tags: trunk)
13:50 Fixed ticket [6f8b0c5855]: Some minor genfkey fixups plus 3 other changes (artifact: 3466fb4d1d 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: 0441d28e84 user: drh tags: trunk)
04:39 New ticket [78e04e52ea] Assertion failure dropping table with zero length name. (artifact: 5cb1c29080 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: 8a8eeb0c5a user: shane tags: trunk)
03:56 Ticket [39c85e8a4e] FormatMessage incorrectly used (Windows VFS) status still Fixed with 2 other changes (artifact: 93778e6744 user: shane)
03:55 Ticket [89668ca167] shell can support .timer on Windows status still Fixed with 2 other changes (artifact: 6af2d6e125 user: shane)
03:55 Fixed ticket [43db771bb2]: Sqlite shell prints some error messages to stdout plus 4 other changes (artifact: 37488ae443 user: shane)
03:54 Edit [761396f8cb79be34|761396f8cb]: Edit check-in comment. Timestamp 2009-10-21 02:00:48. (artifact: 82e7acd80a user: shane)
03:53 Edit [83216fbe904425f5|83216fbe90]: Edit check-in comment. Timestamp 2009-10-21 03:42:58. (artifact: 32bc50da07 user: shane)
03:53 Edit [8a8eeb0c5af4bbea|8a8eeb0c5a]: Edit check-in comment. Timestamp 2009-10-21 03:56:55. (artifact: eacb8e8250 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: 83216fbe90 user: shane tags: trunk)
03:39 Fixed ticket [89668ca167]: shell can support .timer on Windows plus 3 other changes (artifact: e0b743a349 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: 761396f8cb user: shane tags: trunk)
01:59 Fixed ticket [39c85e8a4e]: FormatMessage incorrectly used (Windows VFS) plus 3 other changes (artifact: 4d0dea8d69 user: shane)
2009-10-20
18:18 Ticket [f80d443a3b] pragma cache size doesn report actual size (min is 10) status still Closed with 1 other change (artifact: f4adfa0f0b user: rogerb)
18:13 Ticket [8440a8e22f] LENGTH & QUOTE stop at first zero status still Closed with 1 other change (artifact: 0382b1a95f user: rogerb) ... 1 similar event omitted.
15:28 Fixed ticket [f9af981dd2]: sqlite3_shutdown documentation needs to mention danger plus 3 other changes (artifact: 9bae21eefb user: drh)
15:27
Clarify the use of sqlite3_shutdown(). Ticket [f9af981dd2a2]. Comment changes only - no changes to code. (check-in: b2aa48b52f user: drh tags: trunk)
15:06 Fixed ticket [d82e3f3721]: VACUUM corrupts database when MAIN and TEMP table names overlap. plus 5 other changes (artifact: b986bc7f1c 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: 0bbd8d72ec user: drh tags: trunk)
14:24 Fixed ticket [1751725cd6]: sqlite_close doc should qualify advice plus 3 other changes (artifact: 27fd260282 user: drh)
14:23
Remove all mention of sqlite3_next_stmt() from the documentation of sqlite3_close(). (check-in: f494ed38a8 user: drh tags: trunk)
14:15 Ticket [4d5c039d12] Truncated database not detected well status still Open with 2 other changes (artifact: a153956721 user: drh)
14:08
Update documentation on the sqlite3_prepare_v2() interface. No changes to code. (check-in: 3b00e769cd user: drh tags: trunk)
13:49 Closed ticket [f80d443a3b]: pragma cache size doesn report actual size (min is 10) plus 4 other changes (artifact: 426c6a9614 user: drh)
13:27 Closed ticket [8d510499cc]: Repreparation errors are always returned as SQLITE_SCHEMA plus 2 other changes (artifact: 0e10289d76 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: e6808c988c user: dan tags: trunk)
06:31 New ticket [f80d443a3b] pragma cache size doesn report actual size (min is 10). (artifact: 2f6d46c0c6 user: rogerb)
06:14 Ticket [de3ae967a0] Insert multiple rows at once status still Open with 3 other changes (artifact: c6b3d9ad73 user: rogerb) ... 1 similar event omitted.
05:58 New ticket [d214d7b114] FTS3 virtual table fails when names are quoted. (artifact: 105e07227b user: rogerb)
00:38 Ticket [8d510499cc] Repreparation errors are always returned as SQLITE_SCHEMA status still Open with 1 other change (artifact: 6763db5cfc 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: 3bcd78a1d7 user: drh tags: trunk)
21:05 Fixed ticket [b73fb0bd64]: Natural self-join defect plus 2 other changes (artifact: 39153355fb user: drh)
20:15
Fix an incorrect assert() in vdbeUnbind(). (check-in: 651c1efb99 user: drh tags: trunk)
19:47 Ticket [b73fb0bd64] Natural self-join defect status still Open with 3 other changes (artifact: 1a3635f577 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: 63bf73452d 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: 2c50b3d5aa 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: 6fe6371175 user: dan tags: trunk)
11:43 Deferred ticket [897b96d49d]: SQLITE_CANTOPEN when using journal_mode=persist and async IO plus 1 other change (artifact: 433a58d38a user: dan) ... 1 similar event omitted.
10:04 Closed ticket [94c04eaadb]: Crash in asyncRead() with large (>2GB) database file plus 2 other changes (artifact: 5332bbd487 user: dan)
07:50
Use 64-bit arithmetic in the xRead() method of asyncRead. Fix for [94c04eaadb]. (check-in: ca3e41b057 user: dan tags: trunk)
07:50 Changes to wiki page "Bug Reports" (artifact: e6be9a5f5a user: rogerb)
06:14 New ticket [39c85e8a4e] FormatMessage incorrectly used (Windows VFS). (artifact: 74e44cf7a7 user: rogerb)
05:48 New ticket [d82e3f3721] temporary tables stay in sqlite_sequence over a vacuum and close. (artifact: 1a8a9f5f5e user: rogerb)
05:31 Ticket [eb620916be] Shell doesn't print header if multiple statements on one line status still Open with 1 other change (artifact: 1c57be17df user: rogerb)
05:28 Ticket [8d510499cc] Repreparation errors are always returned as SQLITE_SCHEMA status still Open with 3 other changes (artifact: 22707dc0cf user: rogerb) ... 1 similar event omitted.
05:17 Ticket [c060923a54] VFS filename truncation issues status still Open with 3 other changes (artifact: c2f7e29ddf user: rogerb)
05:12 New ticket [f6ee7c1986] Negative widths should right justify. (artifact: 38ce681540 user: rogerb)
04:50 Changes to wiki page "Bug Reports" (artifact: a871380a68 user: rogerb)
2009-10-18
18:19 New ticket [b73fb0bd64] Natural self-join defect. (artifact: b9586609bb user: drh)
08:29 Ticket [4d5c039d12] Truncated database not detected well status still Open with 3 other changes (artifact: 9dcd9bbbdb user: rogerb)
2009-10-17
14:19
Fix a problem in the icu.test script. (check-in: 8a21fdaf6a 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: e74f8dc436 user: drh tags: trunk)
08:26
Add documentation comment for new experimental API sqlite3_reoptimize(). (check-in: c48f8ffedc user: dan tags: trunk)
2009-10-16
20:55 Fixed ticket [f777251dc7]: Assertion fault following ROLLBACK with running queries plus 3 other changes (artifact: d02149273e user: drh)
16:21
Merge the sqlite3_reoptimize() changes into the trunk. (check-in: 50136840d5 user: drh tags: trunk)
15:59
Fix a problem in the analyze3.test script. (Closed-Leaf check-in: 61174aea74 user: dan tags: experimental)
15:39 Edit [c304b44caebc0666|c304b44cae]: Mark "Closed". Edit check-in comment. Timestamp 2009-10-15 19:45:50. (artifact: fc8fc963a7 user: drh)
15:19
Remove a mutex reference leak from sqlite3_reoptimize(). (check-in: 9f09370661 user: dan tags: experimental)
15:05
Comment cleanup in btree.c. (check-in: 32966ba479 user: drh tags: trunk)
14:55
Experimental fix for [f777251dc7]. This may be changed yet. (check-in: 174477bca0 user: dan tags: trunk)
13:23
Fix comment typos in btreeInt.h. (check-in: 550566a75f user: drh tags: trunk)
11:10 Edit [f256bc0796ca8bd4|f256bc0796]: Change branch background color to "#f0ffc0". Mark "Closed". Edit check-in comment. Timestamp 2009-10-15 23:03:11. Add tag "experimental". (artifact: abb64a2678 user: drh)
2009-10-15
23:06 Edit [9bd6f3d8864d422f|9bd6f3d886]: Change branch background color to "#f0ffc0". Move to branch experimental. Timestamp 2009-10-15 18:35:39. (artifact: 14c4941e56 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: f256bc0796 user: drh tags: trunk, experimental)
21:01 New ticket [1751725cd6] sqlite_close doc should qualify advice. (artifact: fa644bfd72 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: c304b44cae user: drh tags: experimental)
18:35
Add the experimental sqlite3_reoptimize() API. (check-in: 9bd6f3d886 user: dan tags: experimental)
18:06 Ticket [f777251dc7] Assertion fault following ROLLBACK with running queries status still Open with 1 other change (artifact: c960b09e8f user: drh) ... 3 similar events omitted.
2009-10-14
14:33 Edit [1841aee6045b00cf|1841aee604]: Change background color to "#ffc0d0". Timestamp 2008-07-16 14:44:40. Add tag "release". (artifact: ced7ec4755 user: drh)
14:33 Edit [65ab777fd0a29ca9|65ab777fd0]: Change background color to "#ffc0d0". Timestamp 2008-08-06 10:50:00. Add tag "release". (artifact: 62cceefd2b user: drh)
14:32 Edit [88c51b9f1579707a|88c51b9f15]: Change background color to "#ffc0d0". Timestamp 2008-08-30 16:34:19. Add tag "release". (artifact: 8ed9874996 user: drh)
14:32 Edit [1634fd223d65a6ad|1634fd223d]: Change background color to "#ffc0d0". Timestamp 2008-09-22 10:44:32. Add tag "release". (artifact: 95075048da user: drh)
14:31 Edit [cd73cffab39d8039|cd73cffab3]: Change background color to "#ffc0d0". Timestamp 2008-10-15 11:59:24. Add tag "release". (artifact: 46a78f330a user: drh)
14:31 Edit [369f74983bb1b6a6|369f74983b]: Change background color to "#ffc0d0". Timestamp 2008-11-12 15:38:53. Add tag "release". (artifact: 94b1427261 user: drh)
14:30 Edit [01a6e2820af0729f|01a6e2820a]: Change background color to "#ffc0d0". Timestamp 2008-11-19 21:03:38. Add tag "release". (artifact: d93831bf82 user: drh)
14:30 Edit [f4f40370fb83d677|f4f40370fb]: Change background color to "#ffc0d0". Timestamp 2008-12-16 18:15:59. Add tag "release". (artifact: 1527f82301 user: drh)
14:29 Edit [8ca0b7c13620c8e2|8ca0b7c136]: Change background color to "#ffc0d0". Timestamp 2009-01-12 15:46:57. Add tag "release". (artifact: c8b64ca71c user: drh)
14:29 Edit [b6ce8199a9286eb2|b6ce8199a9]: Change background color to "#ffc0d0". Timestamp 2009-01-14 04:09:36. Add tag "release". (artifact: 413e43c7d0 user: drh)
13:53 Edit [21b720cc9b9f88b8|21b720cc9b]: Change background color to "#ffc0d0". Timestamp 2009-01-15 17:04:24. Add tag "release". (artifact: 6317841c91 user: drh)
13:52 Edit [6abd630c8703ed09|6abd630c87]: Change background color to "#ffc0d0". Timestamp 2009-02-18 00:00:04. Add tag "release". (artifact: 40bba6a70c user: drh)
13:51 Edit [0db862a23aa4aae9|0db862a23a]: Change background color to "#ffc0d0". Timestamp 2009-03-31 13:16:56. Add tag "release". (artifact: 4f5435a718 user: drh)
13:51 Edit [982cc7f4e7e2d8ab|982cc7f4e7]: Change background color to "#ffc0d0". Timestamp 2009-04-13 09:29:05. Add tag "release". (artifact: f5a889acab user: drh)