Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
579 check-ins using file test/savepoint.test version e575217b
|
2014-06-17
| ||
| 18:43 | Experimental changes to use GetFileInformationByHandle instead of GetFileSize in the Win32 VFS. (Closed-Leaf check-in: d22c8142 user: mistachkin tags: filesize-debug) | |
|
2014-04-24
| ||
| 13:20 | Add sqlite3_log() diagnostic messages for a specific type of corruption where the file size is reported to be too small relative to the size in the header. This branch is intended to help debug a specific problem reported from the wild and is not for general use. (check-in: 34155c40 user: drh tags: filesize-debug) | |
|
2012-12-06
| ||
| 20:27 | Cherrypick [79ef8e3c77] (Apply the same restrictions on constant refactoring to statements within a trigger program as top-level statements). (Leaf check-in: 34aafb74 user: dan tags: branch-3.7.9) | |
| 20:19 | Cherrypick [557c69055a3] and [0064bab7714] (OP_Once-related fixes for triggers). (check-in: 0d7b5d45 user: dan tags: branch-3.7.9) | |
|
2012-11-05
| ||
| 16:36 | Merge the omit-wal-fix branch into branch-3.7.9 where it belongs, and in so doing get branch-3.7.9 working with SQLITE_OMIT_WAL. (check-in: 03919517 user: drh tags: branch-3.7.9) | |
|
2012-10-25
| ||
| 17:21 | Use a constant string "BINARY" for the unspecified collating sequence. This is part of check-in [635e3a762dd] that is being back-ported. (check-in: 9078ea75 user: drh tags: branch-3.7.9) | |
|
2012-10-15
| ||
| 23:15 | Change the ICU tokenizer so that it does not attempt to call strlen(NULL). This is a cherry-pick of the fix in [04298f1ac42c40c] on 2012-03-31 first appearing in release 3.7.12. (check-in: 49ffbc11 user: drh tags: branch-3.7.9) | |
|
2012-10-05
| ||
| 19:10 | Add QNX-specific performance tweaks to the unix VFS. (check-in: b02849e7 user: drh tags: branch-3.7.9) | |
| 18:38 | Fix an accidental fork on branch-3.7.9. (check-in: cd9efeb3 user: drh tags: branch-3.7.9) | |
| 18:35 | Backport fixes to shared-cache mode, from the shared-cache-fix branch, to version 3.7.9 (check-in: ac81ae49 user: drh tags: branch-3.7.9) | |
|
2012-04-04
| ||
| 13:51 | Fix the multiplexor logging so that it works with SQLITE_ENABLE_8_3_NAMES. (Leaf check-in: 627eff32 user: drh tags: nx-devkit) | |
| 13:47 | In the multiplexor extension, improve the error logging when a chunk fails to open. (check-in: e6806f0d user: drh tags: nx-devkit) | |
|
2012-02-13
| ||
| 08:50 | Fix a typo in the type of the fchown() function in os_unix.c. (check-in: bfbfe05b user: dan tags: trunk) | |
|
2012-02-11
| ||
| 23:55 | Make fchown() an overrideable system call in os_unix.c. (check-in: 98efac96 user: drh tags: trunk) | |
| 22:19 | Cleanup some directories and files left by the MinGW build, even when using the MSVC Makefile. (check-in: 3ab89e25 user: mistachkin tags: trunk) | |
| 21:56 | Revise the preprocessor directives used to handle malloc.h and _msize, in order to detect and handle the MSVC special-case automatically. (check-in: 90e73dc3 user: mistachkin tags: trunk) | |
| 21:21 | Silence GCC compiler warnings about unused return value from fchown(). (check-in: b0225473 user: drh tags: trunk) | |
| 19:53 | Another attempt to fix warnings in the randomFunc() function. (check-in: 768df4e1 user: drh tags: trunk) | |
| 19:23 | When creating journal files (including -wal and -shm files) try to set the ownership to be the same as the original database. This will prevent root from locking out the original owner of the file. (check-in: 1254dffe user: drh tags: trunk) | |
| 18:51 | Remove a redundant test from the shared-memory logic in os_unix.c. (check-in: 31142ca7 user: drh tags: trunk) | |
|
2012-02-10
| ||
| 20:43 | Fix a warning coming from the Solaris Studio compiler. (check-in: 33294bbd user: drh tags: trunk) | |
| 18:18 | Pull the latest trunk changes into the apple-osx branch. (check-in: e2485986 user: drh tags: apple-osx) | |
| 17:54 | Pull all the latest trunk changes into the sessions branch. (check-in: 361fb66a user: drh tags: sessions) | |
| 17:38 | Disable the ability to have multiple values in the VALUES clause of an INSERT statement when SQLITE_OMIT_COMPOUND_SELECT is used. (check-in: 92131195 user: drh tags: trunk) | |
| 03:10 | Fix an important bug in the handling of EINTR in unixRead(). Never came up on x86 but crashes on sparc. (check-in: 1a16db0b user: drh tags: trunk) | |
| 01:25 | Fix a boundary case for the integer affinity routine for non-x86 processors. (check-in: bea05ddd user: drh tags: trunk) | |
|
2012-02-08
| ||
| 12:13 | Add an autoconf test for malloc.h and use the results of that test to conditionally #include the malloc.h header file. (check-in: 16a47112 user: drh tags: trunk) | |
|
2012-02-07
| ||
| 14:22 | Port the command-line shell enhancements including the new --cmd option to the nx-devkit branch. (check-in: 81ce52af user: drh tags: nx-devkit) | |
| 14:13 | Command-line shell enhancements: Reorganize the "usage" comment so that options are in alphabetical order. Add the new "--cmd" option. Allow either "--option" or "-option" for options. (check-in: 9497893b user: drh tags: trunk) | |
|
2012-02-02
| ||
| 21:02 | More structure packing for smaller objects and less memory usage. (check-in: f14e7f29 user: drh tags: trunk) | |
| 19:37 | Reduce the size of the MemPage object by about 32 bytes. Other structure size optimizations. (check-in: 21695c34 user: drh tags: trunk) | |
| 18:46 | When non-aggregate columns occur in an aggregate query with a single min() or max(), then the values of the non-aggregate columns are taken from one of the rows that was the min() or max(). (check-in: fa13edd3 user: drh tags: trunk) | |
| 18:42 | Fix a problem with NULL handling in aggregate min/max when returning values from the row containing the min or max. (Closed-Leaf check-in: f27c7b4f user: drh tags: output-minmax-row) | |
| 17:35 | For queries of the form "SELECT p, max(q) FROM t1", the value of column p returned is the one on the same row that holds the maximum value of q. (check-in: adb29232 user: drh tags: output-minmax-row) | |
| 15:50 | Data structure cleanup. Remove unused fields. Rearrange other files for tighter packing and reduced memory usage. (check-in: 0bc594e8 user: drh tags: trunk) | |
| 03:38 | Simplified array allocation in the IdList and AggInfo objects. (check-in: 25df2a74 user: drh tags: trunk) | |
| 03:11 | Fix a possible segfault after an OOM fault. This has been in the code for ages but only expressed itself following the previous check-in. (check-in: a3553b8a user: drh tags: trunk) | |
| 01:58 | Remove the nAlloc field from the ExprList object. (check-in: 5963de30 user: drh tags: trunk) | |
|
2012-02-01
| ||
| 19:03 | Very small performance enhancement and reduction in size of the sqlite3_stmt object. (check-in: a38d57a4 user: drh tags: trunk) | |
| 01:13 | Fix ALTER TABLE RENAME so that it correctly handles triggers that attach to the table using the name in a different case. Ticket [ae6794effd404]. (check-in: 0d78ebb8 user: drh tags: trunk) | |
|
2012-01-31
| ||
| 23:34 | Fix a compiler warning in FTS4. (check-in: b4cad1ce user: drh tags: trunk) | |
| 14:24 | Futher pedantic fixes to the sqlite3_uri_boolean() interface. (check-in: 77b3430d user: drh tags: trunk) | |
| 13:35 | Improvements to the documentation for sqlite3_uri_boolean(). (check-in: b0a16179 user: drh tags: trunk) | |
| 05:11 | Change a comment in test script backup.test. (check-in: 313546b4 user: dan tags: trunk) | |
|
2012-01-30
| ||
| 18:40 | Bring the documentation and implementation of sqlite3_uri_boolean() into closer agreement. Ticket [5f41597f7c9c] (check-in: 7b053d69 user: drh tags: trunk) | |
| 18:00 | Fix compiler warnings in the TCL test harness. (check-in: c4cd38a0 user: drh tags: trunk) | |
| 16:13 | Do not rely on the _WIN32_WINNT macro as vs2005 does not define it by default. Instead, always assume winNT unless the makefile explicitly sets SQLITE_OS_WINNT=0. (check-in: 4f0997c7 user: drh tags: nx-devkit) | |
| 16:02 | Do not rely on the _WIN32_WINNT macro as vs2005 does not define it by default. Instead, always assume winNT unless the makefile explicitly sets SQLITE_OS_WINNT=0. (check-in: 1ce4d21d user: drh tags: trunk) | |
|
2012-01-28
| ||
| 21:08 | Update the .dump command of the command-line shell so that it (1) avoids putting the semicolon of a DDL statement on the same line as a comment, (2) avoids long expression, even when dumping a table with many columns, and (3) avoids unnecessary quoting of the table name. This fixes tickets [c04a8b8a4f] and [232637c465]. Shell change only; no changes to the SQLite core. (check-in: e6eea8d5 user: drh tags: trunk) | |
| 19:44 | Remove a couple of unnecessary nonterminals from the grammar. (check-in: 2b2a7d8d user: drh tags: trunk) | |
| 19:41 | Add support for IF NOT EXISTS on CREATE VIRTUAL TABLE. (check-in: 230983e8 user: drh tags: trunk) | |
| 15:26 | Update the version number to 3.7.11 and rerun autoconf. (check-in: 6f9b265d user: drh tags: trunk) | |
| 15:22 | Add support for multiple rows of VALUES in an INSERT statement. (check-in: eb3b6a0c user: drh tags: trunk) | |
|
2012-01-25
| ||
| 22:08 | Cherrypick the FTS fix in [c05c3fd20d9] into the nx-devkit branch. Ticket [edb497982c]. (check-in: 2a7170f0 user: drh tags: nx-devkit) | |
| 20:43 | Only invalidate the schema when the OP_ParseSchema opcode fails, not on any general failure of a vdbe program. (check-in: 11f68d99 user: drh tags: trunk) | |
| 16:29 | Fix an FTS problem triggered by querying for an N character prefix using an N+1 character prefix index after rows have been deleted from the FTS table. Fix for [edb497982c]. (check-in: c05c3fd2 user: dan tags: trunk) | |
|
2012-01-24
| ||
| 10:08 | Changes to the async-io module so that the xFileControl method returns SQLITE_NOTFOUND when a file-control is not recognized and so that it adds the second nul-terminator byte to filenames passed to the xOpen method of the underlying VFS. (check-in: 7036886e user: dan tags: trunk) | |
|
2012-01-20
| ||
| 15:05 | Cherrypick the fix from [629108c8e5376f989] into the nx-devkit branch. (check-in: d7374568 user: drh tags: nx-devkit) | |
|
2012-01-19
| ||
| 16:57 | Make the use and function of SQLITE_DYNAMIC clearer. Add assert() statement to help ensure that SQLITE_DYNAMIC is not misused. (check-in: ab80f2c3 user: drh tags: trunk) | |
|
2012-01-18
| ||
| 18:22 | Avoid overriding the malloc_usable_size symbol using the C preprocessor as this might be confusing the build on some systems. (check-in: bbaec351 user: drh tags: trunk) | |
| 12:46 | Add the SQLITE_WITHOUT_MSIZE and SQLITE_WITHOUT_ZONEMALLOC macros in mem1.c to disable the use of _msize() on windows and the zone memory allocator on Apple products, respectively. (check-in: 238e35a4 user: drh tags: trunk) | |
| 01:14 | Remove a redundant assignment from the VM. (check-in: d0dabe2f user: drh tags: trunk) | |
| 01:09 | Fix typo in comment. (check-in: 199edb68 user: mistachkin tags: trunk) | |
|
2012-01-17
| ||
| 15:29 | Remove the undocumented PRAGMA omit_readlock hack. (check-in: 96900c47 user: drh tags: trunk) | |
|
2012-01-16
| ||
| 16:56 | Enhance the command-lin shell to interpret CSV files as described by the wikipedia article on CSV. (check-in: 93aa17d8 user: drh tags: trunk) | |
| 16:39 | Test the fts4 content and prefix options together. (check-in: de11cd5c user: dan tags: trunk) | |
| 13:28 | Version 3.7.10 (check-in: ebd01a8d user: drh tags: trunk, release, version-3.7.10) | |
| 13:00 | Rebuild the configure script using autoconf 2.68 since autoconf 2.65 (previously used) appears to build incorrect scripts for Mac. (check-in: 9da1cd0a user: drh tags: trunk) | |
| 12:33 | Support building with SQLITE_ENABLE_SESSION under MSVC. (check-in: 2845654d user: mistachkin tags: sessions) | |
|
2012-01-14
| ||
| 14:13 | Merge the latest trunk changes into the apple-osx branch. (check-in: 2cc414cd user: drh tags: apple-osx) | |
| 13:50 | Update sessions branch with latest changes from trunk. (check-in: 01c84fd3 user: dan tags: sessions) | |
| 03:34 | Make sure the EXTERN macro is properly defined when building targets that require it (e.g. on MinGW). (check-in: 88ad2f23 user: mistachkin tags: trunk) | |
| 00:42 | In the multiplexor routine that determines the size of an overflow file, return 0 and leave the error code unchanges if there were prior errors. This prevents some I/O errors from going unreported in nx-devkit tests. (check-in: 6da0821a user: drh tags: trunk) | |
|
2012-01-13
| ||
| 16:48 | Fix documentation typos. No changes to code. (check-in: 0b857613 user: drh tags: trunk) | |
| 16:16 | Add the -uri option to the usage comment that is printed by the "sqlite3" TCL command when an unknown command-line option is supplied. (check-in: 7987e285 user: drh tags: trunk) | |
| 15:50 | Update the documentation for the sqlite3_uri_*() routines to make it clear that there argument must be a database filename passed into xOpen(). No changes to code. (check-in: 08230a3a user: drh tags: trunk) | |
| 15:21 | Fix backup2.test so that it passes on OpenBSD (which produces a slightly different error message in one case). (check-in: 227cfe11 user: dan tags: trunk) | |
| 14:50 | Do not throw an error from within test_journal.c if a database file size is not an integer multiple of the page-size. (check-in: 3f4899a9 user: dan tags: trunk) | |
| 10:51 | Omit test file zerodamage.test from the inmemory_journal permutation. (check-in: 0c0051b1 user: dan tags: trunk) | |
| 10:04 | Fix test case issues related to errors in file-controls and the PSOW flag. (check-in: 5afbcd49 user: dan tags: trunk) | |
|
2012-01-12
| ||
| 16:41 | Fix issues in test cases so that they work with DEFAULT_AUTOVACUUM defined. And with a small default cache-size. (check-in: a298465c user: dan tags: trunk) | |
| 15:05 | Fix typos in a testcase() macro introduced by the previous commit. (check-in: 0467742f user: dan tags: trunk) | |
| 14:25 | Remove some assert() statements that can fail with corrupt databases. (check-in: 7654ae71 user: dan tags: trunk) | |
|
2012-01-11
| ||
| 16:16 | Remove code made unreachable by the enhancement of the previous check-in. (check-in: 9e31a275 user: drh tags: trunk) | |
| 15:47 | Make the pager less vulnerable to problems caused by shifting sector sizes when rolling back a hot journal. (check-in: 629108c8 user: drh tags: trunk) | |
| 11:20 | Fix the sqlite3_quota_file() function in test_quota.c so that it adds the second nul-terminator to all file names that will be passed to a VFS xOpen method. (check-in: 3013f9a6 user: dan tags: trunk) | |
| 01:01 | Prevent winOpenSharedMemory from masking the real return code from its call to winOpen. Also, add asserts to check the double-zero termination of database file names. (check-in: 93a65776 user: mistachkin tags: trunk) | |
| 00:38 | Make sure filenames handed to the VFS by the fake_big_file test procedure are double-zero terminated. (check-in: d0a86860 user: drh tags: trunk) | |
|
2012-01-10
| ||
| 23:18 | Only require double-zero terminators on database filenames, not any every files supplied to the xOpen method. This backs out [2544f233f1]. Also refactor the fillInUnixFile() routine in os_unix.c to reduce the number of parameters. (check-in: cb774b26 user: drh tags: trunk) | |
| 17:59 | Refactor sqlite3OsFileControlNoFail() into sqlite3FileControlHint(). (check-in: 722735a4 user: drh tags: trunk) | |
| 17:28 | Avoid passing strings with a single nul-terminator (two are required) to the VFS xOpen() method from within the code that checks to see if a master-journal file may be safely deleted. (check-in: 2544f233 user: dan tags: trunk) | |
| 16:56 | Add function sqlite3OsFileControlNoFail(), which is the same as sqlite3OsFileControl() except that it does not simulate OOM errors. This saves adding calls to the BenignMalloc() functions around each of the invocations of sqliteOsFileControl() that ignore the return code. (check-in: af59b182 user: dan tags: trunk) | |
| 16:40 | Check the return code from sqlite3OsFileControl() in sqlite3BtreeCopyFile() and report any errors that it generates. (check-in: 7f852ac6 user: drh tags: trunk) | |
| 00:24 | Remove the BenignMalloc() from around the call to FCNTL_OVERWRITE. Add new ones around sqlite3OsDelete(). Fix an assert that causes problems for the nx-devkit. (check-in: 38bc4236 user: drh tags: trunk) | |
|
2012-01-09
| ||
| 14:57 | Cherry-pick the fix to surplus overflow files in the multiplexor, check-in [1238619756c0c] in the trunk. (check-in: 2f8c62c3 user: drh tags: nx-devkit) | |
| 14:19 | Cosmetic changes to lemon. No changes to core functionality nor impact on SQLite. (check-in: 393fc78a user: drh tags: trunk) | |
| 13:41 | Make sure the multiplexor does not create unnecessary overflow files. (check-in: 12386197 user: drh tags: trunk) | |
| 11:37 | Have test_multiplex.c add a second nul-terminator byte to the strings that it passes to the xOpen method of the underlying VFS, in case that VFS passes the string to sqlite3_uri_parameter() or similar. (check-in: 12f5b8c9 user: dan tags: trunk) | |
|
2012-01-08
| ||
| 22:18 | Fix typos in commands. Combine the ExpandBlob and expandBlob macros into one. (check-in: fc9179e1 user: drh tags: trunk) | |
| 12:32 | Make sure the shared-memory filename sythesized by os_win.c is double-zero terminated, so that it can be used with sqlite3_uri_parameter(). (check-in: 429380f9 user: drh tags: trunk) | |
| 00:54 | Fix harmless compiler warning seen with MSVC. (check-in: 9612bcd6 user: mistachkin tags: trunk) | |
|
2012-01-07
| ||
| 15:17 | Fix a bug in lemon in computation of which non-terminals can generate an empty string. This bug and the fix make absolutely no difference for the grammar used by SQLite, but it can make a difference when lemon is used in other grammars. (check-in: ce32775b user: drh tags: trunk) | |
|
2012-01-06
| ||
| 13:58 | Add missing finish_test to the end of the zerodamage.test module. Disable the zerodamage module if virtual tables are omitted from the build. (check-in: d2a5685b user: drh tags: trunk) | |
|
2012-01-05
| ||
| 23:32 | Combine various boolean variables in the BtShared structure into a single boolean vector. Also make performance improvement simplifications to sqlite3BtreeMovetoUnpacked(). (check-in: 11949331 user: drh tags: trunk) | |
| 21:19 | Make sure the name of the shared memory file has two zero-terminators in the UNIX VFS, so that sqlite3_uri_parameter() will work correctly on that name. (check-in: 3d088ba5 user: drh tags: trunk) | |
| 18:33 | Fix an incorrect assert() on the sqlite3FileSuffix3() function. (check-in: 24db54bd user: drh tags: trunk) | |
| 16:07 | Change the unix VFS so that it ignores all but the least-significant bit of the syncDir flag to xDelete. Add an assert to prove that the core only ever uses that one bit. (check-in: e75fd3b2 user: drh tags: trunk) | |
| 13:02 | Merge all of the latest trunk changes into the sessions branch. (check-in: a9bcb432 user: drh tags: sessions) | |
| 12:38 | Ensure 8-byte alignment of Index.aiRowEst elements even if the size of an Index object is not a multiple of 8 bytes. (check-in: 1378f905 user: drh tags: trunk) | |
| 11:43 | Remove the SQLITE_FCNTL_SYNC_OMITTED cases from the unix and windows VFSes as they are no longer needed because of check-in [fd3822f1f2]. (check-in: 7cf568a1 user: drh tags: trunk) | |
|
2012-01-04
| ||
| 12:57 | Fix typos and comments and make minor changes to a few function names, as suggested by readership. (check-in: e9d05cbb user: drh tags: trunk) | |
|
2012-01-03
| ||
| 21:54 | Pull all the latest trunk changes over into the apple-osx branch. (check-in: 8a048423 user: drh tags: apple-osx) | |
| 21:33 | Experimental changes to prevent buffer overreads when parsing a corrupt database file. (Closed-Leaf check-in: 9e5add51 user: drh tags: no-overread) | |
| 14:50 | Make sure filenames passed into sqlite3OsOpen() always have the extra zero-terminators needed by sqlite3_uri_parameter(). (check-in: d73e93cf user: drh tags: trunk) | |
|
2012-01-02
| ||
| 18:20 | Remove the code that attempts to find the sector size from the OS and hardcode the xSectorSize methods of the unix and windows VFSes to return SQLITE_DEFAULT_SECTOR_SIZE, which is now set to 4096 unless overridden. (check-in: 03d8362c user: drh tags: trunk) | |
| 18:00 | Change page quantities in pcache1.c to unsigned. (check-in: da52e6e8 user: drh tags: trunk) | |
| 16:38 | Remove an incorrect assert() in btree.c. (check-in: c1691d99 user: drh tags: trunk) | |
| 15:45 | Make sure large negative arguments to PRAGMA cache_size do not cause 32-bit signed integer overflow. Also correct a requirements mark. (check-in: 17c30634 user: drh tags: trunk) | |
| 14:50 | Have SQLITE_FCNTL_SYNC_OMITTED use the normal method of returning an error code. (check-in: fd3822f1 user: dan tags: trunk) | |
| 12:41 | Fix the build so that it works when SQLITE_ENABLE_8_3_NAMES=1. (check-in: d9761f15 user: drh tags: trunk) | |
|
2012-01-01
| ||
| 13:58 | Tweaks to improve testability. (check-in: e3a929e4 user: drh tags: trunk) | |
|
2011-12-31
| ||
| 21:51 | Fix typos in comments. No changes to code. (check-in: 6827338e user: drh tags: trunk) | |
| 10:18 | Add calls to the BenignMalloc() functions around the SQLITE_FCNTL_OVERWRITE call in backup.c. (check-in: 3e0833db user: dan tags: trunk) | |
|
2011-12-30
| ||
| 18:16 | Add calls to the BenignMalloc() functions around the SQLITE_FCNTL_SIZE_HINT call in pager.c. (check-in: c17a3f5e user: dan tags: trunk) | |
| 16:16 | Fix a typo in the documentation for PCACHE2. No changes to code. (check-in: 46e7903a user: drh tags: trunk) | |
| 16:09 | Change dbstatus.test to account for the fact that the value reported by DBSTATUS_SCHEMA_USED may be slightly lower than the actual memory used on osx (check-in: 6f2010c8 user: dan tags: trunk) | |
| 16:07 | Fix up requirements marks for syntax diagrams to reflect the new and improved GIF renderings. (check-in: 1bb23a3b user: drh tags: trunk) | |
| 15:17 | Update the text of requirements associated with sqlite3_pcache_methods2. Update requirements marks embedded in code. All of the above are comment changes only; there are no changes to code in this check-in. (check-in: f945c41a user: drh tags: trunk) | |
| 11:43 | Hold the database handle mutex for the duration of sqlite3_db_release_memory(). (check-in: eeaf2988 user: dan tags: trunk) | |
| 10:54 | Minor changes to fix compilation with SQLITE_OMIT_WAL and SQLITE_OMIT_WSD defined. (check-in: 26a513a8 user: dan tags: trunk) | |
| 09:00 | Change an implicit i64-to-int cast in pager.c to an explicit cast. (check-in: 6a71ba9c user: dan tags: trunk) | |
| 05:08 | Fix some typos in comments. No code changes. (check-in: 4edc5994 user: dan tags: trunk) | |
|
2011-12-23
| ||
| 20:49 | Documentation updates. No changes to code. (check-in: a8a1a639 user: drh tags: trunk) | |
| 13:32 | Avoid excess syncs when padding a transaction in a WAL. (check-in: 1f24ae71 user: drh tags: trunk) | |
| 02:07 | Merge the POWERSAFE_OVERWRITE features and the use of statvfs() from the statvfs branch into trunk. (check-in: 2370d70e user: drh tags: trunk) | |
| 01:04 | Change the name ZERO_DAMAGE to the more descriptive POWERSAFE_OVERWRITE. The query parameter used to control this device characteristic is now "psow". (Closed-Leaf check-in: 6191c5e4 user: drh tags: statvfs) | |
| 00:25 | Merge the latest trunk changes into the statvfs branch. (check-in: d5e36327 user: drh tags: statvfs) | |
| 00:07 | Add interfaces sqlite3_uri_boolean() and sqlite3_uri_int64() which are wrappers around sqlite3_uri_parameter() combined with internal routines for converting strings to booleans and 64-bit integers. (check-in: 83d26b9a user: drh tags: trunk) | |
|
2011-12-22
| ||
| 17:31 | Fix minor issues with FTS and RTREE discovered by coverity. (check-in: 1c27d842 user: drh tags: trunk) | |
| 17:10 | Check the return code from sqlite3_initialize() called from within sqlite3_soft_heap_limit64() and return an error from sqlite3_soft_heap_limit64() if sqlite3_initialize() fails. (check-in: 676acce2 user: drh tags: trunk) | |
| 15:30 | Fix a problem in fts3_write.c causing stack memory to be referenced after it is out of scope. (check-in: f9c4a7c8 user: dan tags: trunk) | |
| 02:10 | Merge recent trunk changes into the statvfs branch. (check-in: 995ec8a4 user: drh tags: statvfs) | |
| 01:46 | Remove a redundant assignment operator. (check-in: 19a6852a user: drh tags: statvfs) | |
|
2011-12-21
| ||
| 23:38 | Cherry-pick the SQLITE_DIRECT_OVERFLOW_READ fix for ticket [ac0ff496b7e] of changes [c5256b59ad] and [c723e3e18a] into the nx-devkit branch. (check-in: 42f31f19 user: drh tags: nx-devkit) | |
| 18:04 | Fix other problems where 32-bit integer overflow may cause a problem. Two that require an improbably large sub-journal and two in test harness code. Ticket [ac0ff496b7e2] (check-in: c723e3e1 user: dan tags: trunk) | |
| 17:00 | Avoid 32-bit overflow when calculating the byte offset of an overflow page in SQLITE_DIRECT_OVERFLOW_READ code. Fix for [ac0ff496b7]. (check-in: c5256b59 user: dan tags: trunk) | |
| 14:42 | Add the ability to enable or disable SQLITE_IOCAP_ZERO_DAMAGE using a URI parameter for both unix and windows. Add a file-control to query or disable the ZERO_DAMAGE setting. Add the -uri option to the "sqlite3" TCL command in tclsqlite3.c. Allow the sqlite3_uri_parameter() interface to accept a NULL pointer for its first parameter. (check-in: c83627b7 user: drh tags: statvfs) | |
|
2011-12-20
| ||
| 22:18 | Remove the code that tries to detect OOO header writes on a WAL recovery. The code is made obsolete by syncing the WAL header. (check-in: 7ac713a1 user: drh tags: statvfs) | |
| 20:13 | Refactor the sqlite3WalFrames() routine for clarity of presentation. Do the padded transaction sync as the write pointer crosses the final sector boundary instead of at the end, for efficiency. Always sync the WAL header immediately after it is written. (check-in: 92c73b42 user: drh tags: statvfs) | |
| 13:13 | Assert that the isCommit parameter to sqlite3WalFrames() is zero if and only if the nTruncate parameter is zero. (check-in: 979daf92 user: drh tags: trunk) | |
|
2011-12-19
| ||
| 15:46 | Add test for WAL mode to unixexcl.test. (check-in: 4d518bd4 user: dan tags: trunk) | |
| 11:57 | Merge [21b76af6ed] into statvfs branch. (check-in: e694f7b1 user: dan tags: statvfs) | |
| 11:16 | Fix a couple of test cases to account for the master-journal name related change in [cf3bccc2]. (check-in: 21b76af6 user: dan tags: trunk) | |
| 10:07 | Modify test cases to account for the ZERO_DAMAGE change. (check-in: 68684495 user: dan tags: statvfs) | |
| 00:31 | Some fixes to the test suite so that it works with ZERO_DAMAGE set to true. Still lots more problems remain. (check-in: 41891b23 user: drh tags: statvfs) | |
|
2011-12-17
| ||
| 20:02 | For improved clarity of presentation, refactor some of the code associated with ZERO_DAMAGE and sector-size. (check-in: 1dde96c9 user: drh tags: statvfs) | |
| 19:49 | Add SQLITE_IOCAP_ZERO_DAMAGE and enable it for both unix and windows. Use this device characteristic to reduce the required work in journaling. A side effect is that this changes the default page exists back to 1024 even with the use of statvfs(). (check-in: a0be6ea4 user: drh tags: statvfs) | |
| 16:25 | Fix a bad #endif with the previous check-in on this branch. (check-in: 915713ff user: drh tags: statvfs) | |
| 16:09 | Add support for statvfs() in os_unix.c, for determining the sector size. This causes many TCL test failures under Linux. (check-in: e0d44450 user: drh tags: statvfs) | |
| 13:45 | Merge in changes that cause the first sector of the WAL file to be synced when the WAL restarts. This is a fix for the power-loss corruption problem described in ticket [ff5be73dee086] (check-in: 44ca4d12 user: drh tags: trunk) | |
| 08:10 | Add tests to walcrash3.test. (check-in: d7688042 user: dan tags: trunk) | |
| 01:31 | Make sure the Salt-1 value in the WAL file is sequentially numbered at each checkpoint, as it says it should be in the documentation. (check-in: 7b63b11b user: drh tags: trunk) | |
|
2011-12-16
| ||
| 21:26 | Enhance the WAL header sync so that it honors the various synchronous pragmas, settings, and device characteristics. (Closed-Leaf check-in: 9799241f user: drh tags: wal-header-sync) | |
| 19:34 | Proposed changes that ensure that the WAL header is written prior to the first commit mark. (check-in: 91d0437c user: drh tags: wal-header-sync) | |
| 17:01 | Add code for a test that was failing before the persistent-wal related changes of [09ccc4a1be]. (check-in: 49d21ce5 user: dan tags: trunk) | |
| 15:38 | Merge the fix for [a1fa75cbdd02] from the experimental branch. Also fix the persistent-wal mode feature of truncating the WAL on close so that it always truncates the WAL to zero bytes. (check-in: 09ccc4a1 user: drh tags: trunk) | |
| 15:11 | Improved logging of master-journal name conflicts. (check-in: b1005ef4 user: drh tags: trunk) | |
| 13:42 | Merge the nx-devkit changes into trunk. (check-in: cf3bccc2 user: drh tags: trunk) | |
| 13:24 | Experimental fix for [a1fa75cbdd]. (Closed-Leaf check-in: 6492af76 user: dan tags: experimental) | |
| 05:50 | Tweaks to the way multiplexSubOpen() works, for backwards compatibility. (check-in: bb403388 user: drh tags: nx-devkit) | |
| 05:09 | Fix a potential infinite loop (inserted by the previous check-in) on the multiplexWrite() method of the multiplexor. (check-in: 022bf427 user: drh tags: nx-devkit) | |
| 04:57 | The xTruncate method for the multiplexor now changes surplus overflow files to zero-length by default. Or if the "truncate" query parameter is used, it actually deletes the surplus overflow files. This allows VACUUM to shrink the database again. (check-in: 5aefef04 user: drh tags: nx-devkit) | |
| 01:30 | Call sqlite3_log() with an appropriate message if unable to find a unique master-journal filename. (check-in: e9177f7d user: drh tags: nx-devkit) | |
| 01:21 | A better solution to being unable to find a unique master-journal filename: just delete an existing master-journal and reuse it. (check-in: 2685c2b9 user: drh tags: nx-devkit) | |
| 00:33 | Make sure the antipenultimate character of master-journal filenames is a "9" in order to avoid collisions with other files in 8+3 filename mode. Also, limit the number of attempts at finding a unique master-journal filename. (check-in: 34a04836 user: drh tags: nx-devkit) | |
|
2011-12-15
| ||
| 17:44 | Add stdio support to the quota VFS. (check-in: 322bd15f user: drh tags: trunk) | |
| 17:42 | Use _commit() rather than FlushFileBuffers() as a substitute for fsync() on windows. Also cast for C++ and add support for SQLITE_FCNTL_VFSNAME. (Closed-Leaf check-in: e85cfe9a user: drh tags: quota-stdio) | |
| 17:00 | When deleting a file with the multiplexor VFS, also delete any overflow files that exist. (check-in: 3af1feaa user: dan tags: nx-devkit) | |
| 13:29 | Make sure the chunksize in test_multiplex does not cause the pending byte to fall near the end of a chunk. Adjust the chunksize upward as necessary to prevent this. (check-in: e05f8a29 user: drh tags: nx-devkit) | |
| 11:45 | Fix some problems with dropped error codes in multiplexOpen(). (check-in: 2d50f781 user: dan tags: nx-devkit) | |
| 02:22 | In the multiplexor, do not try to delete overflow files that do not exist. And assume all but the last overflow file is the size of the chunk size. (check-in: a822a80d user: drh tags: nx-devkit) | |
|
2011-12-14
| ||
| 18:33 | Merge the nx-devkit changes into trunk. This includes the new SQLITE_FCNTL_VFSNAME file-control. (check-in: da118e02 user: drh tags: trunk) | |
| 18:28 | Merge the VFSNAME file-control addition into the nx-devkit branch. (check-in: 08c1dc51 user: drh tags: nx-devkit) | |
| 17:53 | Add a file-control that will discover the name of the bottom-level VFS and all the shims in between. (Closed-Leaf check-in: cdbfb553 user: drh tags: vfsname-filectrl) | |
| 01:38 | Improvements to comments. No code changes. (check-in: 08bbbd8e user: drh tags: nx-devkit) | |
| 00:37 | Treat a zero return value from the Win32 APIs MultiByteToWideChar and WideCharToMultiByte as an error condition. (check-in: c65e5a36 user: mistachkin tags: trunk) | |
| 00:04 | Harden the utf8-to-mbcs converter in the quota module against failures. (check-in: 1cda511d user: drh tags: quota-stdio) | |
|
2011-12-13
| ||
| 23:26 | Enhancements to test_quota.c: Remove the external dependency on sqlite3_win32_utf8_to_msbc(). Add an extra parameter to quota_fflush() that will also do an fsync (or the equivalent). (check-in: 92f4188f user: drh tags: quota-stdio) | |
| 19:03 | Add a hard limit to the number of chunks a multiplexed database may consist of if ENABLE_8_3_NAMES is defined. (check-in: 43a12640 user: dan tags: nx-devkit) | |
| 18:22 | Change the SQLITE_EXTRA_INIT routine to take a single argument which is a pointer to a string. Call SQLITE_EXTRA_INIT with a NULL argument. Fixes to multiplexor to treat the VFS properly in corner cases. Fix the initialization of multiplex3.test. (check-in: 8e65b913 user: drh tags: nx-devkit) | |
| 16:40 | Add extra tests for the multiplexor VFS. No changes to code. (check-in: c7de6f68 user: dan tags: nx-devkit) | |
| 15:37 | Merge the nx-devkit changes into trunk. (check-in: 03a70c3d user: drh tags: trunk) | |
| 15:25 | Update the multiplex.test script to conform to that found in the "experimental" branch off of trunk. (check-in: 2eb79efb user: drh tags: nx-devkit) | |
| 15:02 | Move the multiplexor changes in the experimental branch (check-ins [255d21499b] and [199f52bced]) into the nx-devkit branch. (check-in: eb95d2f7 user: drh tags: nx-devkit) | |
| 12:10 | This branch merged with nx-devkit and from there into trunk. Was: In the multiplexor, instead of generating a unique file-name when SQLite opens a temp file, allow the underlying VFS to generate a different temp file for each chunk. Given the changes to the xFileSize method, it is no longer necessary for the different chunks of a temp file to use the same base name. (Closed-Leaf check-in: 199f52bc user: dan tags: experimental) | |
| 11:15 | Change the way IO errors are handled in the xFileSize method of the multiplexor VFS. Add test file multiplex3.test. (check-in: 255d2149 user: dan tags: experimental) | |
| 04:08 | When an sqlite3_auto_extension() function fails, report back its actual error code, not the generic SQLITE_ERROR. (check-in: ce55f250 user: drh tags: nx-devkit) | |
| 02:41 | When the multiplexor FileSize procedure fails to open the file, assume that the file is zero bytes in size. (check-in: dc8118cd user: drh tags: nx-devkit) | |
| 01:34 | Add a compile-time shutdown procedure to be called by sqlite3_shutdown() to undo the effects of the compile-time initialization procedure. (check-in: c2ed86f5 user: drh tags: nx-devkit) | |
|
2011-12-12
| ||
| 20:01 | Backport a minimal set of changes needed to get 8+3 filenames and the multiplexor shim playing well together. (check-in: c4e2ce48 user: drh tags: nx-devkit) | |
| 19:48 | Fix os_unix.c so that, unless 8.3 filenames are actually in use, journal and wal file permissions are assigned correctly even if SQLITE_ENABLE_8_3_NAMES is defined. (check-in: 169e1229 user: dan tags: trunk) | |
| 19:47 | Make sure the quota logic is usable as C++. (check-in: f4534bd3 user: drh tags: quota-stdio) | |
| 18:55 | Change the multiplexor VFS so that xTruncate is a no-op on database files. (check-in: ee1e0122 user: dan tags: trunk) | |
| 18:21 | Fix for the xFileSize method of test_multiplex.c when used on a file opened with the DELETEONCLOSE flag set. (check-in: 713071c4 user: dan tags: trunk) | |
| 16:51 | Add magic comments to shell.c to make it easier for scripts to insert additional version information displays for custom builds. (check-in: 9b2691aa user: drh tags: trunk) | |
|
2011-12-11
| ||
| 22:44 | In the multiplexor shim, when using 8+3 filenames, begin numbering journal overflow files with 101 instead of 001 to avoid name collisions with the main database file. (check-in: 05bf8a0b user: drh tags: trunk) | |
| 21:51 | Update comments describing the flattening optimization in select.c. (check-in: dab4c137 user: drh tags: trunk) | |
| 02:30 | Fix STAT3 so that it works with the new uninitialized register logic of the VDBE. Ticket [7bbfb7d4422ff] (check-in: d11a5798 user: drh tags: trunk) | |
| 02:29 | Fix harmless compiler warnings. (check-in: 1e6a698a user: drh tags: trunk) | |
|
2011-12-10
| ||
| 23:18 | Minor cleanups of the compound-subquery flattening logic. New test cases added for joins the compound subquery. (check-in: 5061d85f user: drh tags: trunk) | |
| 17:17 | Allow UNION ALL compounds to be promoted up to replace a simple wrapper SELECT even if the compounds are joins. (check-in: 3d4b4f4f user: drh tags: trunk) | |
| 15:55 | Import the experimental parse-tree explainer, with fixes, from the tree-explain branch. Disabled by default. Use SQLITE_ENABLE_TREE_EXPLAIN to turn it on. (check-in: bcbc7152 user: drh tags: trunk) | |
| 14:44 | Merge the latest trunk changes into tree-explain branch. (Closed-Leaf check-in: 1a360da0 user: drh tags: tree-explain) | |
| 13:49 | Always use _msize() to get memory allocation sizes on windows, without having to do anything special in the makefile. (check-in: 256e27bd user: drh tags: trunk) | |
|
2011-12-09
| ||
| 18:06 | Change the VDBE so that all registers are initialized to "Invalid" instead of NULL and report errors on any attempted read of an Invalid register. This will help prevent future bugs similar to [7bbfb7d442]. (check-in: 0064bab7 user: drh tags: trunk) | |
| 17:51 | Remove an unnecessary condition. (Closed-Leaf check-in: d9ba023c user: drh tags: uninit-vdbe-mem) | |
| 17:38 | Remove an unnecessary initialization of Vdbe.aOnceFlag. (check-in: 421714da user: drh tags: uninit-vdbe-mem) | |
| 17:27 | Take out the OP_JumpOnce opcode. Revert compound SELECT to use OP_IfNot, which is the correct behavior. Mark trigger registers as initially invalid. (check-in: 6a9fb47d user: drh tags: uninit-vdbe-mem) | |
| 16:59 | Previous check-in broke auto-increment. This check-in appears to fix it. (check-in: 28ffd39c user: drh tags: uninit-vdbe-mem) | |
| 16:21 | Make no assumptions about the initial state of VDBE registers. (check-in: 521d72bd user: drh tags: uninit-vdbe-mem) | |
| 13:24 | Modify the OP_Once opcode so that it works correctly in trigger sub-programs. This is a candidate fix for [7bbfb7d442]. (check-in: 557c6905 user: dan tags: trunk) | |
| 05:52 | The Windows OS flavor #ifdefs must be performed after the 'windows.h' file has been included. (check-in: 3702a31e user: mistachkin tags: trunk) | |
|
2011-12-08
| ||
| 21:08 | Merge the latest trunk changes into the apple-osx branch. (check-in: 59e0d4f3 user: drh tags: apple-osx) | |
| 20:41 | Hand merge the zone allocator for MacOS from the apple-osx branch. (check-in: 0d955c20 user: drh tags: trunk) | |
| 19:50 | In persistent WAL mode, truncate the WAL file to the size specified by the journal_size_limit pragma when disconnecting from the WAL. (check-in: 9687b305 user: drh tags: trunk) | |
| 03:51 | Follow the previously established pattern for detecting preprocessor defines for specific flavors of Windows (for NT in this case). (check-in: a0d92193 user: mistachkin tags: trunk) | |
|
2011-12-07
| ||
| 22:49 | Additional detail added to the tree-explain output for SELECT statements. (check-in: 7b457ea4 user: drh tags: tree-explain) | |
| 15:33 | More compact notation for the parse-tree view. (check-in: 0eb3f8b1 user: drh tags: tree-explain) | |
| 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
| ||
| 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: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) | |
| 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:49 | Cherrypick patch [3126754c72] from the trunk into the content= branch. (check-in: f9b5b217 user: dan tags: fts4-content) | |
| 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
| ||
| 23:53 | Forward port the Apple-specific changes from [db5b7b778c] in the apple-osx-377 branch. Fix this up so that it will compile and run on Linux. (check-in: 6cb43f6c user: drh tags: apple-osx) | |
| 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) | |
| 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-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) | |
| 03:13 | Merge the cache-stats enhancement into trunk. (Closed-Leaf check-in: 646db971 user: drh tags: mistake) | |
| 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-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: 89272357 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: 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) | |
| 20:32 | Merge in all trunk changes through the 3.7.8 release. (check-in: ade72b18 user: drh tags: apple-osx) | |
| 20:28 | Merge in all trunk changes through the version 3.7.8 release. (check-in: 98619a23 user: drh tags: sessions) | |
| 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
| ||
| 18:56 | Remove a couple of comments that were causing problems for the amalgamation generator script. (check-in: ffed86bf user: drh tags: apple-osx) | |
| 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:40 | Merge the latest trunk changes into the sessions branch. (check-in: 5efb0294 user: drh tags: sessions) | |
| 19:36 | Merge the latest trunk fixes into the apple-osx branch. (check-in: 070bf203 user: drh tags: apple-osx) | |
| 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
| ||
| 19:41 | Merge latest changes from the trunk into the sessions branch. (check-in: c00e45ed user: dan tags: sessions) | |
| 19:05 | Merge in the latest changes from trunk. (check-in: 2456b4d0 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: 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) | |
| 19:20 | Merge the latest trunk changes into the sessions branch. (check-in: eb036d6f user: drh tags: sessions) | |
| 19:18 | Merge the latest trunk changes into the apple-osx branch. (check-in: 55af8003 user: drh tags: apple-osx) | |
| 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) | |
|
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) | |
| 02:02 | In the MSVC makefile, support several levels of debugging, each one building on the previous. Also, add comment about the SQLITE_WIN32_MALLOC_VALIDATE macro. (check-in: 4257e9b7 user: mistachkin tags: winNativeHeap) | |
| 01:58 | Cherrypick the [d4f6437f8d] change so that SQLITE_FCNTL_SIZE_HINT is always honored and never undone by memory pressure on windows. (check-in: 67ff8d27 user: drh tags: trunk) | |
| 01:42 | Add the sqlite3_quota_file() interface to test_quota.c. (check-in: 2b7fe8e5 user: drh tags: trunk) | |
| 01:16 | Make sure that SQLITE_FCNTL_SIZE_HINT on Windows does not shrink the file. (check-in: d4f6437f user: mistachkin tags: winNativeHeap) | |
| 00:14 | Add the SQLITE_EXTRA_INIT macro. (check-in: a3220f36 user: drh tags: trunk) | |
|
2011-08-24
| ||
| 17:42 | Add error logging to native Win32 heap support. (check-in: 7fca5a28 user: mistachkin tags: winNativeHeap) | |
| 16:13 | Experimental work to allow SQLite to use the native Win32 heap API. (check-in: bf3d0ab5 user: mistachkin tags: winNativeHeap) | |
| 15:18 | Updates to the sqlite3_mem_methods documentation. (check-in: 988998fe user: drh tags: trunk) | |
| 15:12 | Fix some harmless compiler warnings. (check-in: 46f5a68b user: drh tags: trunk) | |
| 01:25 | Changes to test_quota.c to make quota groups persistent even after files are closed. Files remain a part of the quota group until they are deleted. (check-in: 04111ce9 user: drh tags: trunk) | |
|
2011-08-23
| ||
| 23:41 | Simplifications to the SQLITE_PAGECACHE_BLOCKALLOC logic. Reduce the number of difficult-to-reach branches. (check-in: d5d835fe user: drh tags: trunk) | |
| 20:11 | If the application-defined openDirectory() function returns SQLITE_CANTOPEN, then silently ignore the error. This allows the chromium sandbox to disallow opening of directories without causing errors. (check-in: 880b5115 user: drh tags: trunk) | |
| 19:46 | Change the way the "crash" VFS (test6.c) handles SQLITE_FCNTL_SIZE_HINT. (check-in: 40dd8a60 user: dan tags: trunk) | |
| 18:06 | Merge latest trunk changes into the apple-osx branch. (check-in: c5f7977b user: dan tags: apple-osx) | |
| 16:41 | Have the "crash" VFS used by the tcl tests (test6.c) handle SQLITE_FCNTL_SIZE_HINT internally, instead of passing it directly through to the underlying VFS. This is important if the crash VFS is simulating non-default device characteristics such as SQLITE_DEVCAP_SEQUENTIAL or ATOMIC. (check-in: fac8bc8f user: dan tags: trunk) | |
| 13:27 | Ifdef out routines in pcache1.c that are used only when SQLITE_PAGECACHE_BLOCKALLOC is defined. (check-in: 0da292da user: drh tags: trunk) | |
| 12:50 | Merge the PAGECACHE_BLOCKALLOC changes into trunk. (check-in: 768c1846 user: drh tags: trunk) | |
| 11:47 | When copying a rollback mode database over a WAL database using the backup API, leave the destination database in WAL mode (instead of switching it to rollback mode). Fix for [af95b8c609]. (check-in: 35e6ac18 user: dan tags: trunk) | |
| 05:10 | Change to test instrumentation of os_unix.c: Regard IO errors that occur within SQLITE_FCNTL_SIZE_HINT requests as benign. (This check-in was intended for trunk and went onto the branch accidentally.) (Closed-Leaf check-in: ca47da2a user: dan tags: pager-blockalloc) | |
| 00:01 | Remove a branch that is always true. (check-in: a6568192 user: drh tags: trunk) | |
|
2011-08-22
| ||
| 20:33 | Remove an unreachable branch in the FK code. (check-in: 6c227cc8 user: drh tags: trunk) | |
| 14:55 | Modify test cases so that veryquick.test passes with PAGECACHE_BLOCKALLOC defined. (check-in: c6100070 user: dan tags: pager-blockalloc) | |
| 09:54 | Fix for [b1d3a2e531]. (check-in: 3f3acee4 user: dan tags: trunk) | |
|
2011-08-19
| ||
| 18:15 | Experimental change: If SQLITE_PAGECACHE_BLOCKALLOC is defined, instead of allocating pages one at a time, allocate blocks of between 15 and 63 pages in a single allocation. (check-in: 63597097 user: dan tags: pager-blockalloc) | |
| 14:54 | When retrying a write() after an EINTR error on unix, be sure to also rerun the previous lseek(). Ticket [e59bdf6116036a] (check-in: 21452f3a user: drh tags: trunk) | |
|
2011-08-18
| ||
| 17:47 | Ensure that the Tcl "db onecolumn" command returns an empty string if the SELECT statement returns zero rows. (check-in: 928bcaf0 user: dan tags: trunk) | |
| 13:45 | Fix the stat3 analysis loader to be compatible with sqlite3_db_status(). Also fix some OOM issues with the stat3 analysis loader. (Closed-Leaf check-in: eaf447ea user: drh tags: stat3-enhancement) | |
| 02:51 | Fix a bug in the cleanup of stat tables on a DROP TABLE in autovacuum mode. (check-in: 3fe5d54f user: drh tags: stat3-enhancement) | |
| 01:10 | Fix an error with OOM processing in the ANALYZE logic. (check-in: b26ec79c user: drh tags: stat3-enhancement) | |
|
2011-08-17
| ||
| 07:46 | Properly process x64 DLL exports, which do not contain a leading underscore, in the MSVC makefile. (check-in: d5936324 user: mistachkin tags: trunk) | |
| 02:19 | Add vdbesort.c to the MSVC makefile. (check-in: 8eaa2cd3 user: mistachkin tags: trunk) | |
| 00:40 | Use OP_Sort rather than OP_Rewind in order to sort the content of a new index on the CREATE INDEX statement. Add an ALWAYS() to the merge sort logic to document an unreachable branch. (check-in: f01766f4 user: drh tags: trunk) | |
|
2011-08-16
| ||
| 17:06 | Fix a few harmless compiler warnings. Add SQLITE_ENABLE_STAT3 to the standard compiler warning script. (check-in: 3d68f9af user: drh tags: stat3-enhancement) | |
| 02:07 | Allow the sqlite3VdbeJumpHere() routine to accept a negative or zero address if a prior memory allocation error has occurred. The new sqlite_stat3 logic needs this. (check-in: 9650d796 user: drh tags: stat3-enhancement) | |
| 01:15 | Add the analyze8.test test module for sqlite_stat3. (check-in: 2c83ac89 user: drh tags: stat3-enhancement) | |
|
2011-08-15
| ||
| 19:44 | Updated comments on the multiplexor extension. No changes to code. (check-in: 0f42ef69 user: drh tags: trunk) | |
| 15:37 | Fix an assert() in the merge-sort logic to account for I/O errors. (check-in: c1daa809 user: drh tags: trunk) | |
| 15:27 | New makefile target "sqlite3-debug.c" builds an amalgamation that include appropriate "#line" macros relating the code back to the original source files. (check-in: 26f2da24 user: drh tags: trunk) | |
| 14:41 | When opening a temporary file to use in a merge-sort, pass SQLITE_OPEN_TEMP_JOURNAL instead of SQLITE_OPEN_TEMP_DB. This is a better fit, as merge-sort files are written and read sequentially like journal files. (check-in: bd04756b user: dan tags: trunk) | |
| 12:58 | Update some test cases to work with sqlite_stat3 instead of sqlite_stat2. (check-in: 2504bcfb user: drh tags: stat3-enhancement) | |
| 12:02 | Fix a couple of typos in comments in analyze.c. (check-in: ae31dc67 user: dan tags: stat3-enhancement) | |
|
2011-08-13
| ||
| 19:35 | Further testing and bug fixing for sqlite_stat3. Added the Index.avgEq field to index statistics. Fixed several problems in the query planner associated with stat3. (check-in: 89b2f708 user: drh tags: stat3-enhancement) | |
| 15:25 | Add the sqlite_stat3.nDLT field. Use an linear congruence PRNG to choose which samples to select from among those with the same nEq field. (check-in: 1dcd2428 user: drh tags: stat3-enhancement) | |
| 10:47 | Fix the header comment on the implementation of the file_control_sizehint_test TCL command in test1.c. (check-in: 30919808 user: drh tags: trunk) | |
| 00:58 | The ANALYZE command picks for 15 samples for sqlite_stat3 with the largest nEq fields, plus 5 other evenly spaced samples. (check-in: 8225924e user: drh tags: stat3-enhancement) | |
|
2011-08-12
| ||
| 16:47 | Merge the experimental changes to use a merge-sort when creating an index into the trunk. (check-in: 346a453d user: dan tags: trunk) | |
| 16:34 | Update Makefile.in and configure to account for new source file vdbesort.c. (Closed-Leaf check-in: 69e4b41d user: dan tags: experimental) | |
| 16:30 | Merge latest trunk changes into experimental branch. (check-in: 7e515055 user: dan tags: experimental) | |
| 01:51 | Begin a branch that experimentally replaces sqlite_stat2 with a new table called sqlite_stat3 that will hopefully facilitate better query planning decisions. (check-in: 52e1d7e8 user: drh tags: stat3-enhancement) | |
|
2011-08-10
| ||
| 01:52 | Make the openDirectory routine in os_unix.c overrideable so that it can be turned into a harmless no-op for the chromium sandbox. (check-in: 6b236069 user: drh tags: trunk) | |
|
2011-08-09
| ||
| 18:14 | Add command-line utilities "offsets.c" and "extract.c" for use in low-level analyzsis of database files. (check-in: dfa22ed4 user: drh tags: trunk) | |
|
2011-08-08
| ||
| 23:48 | In os_unix.c, do not open the directory containing the database file when the database file is opened. Instead, wait until time to fsync() the directory. And do not report an error if the open fails, since some systems (Ex: AIX and a chromium sandbox) are unable to open and fsync directories. (check-in: 713b1b7d user: drh tags: trunk) | |
| 23:18 | Allow the unlink() system call to be overridden in os_unix.c. (check-in: 8d1b5c3a user: drh tags: trunk) | |
| 17:18 | Add code to actually use the sqlite_stat2.cnt field in the query planner. This changes some plans resulting in a few failures in analyze5.test. (Closed-Leaf check-in: d1248165 user: drh tags: query-planner-tweaks) | |
|
2011-08-07
| ||
| 01:31 | Remove relevant elements from the sqlite_stat2 table when doing a DROP INDEX or DROP TABLE. (check-in: 3c8f97ae user: drh tags: trunk) | |
| 00:21 | The ANALYZE command adds the sqlite_stat2.cnt column if it does not already exist. (check-in: 794fde6f user: drh tags: query-planner-tweaks) | |
|
2011-08-06
| ||
| 19:48 | The sqlite_stat2.cnt field is parsed if it is present. But it is not yet used. A large comment added to analyze.c to explain the format of the ANALYZE system tables. (check-in: 6d1e2372 user: drh tags: query-planner-tweaks) | |
| 02:03 | Merge together the fork in the query-planner-tweaks branch. (check-in: 2daab6bd user: drh tags: query-planner-tweaks) | |
| 01:22 | Fix a compiler warning when STAT2 is off. More test cases. Fix legacy tests to deal with the new STAT2 logic. (check-in: 7e914aa9 user: drh tags: query-planner-tweaks) | |
|
2011-08-05
| ||
| 22:31 | Bug fixes to the sample-count logic for STAT2. A few test cases added. (check-in: e93c248c user: drh tags: query-planner-tweaks) | |
| 21:13 | Add a column to the sqlite_stat2 table that contains the number of entries with exactly the same key as the sample. We do not yet do anything with this extra value. Some tests in analyze2.test are failing. (check-in: eb434228 user: drh tags: query-planner-tweaks) | |
|
2011-08-03
| ||
| 22:06 | Merge the winopen-retry-logic branch into trunk. The biggest change here is to test scripts, which should now use such as copy_file and delete_file from tester.tcl rather than the raw file commands of TCL. (check-in: b90c28be user: drh tags: trunk) | |
|
2011-08-02
| ||
| 23:45 | Add explanatory comment to the win32lock-2.2 test case. (Closed-Leaf check-in: 4cb17881 user: mistachkin tags: winopen-retry-logic) | |
| 23:34 | Correct subtle timing issues in the win32lock test cases and in the lock_win32_file Tcl command. Also, eliminate superfluous MSVC compiler warnings. (check-in: 7baf0294 user: mistachkin tags: winopen-retry-logic) | |
| 20:19 | Fix missing info exists check for win32lock-2.2 (the one previously applied to win32lock-1.2). (check-in: 8a52698e user: mistachkin tags: winopen-retry-logic) | |
| 20:03 | Replace the missed 'file copy' in malloc_common.tcl with copy_file. (check-in: cd20b4ef user: mistachkin tags: winopen-retry-logic) | |
| 20:01 | Merge in the permutation changes from trunk. (check-in: b30a5e30 user: drh tags: winopen-retry-logic) | |
| 19:42 | Merge the latest trunk changes into the winopen-retry-logic branch. (check-in: 8bef97a0 user: drh tags: winopen-retry-logic) | |
| 00:57 | Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried. (check-in: 9007586f user: mistachkin tags: winopen-retry-logic) | |