/ Timeline
Login

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

100 ancestors of [2ab14a84]

2011-10-08
14:57
Add the SQLITE_DIRECT_OVERFLOW_READ compile time option. check-in: 2ab14a84 user: dan tags: trunk
2011-10-07
23:52
Change the ANALYZE command so that it no longer tried to delete unused sqlite_stat2 and sqlite_stat3 tables. Change the DROP TABLE command so that it is able to drop those tables. check-in: 589f3f56 user: drh tags: trunk
18:24
Make sure sqlite3_data_count() behaves as documented, even for EXPLAIN QUERY PLAN queries. check-in: d4f95b3b user: drh tags: trunk
17:52
Improved handling of OR terms in the WHERE clause with multi-column indexes. check-in: b23ae131 user: drh tags: trunk
17:45
Add testcase() macros to ensure good test coverage. Closed-Leaf check-in: 5c132592 user: drh tags: or-opt
16:57
Add the SQLITE_FCNTL_OVERWRITE file-control. Used by SQLite to indicate to the OS layer that the current transaction will overwrite the entire file. check-in: 1da87fcd user: dan tags: trunk
16:08
More test cases for the OR optimization. check-in: 4997d8b8 user: drh tags: or-opt
14:40
Prevent infinite recursion of in the query planner for some pathological test cases by disabling OR-clause processing upon first recursion. check-in: 9fca05ea user: drh tags: or-opt
13:33
Begin an effort to enhance the query planner to do a better job with OR terms in the WHERE clause. This change allows ANDs outside of the OR to be factored into the OR terms if that is helpful in finding better indices. check-in: 876bd21a user: drh tags: or-opt
12:59
Enhance the sqlite3_data_count() routine so that it can be used to determine if SQLITE_DONE has been seen on the prepared statement. check-in: 9913996e user: drh tags: trunk
2011-10-05
19:46
Add the --pageinfo and --stats options to the sqlite3_analyzer utility. check-in: baa80c7b user: drh tags: trunk
18:18
Update the sqlite3_analyzer utility program to provide more details about the compression performance of ZIPVFS database files. check-in: fa5ed532 user: drh tags: trunk
17:36
Fix test code related to reporting the size of overflow pages in zipvfs databases. check-in: ad7c9eed user: dan tags: trunk
15:26
When finding the appropriate file permissions for journal files with SQLITE_ENABLE_8_3_NAMES, ignore "-" characters in the name of the containing directory. check-in: 328cc186 user: drh tags: trunk
2011-10-03
15:30
Merge the STAT3 changes into trunk. check-in: 774d0842 user: drh tags: trunk
2011-10-02
05:23
Update MSVC makefile to allow targets to be built with support for ICU. check-in: eb5da5e1 user: mistachkin tags: trunk
2011-09-30
12:01
Disable the xfer optimization if "PRAGMA count_changes=1" is configured. Ticket [c48d99d690]. check-in: 9ddfe1e4 user: dan tags: trunk
2011-09-28
01:10
In the shell, allow arbitrary table names on the ".import" command. Ticket [d1d84037b90a449]. check-in: f4dd32d3 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: 19b8eaaf 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: 8c846311 user: drh tags: trunk
2011-09-26
19:32
Changes to the analyzer script to make it work with zipvfs databases. check-in: d82cffab 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: 263c5fb2 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: 4a153f01 user: drh tags: stat3-trunk
2011-09-24
09:54
Fix misc3.test so that it works with OMIT_MERGE_SORT builds. check-in: 87946c62 user: dan tags: trunk
05:55
Fix some test files so that they work with SQLITE_OMIT_WAL builds. check-in: a38668dc 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: d279e1a3 user: drh tags: trunk
16:34
Add the -DBUILD_sqlite option to the compiler when building testfixture.exe using the configure script. check-in: 15a13b6c user: drh tags: trunk
14:40
Merge the latest trunk changes into the stat3-trunk branch. check-in: 0beb88a9 user: drh tags: stat3-trunk
13:59
Testability enhancements. check-in: be44928c user: drh tags: stat3-trunk
13:25
Fix typos in the format description comment of analyze.c. check-in: 74e27fad 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: 374343c8 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: 3ca7e449 user: drh tags: stat3-trunk
15:31
Remove a redundant (and undefined) "forcedelete" command from corruptE.test. check-in: 6d8d4e16 user: dan tags: trunk
14:56
Remove the SQLITE_PAGECACHE_BLOCKALLOC compilation option. check-in: 4eb46898 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: 5100b6e9 user: dan tags: trunk
00:56
Update the version number to 3.7.9. check-in: 14e28eb9 user: drh tags: trunk
00:28
Fix an uninitialized variable and a misuse of memcpy(). check-in: ee110d5a 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: af1c5718 user: mistachkin tags: trunk
2011-09-21
20:10
Minor tweaks to the TCL code for sqlite3_analyzer. check-in: 3a261f38 user: drh tags: trunk
18:29
Remove unnecessary dependencies from the sqlite3_analyzer targets in makefiles. check-in: 0bd8fd35 user: drh tags: trunk
17:04
Fix the sqlite3_analyzer target in the configure-generated Makefile. check-in: 256cdbdc user: drh tags: trunk
16:43
Change the way the sqlite3_analyzer executable is built. check-in: 05e3cced user: dan tags: trunk
00:09
Pull in the latest changes from trunk. Update the STAT3 documentation. check-in: 63fc3e4b user: drh tags: stat3-trunk
2011-09-19
20:56
Minor comment change in the description of the different memory allocator options. No changes to code. check-in: 36be31ff user: drh tags: trunk
20:36
Merge in all changes through the 3.7.8 release. check-in: 9607600b user: drh tags: stat3-trunk
18:00
Version 3.7.8 check-in: 3e0da808 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: db019465 user: drh tags: trunk
11:57
Remove a stray merge-sort related change from pager.c and pager.h. check-in: 69823ed1 user: dan tags: trunk
2011-09-17
17:29
Add a new script to build an amalgamation that omits FTS3/4 and RTREE. check-in: b31a7d7d user: drh tags: trunk
15:34
Make sure the file structure is zeroed prior to calling the VFS to open a file. check-in: 29c4d0dd 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: 96be3f7b 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: 2e66e414 user: mistachkin tags: trunk
20:16
Silence harmless compiler warning about redefinition of the _CRT_SECURE_NO_WARNINGS macro by shell.c. check-in: 69022071 user: mistachkin tags: trunk
19:29
Merge all the latest trunk changes into the experimental STAT3 branch. check-in: 51908c8f user: drh tags: stat3-trunk
19:04
Remove unreachable branches from the previous change. Add additional test cases. check-in: cf51ef8a 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: 0156f10e user: drh tags: trunk
16:00
Further streamlining of the subquery materializer. New test cases for ticket [002caede898a] check-in: ff8b76b2 user: drh tags: trunk
01:38
Merge the [002caede898] fix into trunk. check-in: 95708ae2 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: 7f00552b 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: 4b8357ee user: drh tags: tkt-002caede898
19:39
Adding test case for ticket [002caede898] check-in: 62dfc51a user: drh tags: tkt-002caede898
00:40
Cleanup/fix error handling when no arguments are supplied to the SQLite analyzer. check-in: 3fc566ac user: mistachkin tags: trunk
2011-09-14
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: 3035dc1c 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: a1f3aeeb user: drh tags: trunk
13:23
Remove code from vdbesort.c that was made unreachable by the recent sqlite3VdbeRecordUnpack() optimizations. check-in: 607aba6c user: drh tags: trunk
2011-09-13
19:09
Merge the latest trunk changes into the stat3-trunk branch. check-in: 11ca4ed8 user: drh tags: stat3-trunk
19:08
Allocate the correct size for the output buffer in fts3DoclistOrMerge(). Fix for [56be976859]. check-in: 07788c0f user: dan tags: trunk
2011-09-11
10:14
Cleanup pdb/ilk files generated by the MSVC makefile. check-in: a9db247b user: mistachkin tags: trunk
2011-09-05
20:16
Fix a minor performance regression in btreeMoveto(). check-in: d0712dfb user: dan tags: trunk
14:20
Refactor the sqlite3VdbeRecordUnpack() interface to better accommodate the vdbesort.c module. check-in: f115b230 user: dan tags: trunk
2011-09-04
01:27
Fix a compiler warning about an unused parameter in the merge-sort code. check-in: 6b657ae7 user: drh tags: trunk
01:11
Improve the testability of the merge-sort logic. check-in: b5179baf 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: 4c43e8b2 user: drh tags: trunk
16:42
Simplification and performance tweaks in vdbeSorterMerge(). Closed-Leaf check-in: 99e34bdc user: drh tags: merge-sort
14:36
Reduce the number of VdbeRecordUnpack() calls made in vdbesort.c. check-in: 666c2c3c 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: 68e26c44 user: drh tags: merge-sort
2011-09-02
21:42
Remove some dead code. Fix a faulty assert(). Improve some variable names. check-in: a9a64592 user: drh tags: merge-sort
18:03
Combine two malloc calls in vdbesort.c. check-in: cf48ad83 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: 065b0c98 user: dan tags: merge-sort
15:08
Remove unused local variable. check-in: 61bda876 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: 71075673 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: 7769fb98 user: dan tags: merge-sort
2011-09-01
16:01
Use OP_SorterOpen instead of OP_OpenEphemeral to implement GROUP BY. check-in: ebf819aa user: drh tags: merge-sort
15:32
Experimental code-generator changes to utilize new opcodes for sorting. check-in: bab2e560 user: drh tags: merge-sort
2011-08-31
23:57
Avoid using uninitialized variables after failures in the merge sort code. check-in: 2869ed28 user: drh tags: trunk
21:01
Formerly, we enabled fdatasync() on linux only. But now we learn that fdatasync() is not supported on Android. So we disable fdatasync() on Linux too. It can be reenabled at compile-time for those who really need it. check-in: 70b5b309 user: drh tags: trunk
20:47
Add the SQLITE_MAX_SCHEMA_RETRY compile-time option to the set of options understood by "PRAGMA compile_options;" and by the "sqlite_compileoption_used()" function. check-in: 1b124af4 user: drh tags: trunk
19:40
The server1.test script should only run if mutexes are functional. Fix to the #ifdef change of check-in [9e6a4c1473]. check-in: 64898485 user: drh tags: trunk
18:35
Always include the unixShm.id field, even when not debugging. check-in: 07803476 user: drh tags: trunk
18:04
Only create the sqlite3OSTrace global variable if compiling with SQLITE_TEST. check-in: 9e6a4c14 user: drh tags: trunk
17:46
Backslash escaping is not working right in tostr.awk on the latest ubuntu. The easiest fix is to simply not use any backslashes in the spaceanal.tcl script. check-in: df550066 user: drh tags: trunk
13:27
Add checks to make sure cells in corrupt database files do not overflow a page when doing autovacuum. Problem detected by valgrind. check-in: d0b347b4 user: drh tags: trunk
2011-08-30
19:52
Enable the thread test logic to work with the SQLITE_HAS_CODEC compile-time option. check-in: 20ddfb47 user: drh tags: trunk
01:29
Change the build process so that it does not require the unix "sort" command. This avoids confusion between ms-sort and mingw-sort on windows systems. check-in: f1bd5bba user: drh tags: trunk
01:23
Make sure SQLITE_FCNTL_SIZE_HINT a no-op if the chunk size is not greater than zero. check-in: 88b763e8 user: mistachkin tags: trunk
00:58
Fix a total unimportant file descriptor leak in lemon. This is to silence warning messages. check-in: e95cf2c5 user: drh tags: trunk
00:53
Fix a buffer overrun in test logic. No impact on the core SQLite. check-in: 49cd60e3 user: drh tags: trunk
2011-08-29
18:24
Fix a broken assert() statement in select.c. check-in: ad78ef2b user: dan tags: trunk
11:56
Back out [05c9832e5f6eb] since it was causing a performance regression with no obvious benefit. check-in: 639cc85a user: drh tags: trunk
03:08
Merge performance enhancements into trunk. check-in: 5a00d24b user: drh tags: trunk
02:49
About a 1% overall performance improvement by using a macro to avoid no-op calls to sqlite3MemReleaseExternal(). Closed-Leaf check-in: ff71d20a user: drh tags: experimental