Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
99 events for the month beginning 2011-08-01 by user drh
Following month ↑|
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) | |
| 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
| ||
| 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-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) | |
| 18:28 | Veryquick and min.rc tests now passing. (Closed-Leaf check-in: a7e18468 user: drh tags: stat3-3.7.2) | |
| 18:04 | Merge the branch-3.7.2 changes into the stat3-3.7.2 subbranch. Also fix some test script issues. (check-in: a42db19d user: drh tags: stat3-3.7.2) | |
| 17:17 | Cherrypick the recursion fix to test_vfs.c from [065e5a5ea4f82]. Also fix the nan.test module to handle upper/lower case changes in TCL. (check-in: 41b5f869 user: drh tags: branch-3.7.2) | |
| 15:51 | Get stat3 working after import from trunk-based the stat3-enhancement branch. There is still a problem in the wal2 test. (check-in: 01cc4ff6 user: drh tags: stat3-3.7.2) | |
| 14:06 | • Edit [e72cf118cb25e9fe|e72cf118]: Edit check-in comment. Cancel background color. (artifact: 65b9fd98 user: drh) | |
| 14:00 | • Edit [0df04f920b3e6cfe|0df04f92]: Move to branch stat3-3.7.2. Edit check-in comment. (artifact: ed443125 user: drh) | |
| 13:52 | Merge branches branch-3.7.2 and stat3-enhancement into a new branch for testing purposes. (check-in: 0df04f92 user: drh tags: stat3-3.7.2) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 00:14 | Add the SQLITE_EXTRA_INIT macro. (check-in: a3220f36 user: drh tags: trunk) | |
|
2011-08-24
| ||
| 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) | |
| 14:40 | • Edit [ca47da2a1f6e6d22|ca47da2a]: Edit check-in comment. (artifact: 2a3141dc user: drh) | |
| 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 | • Edit [ca47da2a1f6e6d22|ca47da2a]: Mark "Closed". (artifact: b236bf58 user: drh) | |
| 12:50 | Merge the PAGECACHE_BLOCKALLOC changes into trunk. (check-in: 768c1846 user: drh tags: trunk) | |
| 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) | |
| 17:49 | • Ticket [b1d3a2e5] Erroneous FK constraint failure when dropping table. status still Closed with 1 other change (artifact: 796ec978 user: drh) | |
|
2011-08-19
| ||
| 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) | |
| 14:03 | • New ticket [e59bdf61] Possible database corruption following EINTR on unix. (artifact: 27019e28 user: drh) | |
|
2011-08-18
| ||
| 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
| ||
| 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) | |
| 12:58 | Update some test cases to work with sqlite_stat3 instead of sqlite_stat2. (check-in: 2504bcfb user: drh 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
| ||
| 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-11
| ||
| 12:49 | • Edit [0900e35348f4b9bf|0900e353]: Edit check-in comment. (artifact: d1d1fdc5 user: drh) | |
|
2011-08-10
| ||
| 20:18 | • Edit [d1248165e3e02aaf|d1248165]: Mark "Closed". Edit check-in comment. (artifact: 2d2ef93b user: drh) | |
| 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:43 | • Edit [eb434228277c4bbb|eb434228]: Move to branch query-planner-tweaks. Edit check-in comment. (artifact: 1d50519e user: drh) | |
| 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) | |
| 01:09 | Allow the sqlite_stat2 table to contain a number of samples other than the default of 10. (check-in: b9d41c34 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) | |
| 21:46 | Merge the latest trunk changes into the sessions branch. (check-in: c5709036 user: drh tags: sessions) | |
| 21:32 | Avoid segfaulting on an incremental blob write if SQLITE_ENABLE_PREUPDATE_HOOK set but no pre-update hooks are defined. (check-in: 62c44634 user: drh tags: sessions) | |
| 16:40 | • Fixed ticket [d6352363]: Assertion fault on a join with a repeated column plus 2 other changes (artifact: 852716c7 user: drh) | |
| 16:40 | Update the OP_Move opcode to shift the pScopyFrom pointer of aliases when compiled with SQLITE_DEBUG. Ticket [d63523637517386191]. (check-in: a2135ad1 user: drh tags: trunk) | |
| 16:33 | • New ticket [d6352363] Assertion fault on a join with a repeated column. (artifact: 5cf0cd24 user: drh) | |
| 01:07 | Adjust the output row estimating logic when using STAT2. (check-in: c8ba8855 user: drh tags: query-planner-tweaks) | |
|
2011-08-02
| ||
| 20:14 | Exclude the 8_3_names.test script from the inmemory_journal permutation. (check-in: 78fc94c8 user: drh tags: trunk) | |
| 20:01 | Merge in the permutation changes from trunk. (check-in: b30a5e30 user: drh tags: winopen-retry-logic) | |
| 19:59 | Also exclude backcompat.test from inmemory_journal since inmemory_journal is not compatible with WAL mode. (check-in: 861a5b62 user: drh tags: trunk) | |
| 19:42 | Merge the latest trunk changes into the winopen-retry-logic branch. (check-in: 8bef97a0 user: drh tags: winopen-retry-logic) | |
| 19:30 | Omit backcompat.test from the journaltest permutation because it uses WAL mode which is incompatible with journaltest. (check-in: 2bbf3150 user: drh tags: trunk) | |
| 18:25 | Merge all the latest trunk changes into the apple-osx branch. (check-in: 77376b33 user: drh tags: apple-osx) | |
| 01:57 | • Fixed ticket [6c14288a]: Virtual tables do not handle IS NOT NULL correctly plus 2 other changes (artifact: 037f5449 user: drh) | |
| 01:57 | Make sure IS NOT NULL constraints work on virtual tables. Fix for ticket [6c14288a473ceff]. (check-in: a55f4ab9 user: drh tags: trunk) | |
| 01:26 | • New ticket [6c14288a] Virtual tables do not handle IS NOT NULL correctly. (artifact: 9bfe9ae2 user: drh) | |