Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 descendants and 100 ancestors of [2c03b24f]
|
2011-12-07
| ||
| 01:55 | Cherrypick the [7e5b56b1c6] fix for the sqlite3SelectDup() routine into trunk. check-in: 7fc53509 user: drh tags: trunk | |
| 01:47 | Bug fix in sqlite3SelectDup(). Make sure the pNext pointer is valid. check-in: 7e5b56b1 user: drh tags: tree-explain | |
| 01:23 | Improvements to the data-structure explain subsystem. Most queries now give a reasonably detailed graph of their parse tree. check-in: 0aa7d3d2 user: drh tags: tree-explain | |
|
2011-12-06
| ||
| 19:44 | Begin adding the data-structure explaining subsystem. All is contained within check-in: 79ae51c5 user: drh tags: tree-explain | |
| 13:46 | Add file tkt-3a77c9714e.test, containing tests to verify that the problem documented by ticket [3a77c9714e] has been fixed. check-in: 162421da user: dan tags: trunk | |
| 13:24 | Do not reuse temp registers originally allocated to a subroutine within the main body of the program logic, since if the subroutine is called while the reused temp registers are in use, their values will get clobbered. Candidate fix for ticket [3a77c9714e63330] check-in: 092d5331 user: drh tags: trunk | |
| 00:47 | Merge the winGetLastError fixes into trunk. check-in: 5b03ba9d user: drh tags: trunk | |
|
2011-12-03
| ||
| 00:13 | Add the sqlite3_quota_fflush() interface. Enhance sqlite3_quota_remove() so that it can remove entire directories. check-in: abcb65af user: drh tags: quota-stdio | |
|
2011-12-02
| ||
| 15:31 | One minor documentation enhancement. check-in: 8cfd3575 user: drh tags: quota-stdio | |
| 15:27 | Documentation improvements and additional test cases. check-in: fa718960 user: drh tags: quota-stdio | |
|
2011-12-01
| ||
| 22:12 | Run quota-stdio tests in binary mode so that they work on windows. check-in: 71e4e97d user: drh tags: quota-stdio | |
| 22:07 | Progress toward getting things to work better on windows. check-in: 253dd707 user: drh tags: quota-stdio | |
| 20:48 | Add test logic and some test cases. check-in: a4730586 user: drh tags: quota-stdio | |
| 18:44 | Add stdio-like I/O interfaces to the test_quota VFS. This is a prototype change for discussion and is mostly untested. This is an alternative to adding stdio-like I/O interfaces in the core. There is no guarantee that this code will make it into the trunk. If it does get to trunk, there could be many changes to the interface first. check-in: bd3ce723 user: drh tags: quota-stdio | |
| 02:32 | Add a prototype implementation of stdio-like routines for accessing the VFS. This is intended as documentation. The code is untested. There is no guarantee that any of this will ever make it into trunk. Substantial revision is possible prior to reaching trunk, if it ever does. Closed-Leaf check-in: 8936542b user: drh tags: vfs-stdio | |
|
2011-11-29
| ||
| 15:40 | Remove unused fields from the Parse object. Documentation and formatting improvements on data structure definitions. check-in: 431556ca user: drh tags: trunk | |
| 15:04 | Remove unused boolean fields from the UnpackedRecord object. check-in: b10d091e user: drh tags: trunk | |
| 14:46 | Removed the unused "type" field from the CollSeq (collating sequence) object. check-in: ab89b047 user: drh tags: trunk | |
|
2011-11-25
| ||
| 21:51 | Update the version number to 3.7.10. check-in: ed0151ba user: drh tags: trunk | |
| 17:51 | Fix a typo in the documentation for sqlite3_stmt_busy(). check-in: 7812626d user: drh tags: trunk | |
| 17:21 | Add the sqlite3_stmt_busy() interface. check-in: 95cc4af6 user: drh tags: trunk | |
|
2011-11-21
| ||
| 00:54 | Cleanup the semantics surrounding use of the GetLastError function on Windows. Closed-Leaf check-in: 7e657bbb user: mistachkin tags: winGetLastError | |
|
2011-11-18
| ||
| 13:10 | Change the multiplexor to use a 3-digit suffix. check-in: 0b7edc44 user: drh tags: trunk | |
|
2011-11-17
| ||
| 11:49 | Improvements to the documentation of the sqlite3_db_filename() interface. check-in: 1c45b2a0 user: drh tags: trunk | |
| 11:43 | Restore the test for sqlite3OsFullPathname() failure that was mistakenly removed when [ceee03c79a] was backed out by [69ec53fc1c]. check-in: 4d3cf9e1 user: drh tags: trunk | |
| 00:56 | Add the sqlite3_db_filename() interface. check-in: 93a94798 user: drh tags: trunk | |
|
2011-11-16
| ||
| 23:29 | Back out the [ceee03c79a] change. check-in: 69ec53fc user: drh tags: trunk | |
| 19:29 | Add the sqlite3_db_release_memory() interface and the shrink_memory pragma. check-in: 3f58e7c8 user: drh tags: trunk | |
| 18:08 | Merge the PCACHE2 changes into trunk. check-in: 457513f2 user: drh tags: trunk | |
| 17:32 | Change the multiplexor suffix from 2 to 3 digits. Closed-Leaf check-in: 06e0cdaf user: drh tags: 3-digit-multiplex-suffix | |
| 16:23 | Remove code made obsolete by the changes to index processing that allow range search on the rowid. check-in: a5418c7f user: drh tags: trunk | |
| 15:41 | Fix an invalid assert() statement added by [3b58f5f066]. check-in: 888b09dd user: dan tags: trunk | |
| 15:27 | Where possible, take advantage of the rowid at the end of index records to optimize range constraints (<, >, <=, >=) on the rowid column. check-in: 3b58f5f0 user: dan tags: trunk | |
| 08:18 | Update memsubsys1.test to account for the recently increased size of the MemPage structure in btreeInt.h. check-in: 4fb3ca75 user: dan tags: trunk | |
|
2011-11-14
| ||
| 12:34 | Further work on mmap(). Still does not work right - autovacuum tests are the first to fail. Closed-Leaf check-in: 638a39bb user: drh tags: mmap-experimental | |
| 03:00 | Forward port the 8-byte alignment fix from branch-3.7.9. check-in: ebf6eb6e user: drh tags: trunk | |
| 02:53 | Fix a 8-byte alignment problem that causes a SIGBUS on Sparc. check-in: 54cc1198 user: drh tags: branch-3.7.9 | |
| 01:55 | Begin making experimental changes to use mmap() for reading content from a database. The code compiles, but crashes on the test suite. check-in: 09be42d5 user: drh tags: mmap-experimental | |
|
2011-11-13
| ||
| 21:44 | Add a version number to the sqlite3_pcache_methods2 object. Other PCACHE2 documentation improvements. Closed-Leaf check-in: 9f839ac0 user: drh tags: experimental-pcache | |
|
2011-11-12
| ||
| 23:10 | Attempt to modify btree.c so that it assumes that calls to sqlite3PagerWrite() will reallocate the page buffer. As there is not good way to test this assumption yet, probably a few spots were missed. check-in: ceee03c7 user: drh tags: experimental-pcache | |
| 16:46 | Remove a couple of incorrect assert statements so that the test suite will run with -DSQLITE_DEFAULT_CACHE_SIZE=0. check-in: 87614b62 user: drh tags: trunk | |
| 15:41 | Merge the windows xSyscall enhancements into trunk. check-in: c1fab9ac user: drh tags: trunk | |
| 03:17 | Make sure to flag benign malloc failures in the Windows VFS as such. Expand use of the DO_OS_MALLOC_TEST to cover the VFS functions that can now return an out of memory error. Support an experimental --match option to the test suite that will run only those tests matching the specified pattern. Closed-Leaf check-in: 76dec8aa user: mistachkin tags: winSyscall | |
|
2011-11-11
| ||
| 23:51 | Catch and report errors from sqlite3OsFullPathname(). check-in: 77119785 user: drh tags: trunk | |
| 23:31 | Remove use of malloc and free from the Windows VFS. Also, prevent sqlite3BtreeOpen from assuming that sqlite3OsFullPathname cannot fail. check-in: 8966ec17 user: mistachkin tags: winSyscall | |
| 22:08 | Work in progress to implement the 'syscall' functionality for Windows. check-in: ed88fb00 user: mistachkin tags: winSyscall | |
| 14:12 | Pull over all the latest changes from trunk. check-in: 1bbbf857 user: drh tags: experimental-pcache | |
| 00:27 | Make sure a corrupt index does not cause a buffer overread in sqlite3VdbeRecordCompare(). check-in: 471cf0d8 user: drh tags: trunk | |
|
2011-11-10
| ||
| 21:45 | Expand passing of a last error argument to the getLastErrorMsg function. Also, remove unused SQLITE_W32_THREADS define. check-in: 8f287979 user: mistachkin tags: trunk | |
| 20:21 | In winAccess, save the Win32 last error value prior to invoking user logging callback. Also, explicitly pass the Win32 last error value to winLogError in order to keep it accurate. Fixes a problem reported on the mailing list. check-in: 32ab3657 user: mistachkin tags: trunk | |
| 02:39 | Follow-on to the previous check-in to prevent a division by zero if the lookahead slot size is something goofy like 6 on a 32-bit machine. check-in: 6bda711f user: drh tags: experimental-pcache | |
| 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 | |
| 15:52 | Have FTS3 ignore ^ prefixes. The ^ syntax is only supported on FTS4 tables. Closed-Leaf check-in: df36ac94 user: dan tags: fts4-content | |
| 11:57 | Change the way ^ tokens work in FTS so that the filtering is done as part of reading the FTS index instead of waiting until an entire doclist has been retrieved and then filtering it. check-in: 9b58c59e user: dan tags: fts4-content | |
| 10:18 | Add tests for FTS ^ searches and matchinfo(). check-in: 92618c14 user: dan tags: fts4-content | |
| 09:40 | Fix a problem in FTS to do with ^ tokens and the snippet() function. check-in: 2c03b24f user: dan tags: fts4-content | |
|
2011-10-18
| ||
| 19:39 | If a token within an FTS query is prefixed with a '^' character, it must be the first token in a column of data to match. check-in: 63ac33c8 user: dan tags: fts4-content | |
| 12:49 | Cherrypick patch [3126754c72] from the trunk into the content= branch. check-in: f9b5b217 user: dan tags: fts4-content | |
|
2011-10-05
| ||
| 15:11 | Change FTS4 so that if both the content=xxx option and column names are specified, the virtual table assumes that the named columns correspond to columns of table xxx. check-in: 289ee431 user: dan tags: fts4-content | |
| 06:07 | Fix a problem with IO error handling in the rebuild-index code. check-in: c6ba81fc user: dan tags: fts4-content | |
|
2011-10-04
| ||
| 19:41 | Improve test coverage of fts3.c. check-in: 0f439944 user: dan tags: fts4-content | |
| 16:37 | Add tests to check that modifying the schema of an FTS content table does not cause a crash in the FTS module. Also disable the deferred token optimization for content=xxx FTS tables. check-in: be86c706 user: dan tags: fts4-content | |
| 11:22 | Add experimental 'content' option to FTS4. check-in: 1d27ea74 user: dan tags: fts4-content | |
|
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 | |
|
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 | |
|
2011-09-22
| ||
| 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: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 | |
|
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 | |
| 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: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: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 | |
| 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 | |
|
2011-08-25
| ||
| 20:18 | Reorder some of the branches in backup.c in order to make the code easier to test. check-in: 2c443d47 user: drh tags: trunk | |
| 19:28 | Replace an assert() that a condition may not occur in backup.c with code to handle that condition, which can occur. check-in: 472c74b3 user: dan tags: trunk | |
| 18:54 | Fix harmless compiler warnings in test code. No changes to the core. check-in: 16f83fec user: drh tags: trunk | |
| 18:01 | Disable external merge source when SQLITE_TEMP_STORE==3. Add documentation to the OP_OpenSorter opcode. check-in: 5a690486 user: drh tags: trunk | |
| 13:46 | Fix the SQLITE_DISABLE_DIRSYNC compile time option. check-in: 6deb3ea1 user: dan tags: trunk | |
| 04:09 | Add comments for the various debug levels. When debugging, disable optimizations. Prevent the win32lock tests from spinning forever. check-in: 40185923 user: mistachkin tags: winNativeHeap | |
| 03:38 | Fix an file separator character issue with test_quota.c that was causing it to fail on windows. check-in: ddb8d3e8 user: drh tags: trunk | |