Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 descendants and 100 ancestors of ad7c9eed8bbd607b
|
2011-11-10
| ||
| 02:24 | Use sqlite3MallocSize() to get the actual size of the memory allocation used for lookaside cache and increase the size of the cache to use the full allocation. check-in: 0e53ecad user: drh tags: experimental-pcache | |
|
2011-11-09
| ||
| 18:07 | Omit an unnecessary Sleep() call in windows pending-lock retry logic. Enhance the comment on that logic to discourage people from copying it into other VFSes. check-in: 0c951a97 user: drh tags: trunk | |
| 17:01 | When compiling with MSVC, use the _msize function. check-in: 797a1479 user: mistachkin tags: experimental-pcache | |
| 16:12 | Minor changes needed to restore full branch test coverage. check-in: bc10a753 user: drh tags: experimental-pcache | |
| 14:23 | A negative value N for the cache_size pragma adjusts the number of cache pages to use approximately N kibibytes of memory. check-in: b3faa680 user: drh tags: experimental-pcache | |
| 01:53 | For the mem1.c system malloc implementation, use the malloc_usable_size() function if the HAVE_MALLOC_USABLE_SIZE macro is defined. Update autoconf to look for that function when configuring. check-in: 2e8ab3ce user: drh tags: experimental-pcache | |
| 00:06 | Update the API documentation for the new pcache2 interface. Change the order of parameters on the xCreate method of pcache2. check-in: 4da70956 user: drh tags: experimental-pcache | |
|
2011-11-08
| ||
| 20:08 | Experimental change to the pcache interface to allow page buffers to be allocated separately from their associated container structures. check-in: c275c9d3 user: dan tags: experimental-pcache | |
| 15:06 | Cherrypick the [5dbfaed8c3] patch so that SQLITE_OMIT_WAL works again. Closed-Leaf check-in: a499ae38 user: drh tags: omit-wal-fix | |
|
2011-11-07
| ||
| 18:16 | Make the unix VFS tolerant of read() calls that return less than the requested number of bytes. check-in: a210695a user: drh tags: trunk | |
| 17:54 | Amplify the restriction on commit-hooks that they cannot recursively run SQL on the same database connection. check-in: 4fe5b731 user: drh tags: trunk | |
| 16:46 | Add a makefile target for tclsqlite3.c to Makefile.in. check-in: f521b6b7 user: drh tags: trunk | |
| 13:05 | Change the default file format from 1 to 4. This means that, unless PRAGMA legacy_file_format=ON is used first, new databases will not be readable by versions prior to 3.3.0 (2006-01-10). check-in: a35f52b1 user: drh tags: trunk | |
|
2011-11-06
| ||
| 05:06 | Move function sqlite3PagerClearCache() out of the "ifndef SQLITE_OMIT_WAL" block and into an "ifndef SQLITE_OMIT_VACUUM" block. check-in: 5dbfaed8 user: dan tags: trunk | |
|
2011-11-04
| ||
| 14:36 | Update the xfer optimization code so that the xfer optimization can be used with INTEGER PRIMARY KEY ON CONFLICT ... as long as the destination table is initially empty. Improvements to the comments on the xfer optimization. New test cases added. check-in: e3f368cd user: drh tags: trunk | |
| 12:05 | Change a memcpy() in sqlite3FileSuffix() to memmove() on the grounds that the source and destination may overlap. check-in: 5e1d247e user: dan tags: trunk | |
| 10:37 | Add a missing va_end() macro to fts3.c. check-in: e6f82574 user: dan tags: trunk | |
| 02:24 | Use mkdir() and rmdir() rather than open() and unlink() to create the lock files with the unix-dotlock VFS. The change is backwards compatible and, we are told, works better on some network filesystems. check-in: e2f08426 user: drh tags: trunk | |
| 00:35 | Enhance the shell so that the ".schema" command works with case insensitive LIKE patterns even with PRAGMA cache_sensitive_like=ON. check-in: b06bf3b3 user: drh tags: trunk | |
| 00:23 | Make sure the INSERT INTO ... SELECT statement works correctly even when the destination table contains an INTEGER PRIMARY KEY ON CONFLICT... column. Ticket [676bc02b87176125]. check-in: 6f9898db user: drh tags: trunk | |
|
2011-11-01
| ||
| 15:45 | If the read() system call in unix returns fewer bytes than expected, retry it until it either returns zero or an error. Closed-Leaf check-in: 72256634 user: drh tags: retry-short-reads | |
| 00:52 | Version 3.7.9 check-in: c7c6050e user: drh tags: trunk, release, version-3.7.9 | |
|
2011-10-31
| ||
| 19:59 | Fix a problem with sqlite3_backup_step() that resulted from a faulty merge. check-in: dacdec78 user: drh tags: apple-osx | |
| 19:34 | Fix the os_unix.c source file so that it will build as part of an amalgamation on non-apple platforms. check-in: b2f7639c user: drh tags: apple-osx | |
| 14:42 | Pull the latest trunk changes into the apple-osx branch. check-in: 4fa9ee79 user: drh tags: apple-osx | |
| 14:34 | Merge in all changes found in the version 3.7.9 release candidate. check-in: 23580718 user: drh tags: sessions | |
| 12:25 | Fix a typo in a comment. No code changes. check-in: 6635cd9a user: drh tags: trunk | |
| 11:36 | Add new file ext/fts3/README.content, describing the experimental FTS4 content option. check-in: 13a9d085 user: dan tags: trunk | |
| 06:52 | Update fts3fault.test to account for the sqlite3_errmsg() related changes in [8f88cc4e61] and [dcb7879347]. check-in: 3f2d49c6 user: dan tags: trunk | |
|
2011-10-29
| ||
| 19:25 | Update fkey_malloc.test to account for the sqlite3_errmsg() related changes in [8f88cc4e61] and [dcb7879347]. check-in: 5b82ec6f user: dan tags: trunk | |
| 15:29 | Add a test for [48f29963] that does not depend on FTS. check-in: fb15f545 user: dan tags: trunk | |
| 12:42 | Fix some code formatting in sqlite3Ext.h to avoid lines longer than 80 characters. check-in: 3ec20c30 user: drh tags: trunk | |
| 11:43 | Avoid attempting to call savepoint related methods on deleted sqlite3_vtab objects. Fix for [48f299634a]. check-in: 3565fcf8 user: dan tags: trunk | |
| 01:33 | Avoid reporting a NOMEM error if a memory allocation fails while copying the error message from a prepared statement into the database connection. check-in: dcb78793 user: drh tags: trunk | |
|
2011-10-27
| ||
| 15:19 | If an error occurs within sqlite3_step() on a statement prepared using sqlite3_prepare_v2(), transfer both the error code and error message to the database handle before sqlite3_step() returns (so that they are available via sqlite3_errcode() and sqlite3_errmsg(). Prior to this commit, only the error code was transfered. The error message was not available until after either sqlite3_reset() or sqlite3_finalize() had been called on the statement handle. check-in: 8f88cc4e user: dan tags: trunk | |
|
2011-10-22
| ||
| 21:00 | Avoid a harmless reference to an uninitialized variable following an error in FTS3. This is not a bug. The change is to silence a valgrind warning. check-in: d980c5b2 user: drh tags: trunk | |
|
2011-10-21
| ||
| 19:06 | Purge lingering references to SQLITE_STAT2 from the code and test scripts. check-in: aed2bf7a user: drh tags: trunk | |
| 17:18 | Merge the latest trunk changes into the apple-osx branch. check-in: be62ef05 user: drh tags: apple-osx | |
| 17:08 | Merge the latest trunk enhancements into the sessions branch. check-in: 8baef581 user: drh tags: sessions | |
| 16:47 | Remove stale requirements marks from the query planner. check-in: 76de9914 user: drh tags: trunk | |
| 14:27 | If an error occurs while writing to the database file during a VACUUM, discard the contents of the in-memory cache. This is required as if the database is a zipvfs database, the contents of the cache may be inconsistent with respect to the database as stored on disk. check-in: 07159e84 user: dan tags: trunk | |
|
2011-10-20
| ||
| 18:23 | Fix an issue with finding the access permissions of journal files when 8+3 filenames are in use. check-in: 2b35c514 user: drh tags: trunk | |
| 00:55 | Enhancements to the omittest.tcl script used to verify that the SQLITE_OMIT compile-time options are working. check-in: 4344483f user: drh tags: trunk | |
|
2011-10-19
| ||
| 18:21 | Fix harmless compiler warnings in FTS4. check-in: 1af4a256 user: drh tags: trunk | |
| 17:13 | Fix comments on SQLITE_CONFIG_HEAP so that they do not interfere with the requirements scanner. check-in: a3151ce1 user: drh tags: trunk | |
| 16:20 | Merge the fts4-content branch with the trunk. check-in: 8a407705 user: dan tags: trunk | |
|
2011-10-18
| ||
| 22:07 | Fix the virtual table rename logic so that it works even if the database encoding is something other than UTF8. Ticket [8290242b2a9a81683] check-in: d65f6353 user: drh tags: trunk | |
| 19:14 | Fix an uninitialized variable in OR-clause processing. check-in: 54aecd92 user: drh tags: trunk | |
| 18:10 | Improved handling of USING and NATURAL JOIN in 3-way and higher joins. Ticket [3338b3fa19ac4ab] check-in: 551ce407 user: drh tags: trunk | |
| 12:44 | Fix a floating-point exception that can occur when an FTS4 query contains a large number of tokens connected by AND or NEAR operators. check-in: 3126754c user: dan tags: trunk | |
|
2011-10-17
| ||
| 23:15 | Change the OP_JournalMode implementation so that it works even if a substitute sqlite3PagerFilename() that might return NULL is used. check-in: 491ff5fb user: drh tags: trunk | |
| 20:41 | Avoid 32-bit integer overflow when evaluating the exponent of a floating point value during ascii to binary conversion. check-in: 4becc47e user: drh tags: trunk | |
| 12:14 | Performance improvement for ascii to floating-point conversions with very large exponents. check-in: 59bb999c user: drh tags: trunk | |
|
2011-10-15
| ||
| 00:16 | Added the tool/warnings-clang.sh script. Changes so that there are no warnings with either gcc or clang even including FTS4 and RTREE and both with and without SQLITE_THREADSAFE=0. check-in: 39408702 user: drh tags: trunk | |
|
2011-10-14
| ||
| 22:57 | Fix a few minor and harmless clang warnings in FTS3 and RTREE. check-in: b3324f6c user: drh tags: trunk | |
| 21:49 | Add assert() statements and eliminate needless variable assignments in order to get the clang scan-build utility to report zero problems against the SQLite core. Clang's static analysis did find one real problem - but it was in the command-line shell, not in the SQLite core. check-in: 60fee957 user: drh tags: trunk | |
|
2011-10-13
| ||
| 18:08 | Change the makefile to delete both plain and ".exe" variants of build tools. Ticket [92bd6eaf04e117] check-in: 19536a38 user: drh tags: trunk | |
| 18:00 | Simplifications to the upper() and lower() SQL functions. Updates to documentation on sqlite3_bind_text() and sqlite3_result_text() to make it clear that users should not try to create strings with embedded NULs and that if they do the result of expression on those strings is undefined. Ticket [57c971fc74524a] check-in: 9984cc20 user: drh tags: trunk | |
| 17:16 | Handle updating the only row of an FTS table correctly. Fix for [9fd058691]. check-in: 7e24645b user: dan tags: trunk | |
| 17:09 | An improved fix for the page_count and quick_check problem previously patched at [150592b4b4d8637] check-in: c3cb7f4f user: drh tags: trunk | |
| 16:36 | Provide a complete prototype for isatty() in the command-line shell sources. check-in: 8bf13b03 user: drh tags: trunk | |
| 16:30 | Change the command-line shell to do the ".dump" inside of a SAVEPOINT rather than a transaction, since this allows it to be run from within a transaction. check-in: 6df7343b user: drh tags: trunk | |
| 16:02 | Enable large-file support for fopen() and friends in the command-line shell. Ticket [92af7da36b6fbd] check-in: eeeba4f0 user: drh tags: trunk | |
| 15:35 | Make sure the query optimizer for aggregate queries knows that expressions (x='a') and (x='A') are different. Ticket [fa7bf5ec94801e7e] check-in: e43da426 user: drh tags: trunk | |
| 14:41 | Make sure the page_count and quick_check pragmas work properly even when their names are capitalized. Fixes a problem reported on the mailing list. check-in: 150592b4 user: drh tags: trunk | |
| 14:18 | Adjust the symbols.sh script for STAT3. Add the symbols-mingw.sh script for testing on windows with MinGW. check-in: c41d1d46 user: drh tags: trunk | |
| 14:05 | Make sure all non-API functions in os_win.c have file scope. Ticket [35c54c874987] check-in: 17e4fde5 user: drh tags: trunk | |
| 13:34 | Do the ".dump" command inside of a transaction to prevent other processes from modifying the database while the dump is underway. Ticket [2466653295e65] check-in: 1c00d545 user: drh tags: trunk | |
| 01:01 | Fix a harmless compiler warning introduced into os_unix.c by one of the recent changes. check-in: 4bf4d5eb user: drh tags: trunk | |
| 00:41 | If errors are encountered while processing the ".dump" command in the command-line shell, print error messages as comments in the output and ROLLBACK at the end rather than committing. Ticket [ee19e690ec9a5a2] check-in: 8a8dcd6b user: drh tags: trunk | |
| 00:11 | Be sure to allocate plenty of space for error messages coming out of sqlite3_load_extension(), so that filenames and procedure names are not truncated. Ticket [7d32c69b50f89d] check-in: af8bcdd9 user: drh tags: trunk | |
|
2011-10-12
| ||
| 23:49 | The sqlite3_overload_function() interface returns an error if it is unable to create the overload function. Ticket [20f9d4fbbff3a3] check-in: d5b6b374 user: drh tags: trunk | |
| 23:13 | The date/time functions return NULL if the xCurrentTime or xCurrentTimeInt64 VFS methods fail. Ticket [0b803bff856c644c] check-in: c96651dd user: drh tags: trunk | |
| 19:04 | Suppress a compiler warning that occurs with SQLITE_OMIT_VIRTUALTABLE. check-in: 6bedb49d user: drh tags: trunk | |
| 18:52 | Clean up obsolete comments in printf.c. check-in: 97ef4f50 user: drh tags: trunk | |
| 17:00 | Clarify a comment and fix a code formatting issue in btree.c. check-in: 4f1a558d user: drh tags: trunk | |
|
2011-10-11
| ||
| 20:41 | Put in code to defend against signed/unsigned character problems in the command-line shell. check-in: b94a80a8 user: drh tags: trunk | |
| 20:14 | Add a couple of asserts trying to make the operation of sqlite3SelectNew() clearer. check-in: b21b1c7b user: drh tags: trunk | |
| 18:38 | Simplify the readonly_shm implementation so that it conforms to the implementation on trunk. Update the test cases to agree with the new behavior. check-in: 9efb74ce user: drh tags: apple-osx | |
| 18:18 | Change the behavior of the readonly_shm=1 query parameter so that it never attempts to open the -shm file read/write. check-in: f1364004 user: drh tags: trunk | |
| 17:54 | Remove all precision and width limits from formatting fields in the sqlite3_mprintf() family of functions. Malloc for space as necessary. The prevents a stack overflow on very large numbers using %f. check-in: 1f843fb3 user: drh tags: trunk | |
| 15:03 | Fix a locking error introduced when porting the new Apple locking code. check-in: cce1f521 user: drh tags: apple-osx | |
| 14:19 | Merge the latest trunk changes into the apple-osx branch. check-in: 7e2c4898 user: drh tags: apple-osx | |
| 12:58 | Merge all the latest trunk changes into the sessions branch - especially the SQLITE_ENABLE_STAT3 enhancements. check-in: 403431ca user: drh tags: sessions | |
| 12:39 | Fix requirements marks associate with STAT3. check-in: 9325c1a8 user: drh tags: trunk | |
|
2011-10-10
| ||
| 16:06 | Enhance sqlite3_analyzer so that it is able to deal with multiplexed databases that have 8+3 filenames. check-in: e5169f9a user: drh tags: trunk | |
| 12:04 | Fix a typo in a comment for PRAGMA journal_mode. Also amplify that same comment. check-in: c8ff2a48 user: drh tags: trunk | |
|
2011-10-08
| ||
| 21:39 | All the soft_heap_limit to be exceeded by 10% in test cases. check-in: 4be9dccc user: drh tags: trunk | |
| 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 | |
| 02:16 | Small performance improvement to OP_Column. check-in: b6b73a74 user: drh tags: experimental | |
|
2011-08-28
| ||
| 02:15 | About a 3% improvement in the performance of OP_Column. check-in: edff9d4a user: drh tags: experimental | |
| 00:19 | Correctly display P4_ADVANCE values on opcode traces. Mark an always-taken branch in OP_Column as such. check-in: 087dc960 user: drh tags: experimental | |
|
2011-08-27
| ||
| 18:48 | Experimental changes to improve the performance of OP_Next. check-in: 1a249845 user: dan tags: experimental | |
|
2011-08-26
| ||
| 20:55 | Fix several harmless compiler warnings and a documentation bug. check-in: 5454d0fe user: drh tags: trunk | |
| 13:16 | Merge the stat3-enhancement branch with trunk, but keep the resulting merge in a separate branch for now. check-in: 63f2c785 user: drh tags: stat3-trunk | |
| 11:25 | Update compiler error message regarding the choice of memory allocator defines. check-in: 1dada515 user: mistachkin tags: trunk | |
| 11:18 | Merge Win32 native heap support into trunk. check-in: 5238a749 user: mistachkin tags: trunk | |
| 05:40 | In the MSVC makefile, allow symbols to be enabled without NDEBUG defined. Also, for the win32lock test, make sure the database is closed prior to shutdown. Closed-Leaf check-in: 5ed7633d user: mistachkin tags: winNativeHeap | |
| 01:45 | Disable checking the winMemData structure signature when compiled with NDEBUG. check-in: 50edc2f9 user: mistachkin tags: winNativeHeap | |
| 01:32 | Allow the Win32 native heap flags to be overridden at compile-time. check-in: 1c2ecec8 user: mistachkin tags: winNativeHeap | |
| 00:34 | Create a new pager type, PAGER_SORTER, for use in the external merge sort. Such pagers are always held in memory but do report when they are under memory pressure by calling pagerStress. check-in: c71d7320 user: drh tags: trunk | |