Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
77 check-ins for the month beginning 2011-09-01
Following month ↑|
2011-09-30
| ||
| 12:01 | Disable the xfer optimization if "PRAGMA count_changes=1" is configured. Ticket [c48d99d690]. (check-in: 9ddfe1e413 user: dan tags: trunk) | |
|
2011-09-28
| ||
| 01:10 | In the shell, allow arbitrary table names on the ".import" command. Ticket [d1d84037b90a449]. (check-in: f4dd32d30e user: drh tags: trunk) | |
| 00:50 | Enhance the stat VFS to report out the total size of all pages used by a table, even if the ZIPVFS compression backend is in play. Update the sqlite3_analyzer logic to use these new outputs. (check-in: 19b8eaaf70 user: drh tags: trunk) | |
|
2011-09-27
| ||
| 13:40 | Changes to sqlite3_analyzer to try to avoid integer overflow problems when linking against older versions of TCL. (check-in: 8c846311a0 user: drh tags: trunk) | |
|
2011-09-26
| ||
| 19:32 | Changes to the analyzer script to make it work with zipvfs databases. (check-in: d82cffab6a user: dan tags: trunk) | |
|
2011-09-25
| ||
| 17:49 | If an open as read/write fails, do not try to reopen as read-only if in exclusive access mode. (check-in: 263c5fb280 user: drh tags: trunk) | |
| 17:47 | If an open as read/write fails, do not try to reopen as read-only if in exclusive access mode. (Closed-Leaf check-in: 4a153f0100 user: drh tags: stat3-trunk) | |
|
2011-09-24
| ||
| 09:54 | Fix misc3.test so that it works with OMIT_MERGE_SORT builds. (check-in: 87946c627f user: dan tags: trunk) | |
| 05:55 | Fix some test files so that they work with SQLITE_OMIT_WAL builds. (check-in: a38668dcff user: dan tags: trunk) | |
|
2011-09-23
| ||
| 18:58 | Add SQLITE_DBSTATUS_CACHE_HIT and _MISS to the ".stat" command in the shell. (check-in: d279e1a309 user: drh tags: trunk) | |
| 16:34 | Add the -DBUILD_sqlite option to the compiler when building testfixture.exe using the configure script. (check-in: 15a13b6c59 user: drh tags: trunk) | |
| 14:40 | Merge the latest trunk changes into the stat3-trunk branch. (check-in: 0beb88a92c user: drh tags: stat3-trunk) | |
| 13:59 | Testability enhancements. (check-in: be44928cf2 user: drh tags: stat3-trunk) | |
| 13:25 | Fix typos in the format description comment of analyze.c. (check-in: 74e27fad33 user: drh tags: stat3-trunk) | |
|
2011-09-22
| ||
| 20:52 | Remove the restriction on the number of entries per index in sqlite_stat3. (check-in: 374343c8ad user: drh tags: stat3-trunk) | |
| 18:46 | Fix an issue in ANALYZE when STAT3 is disabled but both sqlite_stat2 and sqlite_stat3 tables exist. Also add testability tweaks to the STAT3 code. (check-in: 3ca7e449e2 user: drh tags: stat3-trunk) | |
| 15:31 | Remove a redundant (and undefined) "forcedelete" command from corruptE.test. (check-in: 6d8d4e1694 user: dan tags: trunk) | |
| 14:56 | Remove the SQLITE_PAGECACHE_BLOCKALLOC compilation option. (check-in: 4eb4689834 user: dan tags: trunk) | |
| 14:41 | Add the SQLITE_DB_STATUS_CACHE_HIT and MISS options. For querying the number of cache hits and misses on a per-connection basis. (check-in: 5100b6e9dc user: dan tags: trunk) | |
| 03:13 | Merge the cache-stats enhancement into trunk. (Closed-Leaf check-in: 646db97188 user: drh tags: mistake) | |
| 00:56 | Update the version number to 3.7.9. (check-in: 14e28eb954 user: drh tags: trunk) | |
| 00:28 | Fix an uninitialized variable and a misuse of memcpy(). (check-in: ee110d5a4a user: drh tags: stat3-trunk) | |
| 00:06 | Integrate build changes for sqlite3_analyzer into the MSVC makefile. Also, more cleanup of build files, including sqlite3_analyzer, for all makefiles. (check-in: af1c571829 user: mistachkin tags: trunk) | |
|
2011-09-21
| ||
| 20:10 | Minor tweaks to the TCL code for sqlite3_analyzer. (check-in: 3a261f383f user: drh tags: trunk) | |
| 18:29 | Remove unnecessary dependencies from the sqlite3_analyzer targets in makefiles. (check-in: 0bd8fd352d user: drh tags: trunk) | |
| 17:04 | Fix the sqlite3_analyzer target in the configure-generated Makefile. (check-in: 256cdbdc81 user: drh tags: trunk) | |
| 16:43 | Change the way the sqlite3_analyzer executable is built. (check-in: 05e3cced8a user: dan tags: trunk) | |
| 00:09 | Pull in the latest changes from trunk. Update the STAT3 documentation. (check-in: 63fc3e4bea user: drh tags: stat3-trunk) | |
|
2011-09-20
| ||
| 15:53 | Add SQLITE_STMTSTATUS_CACHE_HIT/MISS and SQLITE_DB_STATUS_CACHE_HIT/MISS. For querying the number of pager cache hits and misses on a statement or connection basis. (Closed-Leaf check-in: 892723575c user: dan tags: cache-stats) | |
|
2011-09-19
| ||
| 20:56 | Minor comment change in the description of the different memory allocator options. No changes to code. (check-in: 36be31ff0a user: drh tags: trunk) | |
| 20:36 | Merge in all changes through the 3.7.8 release. (check-in: 9607600b6c user: drh tags: stat3-trunk) | |
| 20:32 | Merge in all trunk changes through the 3.7.8 release. (check-in: ade72b1874 user: drh tags: apple-osx) | |
| 20:28 | Merge in all trunk changes through the version 3.7.8 release. (check-in: 98619a23fd user: drh tags: sessions) | |
| 18:00 | Version 3.7.8 (check-in: 3e0da808d2 user: drh tags: trunk, release, version-3.7.8) | |
| 13:01 | Increase the default lookaside cache line size from 100 to 128 bytes. (check-in: db01946503 user: drh tags: trunk) | |
| 11:57 | Remove a stray merge-sort related change from pager.c and pager.h. (check-in: 69823ed163 user: dan tags: trunk) | |
|
2011-09-17
| ||
| 18:56 | Remove a couple of comments that were causing problems for the amalgamation generator script. (check-in: ffed86bf96 user: drh tags: apple-osx) | |
| 17:29 | Add a new script to build an amalgamation that omits FTS3/4 and RTREE. (check-in: b31a7d7db9 user: drh tags: trunk) | |
| 15:34 | Make sure the file structure is zeroed prior to calling the VFS to open a file. (check-in: 29c4d0dd43 user: mistachkin tags: trunk) | |
|
2011-09-16
| ||
| 22:10 | Fix a problem with SQLITE_OMIT_TRACE that was introduced by the recent OP_Once change. (check-in: 96be3f7b59 user: drh tags: trunk) | |
| 20:43 | Fix #if's in winSync to avoid compiler warnings about unused local variables. Also, update version numbers in the MSVC makefile. (check-in: 2e66e41457 user: mistachkin tags: trunk) | |
| 20:16 | Silence harmless compiler warning about redefinition of the _CRT_SECURE_NO_WARNINGS macro by shell.c. (check-in: 690220717f user: mistachkin tags: trunk) | |
| 19:40 | Merge the latest trunk changes into the sessions branch. (check-in: 5efb02949d user: drh tags: sessions) | |
| 19:36 | Merge the latest trunk fixes into the apple-osx branch. (check-in: 070bf203bb user: drh tags: apple-osx) | |
| 19:29 | Merge all the latest trunk changes into the experimental STAT3 branch. (check-in: 51908c8f2b user: drh tags: stat3-trunk) | |
| 19:04 | Remove unreachable branches from the previous change. Add additional test cases. (check-in: cf51ef8ab8 user: drh tags: trunk) | |
| 17:43 | When analyzing the right-hand side of IN operators to see if the IN operator can work with an index, be sure to decend into nested subqueries. Fix for ticket [1a1308d2538d7] (check-in: 0156f10e23 user: drh tags: trunk) | |
| 16:00 | Further streamlining of the subquery materializer. New test cases for ticket [002caede898a] (check-in: ff8b76b25b user: drh tags: trunk) | |
| 01:38 | Merge the [002caede898] fix into trunk. (check-in: 95708ae223 user: drh tags: trunk) | |
| 01:34 | Add the new OP_Once opcode. Use it to clean up and simplify various one-time initialization sections in the code, including the fix for ticket [002caede898ae]. (Closed-Leaf check-in: 7f00552b73 user: drh tags: tkt-002caede898) | |
|
2011-09-15
| ||
| 23:58 | Materialize subqueries using a subroutine and invoke that subroutine prior to each use of the materialization. Fix for ticket [002caede898aee4] (check-in: 4b8357ee3c user: drh tags: tkt-002caede898) | |
| 19:39 | Adding test case for ticket [002caede898] (check-in: 62dfc51a49 user: drh tags: tkt-002caede898) | |
| 00:40 | Cleanup/fix error handling when no arguments are supplied to the SQLite analyzer. (check-in: 3fc566ac5d user: mistachkin tags: trunk) | |
|
2011-09-14
| ||
| 19:41 | Merge latest changes from the trunk into the sessions branch. (check-in: c00e45ede7 user: dan tags: sessions) | |
| 19:05 | Merge in the latest changes from trunk. (check-in: 2456b4d0d2 user: drh tags: apple-osx) | |
| 18:19 | Remove 'const' from a variable that might actually be written when an OOM error occurs. Also, fix a couple MSVC/Win32 compiler warnings. (check-in: 3035dc1c73 user: mistachkin tags: trunk) | |
| 13:41 | Remove unused parameters from internal routines in vdbesort.c. This is an additional simplification made possible by recent optimizations. (check-in: a1f3aeeb09 user: drh tags: trunk) | |
| 13:23 | Remove code from vdbesort.c that was made unreachable by the recent sqlite3VdbeRecordUnpack() optimizations. (check-in: 607aba6cd7 user: drh tags: trunk) | |
|
2011-09-13
| ||
| 19:09 | Merge the latest trunk changes into the stat3-trunk branch. (check-in: 11ca4ed8bf user: drh tags: stat3-trunk) | |
| 19:08 | Allocate the correct size for the output buffer in fts3DoclistOrMerge(). Fix for [56be976859]. (check-in: 07788c0f7f user: dan tags: trunk) | |
|
2011-09-11
| ||
| 10:14 | Cleanup pdb/ilk files generated by the MSVC makefile. (check-in: a9db247b75 user: mistachkin tags: trunk) | |
|
2011-09-05
| ||
| 20:16 | Fix a minor performance regression in btreeMoveto(). (check-in: d0712dfb24 user: dan tags: trunk) | |
| 14:20 | Refactor the sqlite3VdbeRecordUnpack() interface to better accommodate the vdbesort.c module. (check-in: f115b23035 user: dan tags: trunk) | |
|
2011-09-04
| ||
| 01:27 | Fix a compiler warning about an unused parameter in the merge-sort code. (check-in: 6b657ae750 user: drh tags: trunk) | |
| 01:11 | Improve the testability of the merge-sort logic. (check-in: b5179baf87 user: drh tags: trunk) | |
|
2011-09-03
| ||
| 17:07 | Performance improvements to the external merge-sorter. Keep content on an in-memory linked lists rather than an ephemeral table prior to spilling to disk. Use the external merge-sorter to implement ORDER BY and GROUP BY in addition to CREATE INDEX. (check-in: 4c43e8b2d2 user: drh tags: trunk) | |
| 16:42 | Simplification and performance tweaks in vdbeSorterMerge(). (Closed-Leaf check-in: 99e34bdce4 user: drh tags: merge-sort) | |
| 14:36 | Reduce the number of VdbeRecordUnpack() calls made in vdbesort.c. (check-in: 666c2c3cff user: dan tags: merge-sort) | |
| 00:17 | The build works again with -DSQLITE_OMIT_MERGE_SORT. The merge-sorter now avoids spilling to disk (letting the in-memory linked list grow without bound) if PRAGMA temp_store=3. (check-in: 68e26c4487 user: drh tags: merge-sort) | |
|
2011-09-02
| ||
| 21:42 | Remove some dead code. Fix a faulty assert(). Improve some variable names. (check-in: a9a64592cf user: drh tags: merge-sort) | |
| 18:03 | Combine two malloc calls in vdbesort.c. (check-in: cf48ad8353 user: dan tags: merge-sort) | |
| 15:41 | Reduce the number of malloc() calls made when creating an index on more than 2 columns. (check-in: 065b0c9858 user: dan tags: merge-sort) | |
| 15:08 | Remove unused local variable. (check-in: 61bda876af user: mistachkin tags: trunk) | |
| 11:45 | If all data being sorted fits in memory, avoid writing any data out to temporary files in vdbesort.c. (check-in: 71075673c6 user: dan tags: merge-sort) | |
| 10:31 | Instead of a temporary b-tree, use a linked-list and merge-sort to sort records in main memory in vdbesort.c. (check-in: 7769fb988d user: dan tags: merge-sort) | |
|
2011-09-01
| ||
| 16:01 | Use OP_SorterOpen instead of OP_OpenEphemeral to implement GROUP BY. (check-in: ebf819aaa5 user: drh tags: merge-sort) | |
| 15:32 | Experimental code-generator changes to utilize new opcodes for sorting. (check-in: bab2e560f6 user: drh tags: merge-sort) | |