Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 check-ins occurring around e158812c34b01ce5.
|
2014-05-05
| ||
| 20:24 | Work on cleaning up the MSVC batch build tool integration with Visual Studio 2013. check-in: b5a72dfd user: mistachkin tags: trunk | |
| 20:21 | Attempt to fix the build on beagleboard. Closed-Leaf check-in: 3ac75725 user: drh tags: winHdr | |
| 20:03 | Add test file sort4.test, containing brute force tests for the multi-theaded sorter. check-in: 9cc364c4 user: dan tags: threads | |
| 19:57 | Try to reduce the amount of memory used to hold the schema when PRAGMA ignore_check_constraints is active. check-in: 35a9f3f1 user: drh tags: reduce-schema-size | |
| 18:24 | Centralize and reform use of the Win32 related include files. check-in: 857f2baf user: mistachkin tags: winHdr | |
| 17:49 | Merge updates from trunk. check-in: 6f07f20e user: mistachkin tags: vsixWinPhone81 | |
| 17:45 | Merge updates from trunk. check-in: a3cfd813 user: mistachkin tags: winHdr | |
| 17:43 | Fix several header file comments. No changes to code. check-in: dd6eb5d1 user: mistachkin tags: winHdr | |
| 15:58 | Fix a race condition in the sorter code. check-in: 2d2edfe5 user: dan tags: threads | |
| 09:08 | Add tests so that the "coverage-sorter" test permutation covers all branches in vdbesort.c. Fix a few minor problems in the same file. check-in: bde28b70 user: dan tags: threads | |
|
2014-05-03
| ||
| 20:43 | Add an extra fault-injection test to sortfault.test. Remove an unreachable branch from vdbesort.c. check-in: a33a366b user: dan tags: threads | |
| 19:33 | Fix a race condition in the sorter. check-in: 32ccf3ae user: dan tags: threads | |
| 14:28 | Fix a problem in the sorter causing it to return spurious SQLITE_NOMEM errors when configured to use memsys3 or memsys5. check-in: 3a66c4e1 user: dan tags: threads | |
| 13:53 | Get SQLITE_MUTEX_STATIC_APP1 and _APP2 working for the debugMutex implementation. check-in: f49ba1c9 user: drh tags: threads | |
| 12:00 | Add two new static mutexes, SQLITE_MUTEX_STATIC_APP1 and _APP2, for use by the application program. First intended use is in test programs for the memory allocation logic where one does not want to allocating a _FAST or _RECURSIVE mutex since that would involve using the memory allocation system under test. check-in: 13686035 user: drh tags: threads | |
| 11:22 | Add the SQLITE_DEFAULT_WORKER_THREADS compile-time option. Fix a NULL-pointer dereference that can occur following OOM. check-in: e0dea89b user: drh tags: threads | |
|
2014-05-02
| ||
| 22:39 | Enhance the Win32 VFS I/O retry logic. check-in: 47605043 user: mistachkin tags: trunk | |
| 21:42 | Merge updates from trunk. Closed-Leaf check-in: 598a3875 user: mistachkin tags: winIoRetry | |
| 21:38 | Merge updates from trunk. check-in: c4d1d8a0 user: mistachkin tags: winHdr | |
| 19:12 | Fix typo in Windows makefile. Make sure the WaitForSingleObjectEx system call is always available. check-in: d7ed529f user: mistachkin tags: threads | |
| 18:46 | Do not run the vdbeRecordCompareDebug() assert if pKeyInfo->db is NULL since in that case there would be no way to check for a memory allocation failure. check-in: 63ed2d6a user: drh tags: threads | |
| 18:05 | Merge orderby-planning with this branch. check-in: d9549de3 user: dan tags: threads | |
| 17:33 | Simplify assert() statements used to verify correct operation of record comparison routines. check-in: 3300d62d user: drh tags: orderby-planning | |
| 17:12 | Fix some broken asserts in btree.c and vdbeaux.c that may fail following an OOM error. check-in: e15f4706 user: dan tags: threads | |
| 16:22 | Failure to extend a temp file for use with mmap() in vdbesort.c is benign. check-in: d4d39638 user: drh tags: orderby-planning | |
| 16:03 | Remove a faulty assert() from vdbesort.c. check-in: d95d68aa user: dan tags: threads | |
| 15:25 | Fix a faulty assert() statement. check-in: 9196ce40 user: drh tags: orderby-planning | |
| 14:54 | Fix a broken test case in fuzz.test. check-in: faa46935 user: dan tags: trunk | |
| 13:09 | Merge latest trunk enhancements and fixes into the orderby-planning branch. check-in: 84862d3a user: drh tags: orderby-planning | |
| 00:09 | Add a comment explaining why WhereLoop cost adjustments are omitted for skip-scan loops. check-in: 3bc43594 user: drh tags: trunk | |
|
2014-05-01
| ||
| 20:26 | Fix an obscure problem to do with temp register allocation that could occur if more than one simple SELECT within a compound SELECT uses a partial sort. check-in: 427409ae user: dan tags: trunk | |
| 20:24 | Add #ifdefs for test coverage. Add a testcase(). check-in: be2702ce user: drh tags: trunk | |
| 10:19 | Update a test case in wal2.test that explicitly corrupts a checksum in the wal file to account for the fact that the first byte of said checksum may initially be 0xFF. check-in: 2b935bde user: dan tags: trunk | |
| 01:49 | Take out the special handling of nolock=true in os_win.c and add it to pager.c, so that it works for all VFSes. Add the pPager->noLock boolean for clarity. check-in: 725c1c14 user: drh tags: win32-none | |
| 01:20 | Avoid unnecessary xUnlock operations on temp file. check-in: 1829c38c user: drh tags: win32-none | |
| 01:13 | Add the immutable=TRUE query parameter and SQLITE_IOCAP_IMMUTABLE, either of which prevents locking of the database and omits tests for existance of journal files. check-in: 71f152c8 user: drh tags: win32-none | |
|
2014-04-30
| ||
| 20:32 | Merge in all recent changes and enhancements from trunk. check-in: 84243f84 user: drh tags: win32-none | |
| 18:11 | Fix a problem in calculating the costs of "OR" scans. check-in: 9bbca48b user: dan tags: trunk | |
| 15:22 | Modify the way the costs of various query plans are estimated. If the user supplies a likelihood() value (or equivalent) on an indexed WHERE constraint, use it to estimate the number of index rows visited. check-in: 90e36676 user: dan tags: trunk | |
| 15:00 | Add text to the header comment of whereLoopAddBtree() describing how the costs of various b-tree loops are estimated. Closed-Leaf check-in: 05e6e16c user: dan tags: experimental-costs | |
| 14:53 | Update a couple of test cases to account for the fact that this branch prefers an index scan and partial sort over a full-table scan and full external sort. check-in: 9b975bf3 user: dan tags: experimental-costs | |
| 14:47 | Fix a couple of out-of-date comments in where.c. check-in: eefeda32 user: dan tags: experimental-costs | |
| 14:22 | Improved rendering of LogEst values corresponding to real values near 0.0 in the tool/logest.c utility program. check-in: 32910c8c user: drh tags: experimental-costs | |
| 13:19 | Fix long-standing typos in comments. check-in: b9f91317 user: drh tags: experimental-costs | |
|
2014-04-29
| ||
| 19:01 | Test that the default values used when sqlite_stat1 data is not available are calculated correctly. Fixes for the same. check-in: e2d42f90 user: dan tags: experimental-costs | |
| 16:46 | Merge trunk changes into this branch. check-in: d74299f0 user: dan tags: experimental-costs | |
| 16:10 | Ignore likelihood() values on indexed IPK lookups. check-in: 5bb7757a user: dan tags: experimental-costs | |
| 12:01 | Fix a test case so that it updates sqlite_stat1 consistently. check-in: 2dc5a0b5 user: dan tags: experimental-costs | |
|
2014-04-28
| ||
| 20:11 | Do not reduce the number of rows scanned at all for "IS NOT NULL" constraints. Fix a bug in calculating the number of rows visited by scans of partial indicies. check-in: a8ae93f0 user: dan tags: experimental-costs | |
| 19:34 | The trunk assumes that an open range constraint on an indexed term (col>?) term matches 1/4 of the indexed rows, and that a closed constraint (col BETWEEN ? AND ?) matches 1/64. Change this branch to do the same. check-in: 4047ac75 user: dan tags: experimental-costs | |
| 18:02 | Merge all recent trunk enhancements and fixes into the sessions branch. check-in: e158812c user: drh tags: sessions | |
| 17:56 | Add the sqlite3_rtree_query_callback() API to the RTree virtual table. (Cherrypick from the sessions branch.) check-in: af2cbe64 user: drh tags: trunk | |
| 17:51 | Add the sqlite3_rtree_query_callback() API to the RTree virtual table. check-in: 3dca2809 user: drh tags: sessions | |
| 15:11 | Update unordered.test to take into account for the fact that SQLite now prefers a full-table scan over a non-covering index scan that visits a large percentage of the table rows. check-in: 20f468df user: dan tags: experimental-costs | |
| 12:08 | Add an extra column to a table in analyze9.test to give the planner a little more reason to select an index. check-in: 1b95544f user: dan tags: experimental-costs | |
| 10:00 | Update test script analyze3.test to account for the fact that SQLite now prefers a full-table scan over a non-covering index scan that visits a large percentage of the table rows. check-in: 35f46a55 user: dan tags: experimental-costs | |
| 09:35 | Modify internal function whereLoopAdjustCost() so that it does not prefer a skip-scan over a regular index scan even if the regular scan uses a subset of the WHERE terms used by the skip-scan. check-in: 88a5758d user: dan tags: experimental-costs | |
| 08:49 | Fix an error in estimating of the number of rows visited by a range scan. check-in: d491de62 user: dan tags: experimental-costs | |
|
2014-04-26
| ||
| 20:21 | Fix an sqlite3_stmt_status() problem caused by recent changs on this branch. check-in: dee20409 user: dan tags: experimental-costs | |
| 19:23 | Update requirements marks to fix typos in the requirements text. No changes to code. check-in: f5a26365 user: drh tags: trunk | |
| 17:52 | Allow the xfer optimization to proceed if the DEFAULT on the very first column of the two tables is different. This is a refinement of the fix for ticket [f67b41381a]. check-in: 349f4834 user: drh tags: trunk | |
| 14:07 | Avoid transfering records between tables unless the default values for all columns are the same. Fix for [f67b41381a]. check-in: f8c4c495 user: dan tags: trunk | |
|
2014-04-25
| ||
| 20:22 | If the user provides likelihood() data for a WHERE clause term used as part of an index key, have the planner use it when calculating the expected number of rows visited by the loop. check-in: c51efaa5 user: dan tags: experimental-costs | |
| 17:37 | Add test cases to ensure correct operation of joins with a virtual table that include DISTINCT and ORDER BY clauses. Verification for ticket [388d01d4bb8f9]. check-in: 5ada136f user: drh tags: trunk | |
| 16:29 | Enhance the sqlite3_rtree_query_info object to report on the number of elements in the priority queue at each level. Closed-Leaf check-in: f7dad408 user: drh tags: rtree-enhancements | |
| 15:01 | Store values loaded from the stat1 table as logarithmic values in memory. check-in: 1bd74c49 user: dan tags: experimental-costs | |
| 14:42 | Make sure ORDER BY clauses on joins that involve virtual tables and that have a DISTINCT clause work correctly. This is a candidate fix for ticket [388d01d4bb8f9]. Test cases for that ticket will be checked in separately. check-in: 17113812 user: drh tags: trunk | |
| 12:35 | When VDBE_PROFILE is enabled, ignore negative opcode times, which sometimes occur, perhaps due to context swaps. check-in: 4e88042f user: drh tags: trunk | |
|
2014-04-24
| ||
| 20:04 | Changes to the way the planner calculates the costs of various table and index scans. Some test cases still failing. check-in: c5a6ec0a user: dan tags: experimental-costs | |
| 16:25 | Improved header comment on the vdbesort.c module. No changes to code. check-in: bf09ce24 user: drh tags: orderby-planning | |
| 15:06 | Reopen the orderby-planning branch and merge in the latest trunk enhancements and fixes. check-in: 6077ddcd user: drh tags: orderby-planning | |
| 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 | |
| 12:28 | Improvements to comments. Store some extra information in SqliteThread that is useful for debugging. check-in: 9fb5e212 user: drh tags: threads | |
|
2014-04-23
| ||
| 12:57 | Merge all recent trunk changes into the threads branch. check-in: e2c9f71a user: drh tags: threads | |
| 12:00 | Enhancements to the date and time functions so that they optionally support a 5-digit year. Not sure we want to include this in trunk. Saved in a branch for future reference. Closed-Leaf check-in: 2029a396 user: drh tags: five-digit-year | |
|
2014-04-22
| ||
| 19:42 | Change from using the win32-none VFS to just a query parameter. check-in: ffceacf6 user: drh tags: win32-none | |
| 19:34 | Add some OSTRACE calls for consistency. check-in: be292d55 user: mistachkin tags: win32-none | |
| 19:30 | Add the win32-none VFS which omits rollback-journal locking. check-in: 03e3c5a8 user: drh tags: win32-none | |
|
2014-04-21
| ||
| 18:13 | Fix the generation of sqlite3_rtree_query_info.iRowid and add test cases to verify that it is fixed. check-in: eba95ead user: drh tags: rtree-enhancements | |
| 18:00 | Preliminary changes to support building VSIX packages for Windows 8.0 and Windows Phone 8.0 using Visual Studio 2013. check-in: 3bf97c81 user: mistachkin tags: vsixWinPhone81 | |
| 15:53 | Be sure to initialize the sqlite3_rtree_query_info.iRowid field for the leaves of the R-Tree when doing a query callback search. check-in: 43946938 user: drh tags: rtree-enhancements | |
| 15:21 | Fix an off-by-one error in setting the "iLevel" field of the sqlite3_rtree_query_info structure passed into the RTree query callback. check-in: d708f159 user: drh tags: rtree-enhancements | |
| 13:36 | Comment tweaks on the test case for the [b75a9ca6b0] bug fix. check-in: 65d2544a user: drh tags: trunk | |
| 13:21 | Avoid discarding an ORDER BY clause in the case where an identical GROUP BY clauses uses an index to group, but not sort, the rows. Fix for [b75a9ca6b0]. check-in: de9a490f user: dan tags: trunk | |
|
2014-04-18
| ||
| 22:20 | Clean up the proper-subset cost adjustment logic to make it more compact and easier to read and so that full branch test coverage is more easily obtained. check-in: 9a5d38c7 user: drh tags: trunk | |
| 13:57 | Add to speedtest1.c the --threads option for setting the SQLITE_CONFIG_WORKER_THREADS configuration. check-in: 5fce40c4 user: drh tags: threads | |
| 13:40 | Fix harmless compiler warnings. check-in: f8f72ecb user: drh tags: threads | |
| 12:38 | Merge recent trunk changes into the threads branch. check-in: 8729aa3e user: drh tags: threads | |
| 01:37 | Further improvements to the RTREE_DECODE_COORD() method, to take advantage of known processor byte orders when available. This makes the code 3% faster, according to valgrind. Also add test cases to make sure the on-disk representation is correct. check-in: 6f3e94f4 user: drh tags: rtree-enhancements | |
| 01:14 | Merge the latest changes from sessions. check-in: d9eef5b0 user: drh tags: rtree-enhancements | |
| 01:10 | Merge recent trunk changes into sessions. check-in: 95e77efe user: drh tags: sessions | |
| 00:49 | Add the SQLITE_RUNTIME_BYTEORDER compile-time option to force SQLite to check the processor byte-order at run-time. Add additional compile-time byte order checks for ARM, PPC, and SPARC. check-in: 2c536387 user: drh tags: trunk | |
| 00:08 | Preliminary changes to support building VSIX packages for Windows Phone 8.1. check-in: a1b2f28b user: mistachkin tags: vsixWinPhone81 | |
| 00:06 | Add the SQLITE_TESTCTRL_BYTEORDER test control to interrogate SQLite's notion of the processor byte order and whether the byte order is known at compile-time or determined at run-time. check-in: 9c696196 user: drh tags: trunk | |
|
2014-04-17
| ||
| 23:23 | Performance optimization on byte-swapping in R-Tree. check-in: 444084fd user: drh tags: rtree-enhancements | |
| 15:34 | More test cases with very long priority queues. check-in: 71692aa9 user: drh tags: rtree-enhancements | |
| 14:52 | Test cases and bug fixes for the sqlite3_rtree_query_callback() mechanism. check-in: 1ccaaed6 user: drh tags: rtree-enhancements | |
| 13:15 | Refactor the constraint checking logic in RTree. The new-style constraint callbacks created by sqlite3_rtree_query_callback() are now hooked up from end to end, though still untested. check-in: 32a13870 user: drh tags: rtree-enhancements | |
| 08:57 | Fix build problems in vdbesort.c. Add further comments and changes to make things easier to understand. check-in: 12b190db user: dan tags: threads | |
|
2014-04-16
| ||
| 21:02 | Performance optimization on nodeGetCell() in R-Tree. check-in: 5d20ff9e user: drh tags: rtree-enhancements | |