Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 events occurring around 6a5c59dd7e0de9b5.
|
2012-10-05
| ||
| 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 | |
| 17:44 | Merge the shared-cache related fixes from the shared-cache-fix branch to the trunk. check-in: 698ec776 user: dan tags: trunk | |
| 17:18 | Add a test for the collation-sequence/CHECK constraint problem fixed by the previous commit. Closed-Leaf check-in: 82b6aa77 user: dan tags: shared-cache-fix | |
| 16:30 | Fix a problem with shared-cache mode and CHECK constraints causing one db handle to invoke a collation sequence function registered with another. check-in: c2c776ab user: dan tags: shared-cache-fix | |
| 14:43 | Consolidate all occurrences of the "no such collation sequence" error message into a single spot. check-in: 8ea67522 user: drh tags: trunk | |
| 07:36 | Rename a tool batch file subroutine to avoid confusion about its purpose. check-in: 43155b15 user: mistachkin tags: trunk | |
|
2012-10-04
| ||
| 22:45 | Merge the 3.7.14.1 release including the fix for the LEFT JOIN problem into the sessions branch. Leaf check-in: 17644c0e user: drh tags: sessions-3.7.14 | |
| 19:41 | • Fixed ticket [d02e1406]: LEFT JOIN with an OR in the ON clause causes segfault plus 2 other changes artifact: 4a446dbe user: drh | |
| 19:37 | Version 3.7.14.1 check-in: 091570e4 user: drh tags: release, version-3.7.14.1, branch-3.7.14 | |
| 19:33 | Shared-cache mode fixes for views and virtual tables. check-in: 2b370dea user: dan tags: shared-cache-fix | |
| 16:00 | Candidate fix for ticket [d02e1406a58ea02]. check-in: 81fd941d user: drh tags: branch-3.7.14 | |
| 15:36 | Increase the version number to 3.7.14.1. The version of autoconf used is different from the previous release so there are huge differences in the generated "configure" script. check-in: 972dbd5f user: drh tags: branch-3.7.14 | |
| 15:26 | • New ticket [d02e1406] LEFT JOIN with an OR in the ON clause causes segfault. artifact: 28fef2d3 user: drh | |
| 12:10 | Yet another refactoring of ORDER BY logic in the query planner. This particular check-in works mostly, but still has a few minor issues. check-in: 8f448745 user: drh tags: qp-enhancements | |
|
2012-10-03
| ||
| 20:25 | Merge updates from trunk. check-in: 1138815c user: mistachkin tags: configReadOnly | |
| 20:20 | Add experimental sqlite3_reconfig() interface to more fully support the SQLITE_CONFIG_READONLY option. check-in: 9dc2eaa6 user: mistachkin tags: configReadOnly | |
| 18:26 | Work around an optimization issue with the MSVC compiler for ARM. check-in: 2ce625fd user: drh tags: sessions-3.7.14 | |
| 18:21 | • Edit [86633e01fec2cbc0|86633e01]: Cancel background color. artifact: d7688839 user: drh | |
| 18:20 | A branch off of the sessions branch corresponding to release 3.7.14. check-in: 86633e01 user: drh tags: sessions-3.7.14 | |
| 18:09 | Fix an out-of-order memset() that occurs before all variable declarations are finished. Also fix a line that exceeds the 80-character line length limit. check-in: ba2f492f user: drh tags: trunk | |
| 12:56 | • Edit [0f9bb90100aa304a|0f9bb901]: Mark "Closed". artifact: 19cb817f user: drh | |
| 12:56 | Update the query planner to recognize more cases where ORDER BY clauses can be optimized out. Add test cases to verify correct behavior of the ORDER BY optimization when the covering-index-scan optimization is disabled. Fix a harmless compiler warning in the TCL interface. check-in: 956e4d7f user: drh tags: trunk | |
| 12:38 | Fix a query planner problem that only occurs when covering-index-scan is disabled. Fix to tests whose output changed due to the new and more aggressive ORDER BY optimization. Closed-Leaf check-in: 0f9bb901 user: drh tags: qp-enhancements | |
| 11:11 | Fix the TCL interface so that SQL functions implemented in TCL honor the "nullvalue" setting. Also remove from the TCL interface some unused legacy UTF8 translation code left over from SQLite2. check-in: 9bf64b66 user: drh tags: branch-3.7.14 | |
| 11:02 | Fix the TCL interface so that SQL functions implemented in TCL honor the "nullvalue" setting. Also remove from the TCL interface some unused legacy UTF8 translation code left over from SQLite2. check-in: c1f10a26 user: drh tags: trunk | |
| 00:25 | Further attempts to optimize out unnecessary ORDER BY clauses. check-in: 6744d9a3 user: drh tags: qp-enhancements | |
|
2012-10-02
| ||
| 23:26 | Work around an optimization issue with the MSVC compiler for ARM. check-in: 9fab9edd user: drh tags: branch-3.7.14 | |
| 22:54 | Work around an optimization issue with the MSVC compiler for ARM. check-in: 7d301fdf user: mistachkin tags: trunk | |
| 15:19 | More lenient handling of ORDER BY optimization in joins with mixed ASC/DESC. This is a better and less restrictive fix for the problem addressed by the previous check-in. check-in: abcf6a5d user: drh tags: trunk | |
| 14:11 | Only continue an ORDER BY optimization into inner loops if the equality constraints on the inner loop match terms of an outer ordered index that are actually used by the ORDER BY clause. check-in: b0e7b4df user: drh tags: trunk | |
| 01:46 | Factor an invariant out the loop termination condition for the ORDER BY satisfied-by-index analyzer routine. check-in: 545bb336 user: drh tags: trunk | |
| 01:25 | Make sure the outer loop cursor numbers are recorded in time for them to be used by the ORDER BY optimizer. check-in: 351dc8d9 user: drh tags: trunk | |
| 01:10 | Improvements to the wheretrace output. check-in: 76b27765 user: drh tags: trunk | |
|
2012-10-01
| ||
| 20:32 | Fix harmless compiler warnings. check-in: 59c2be75 user: drh tags: trunk | |
| 20:32 | • Edit [8b5f617c2a5f0bf7|8b5f617c]: Mark "Closed". artifact: 4111ec7a user: drh | |
| 20:12 | Fix several compiler warnings seen with MSVC. Closed-Leaf check-in: 8b5f617c user: mistachkin tags: msvcWarnings | |
| 18:44 | Add SQLITE_FCNTL_BUSYHANDLER. Invoked to provide access to the busy-handler callback to custom VFS implementations. check-in: 1262d2f4 user: dan tags: trunk | |
| 17:44 | Minor changes to the query planner for improved test coverage. check-in: c12044df user: drh tags: trunk | |
| 12:44 | Omit the sqlite3GetReservedNoMutex() routine in build configurations where it is not used. check-in: f193dbb6 user: drh tags: trunk | |
| 12:16 | Make sure the size parameter to read and write VFS methods in the unix VFS do not become too big or go negative. This was not actually possible in the current code. The checks are added to make sure some future bug does not make it possible. check-in: daebe3bd user: drh tags: trunk | |
| 06:50 | Ensure that the value returned by xSectorSize() is reasonable (currently defined as between 2^5 and 2^16 bytes) before using it to calculate the amount of padding to add to a wal file. check-in: 6b4ff83b user: dan tags: trunk | |
|
2012-09-29
| ||
| 19:10 | Improved ORDER BY optimization when outer loops of a join return a single row. check-in: 62225b4a user: drh tags: trunk | |
| 15:45 | Disable the bigfile tests on Macs. check-in: d869edda user: drh tags: trunk | |
| 14:45 | Fix compiler warnings found on Lion. check-in: fd74d3d9 user: drh tags: trunk | |
|
2012-09-28
| ||
| 20:23 | Avoid calling sqlite3BtreeEnter() in a corner case where the corresponding database handle mutex (sqlite3.mutex) may not be held. This prevents a potential deadlock or crash that can occur if the backup API, shared-cache mode and SQLITE_HAVE_CODEC are all in use. check-in: 89b8c377 user: dan tags: trunk | |
| 18:13 | Modify the clearCell function to use SQLITE_CORRUPT_BKPT in the one place it was not. check-in: 472beb30 user: mistachkin tags: trunk | |
| 13:05 | Merge the latest trunk changes (especially "PRAGMA busy_timeout" and the ORDER BY query planner optimizations) into the sessions branch. check-in: 6ca8eae1 user: drh tags: sessions | |
| 12:55 | Update the sessionfault-9.1 and -9.2 tests to account for the change in version 3.7.11 in which a pending statement no longer blocks ROLLBACK but instead causes the next call on that statement to return SQLITE_ABORT. check-in: fae9eb19 user: drh tags: sessions | |
| 10:57 | Merge the latest trunk changes (PRAGMA busy_timeout and the ORDER BY query planner enhancements) into the apple-osx branch. check-in: 6a5c59dd user: drh tags: apple-osx | |
| 00:44 | Query planner enhancements to be more agressive about optimizing out ORDER BY clauses - in particular the query planner now has the ability to omit ORDER BY clauses that span multiple tables in a join. check-in: 1e874629 user: drh tags: trunk | |
|
2012-09-27
| ||
| 23:27 | Fix some corner case behavior in the new ORDER BY optimization logic. Remove the SQLITE_OrderByIdx bit from the SQLITE_TESTCTRL_OPTIMIZATIONS mask, since enabling it caused many TH3 tests to fail when the NO_OPT configuration parameter was engaged, and since there really isn't any need to turn that optimization off. The SQLITE_OrderByIdxJoin bit remains. Closed-Leaf check-in: 98b63371 user: drh tags: qp-enhancements | |
| 21:03 | Modify generation of resource header file for MSVC so that it can work from outside the working directory. check-in: 20caf80c user: mistachkin tags: trunk | |
| 19:53 | More test cases an bug fixes for the ORDER BY optimization of joins. All veryquick tests now pass. check-in: 0d573320 user: drh tags: qp-enhancements | |
| 17:31 | Test cases and bug fixes applied to the ORDER BY optimization for joins. Some test cases fail, but except for the new orderby1.test failures, all failures appear to be issues with the tests, not with the core code. check-in: 75cda864 user: drh tags: qp-enhancements | |
| 15:05 | Add more bits to the bit vector that is used to disable optimizations for built-in test. Add specific bit patterns to disable ORDER BY using an index in general and for joins. Use macros to test for bits in the disabled-optimization bit vector, in order to make the code clearer. check-in: d2fcba1e user: drh tags: qp-enhancements | |
| 14:11 | Enable ORDER BY clauses that span joins to be optimized out. check-in: c29538f9 user: drh tags: qp-enhancements | |
| 12:11 | Merge the "PRAGMA busy_timeout" change into trunk. check-in: 1a679a1e user: drh tags: trunk | |
| 12:05 | Further tweaks to the query planner logic in preparation for adding ORDER BY opt-out for joins. check-in: 53efc10a user: drh tags: qp-enhancements | |
|
2012-09-26
| ||
| 23:17 | Further refactoring of the ORDER BY related query-planning logic in order to make it easier to extend to support optimizing out ORDER BY on joins. No actual behavior changes, yet. check-in: 96496dda user: drh tags: qp-enhancements | |
|
2012-09-25
| ||
| 20:43 | Augment the WhereBestIdx structure to pass down into the query planner information that might be used to better detect ORDER BY and DISTINCT optimizations spanning multiple tables of a join. check-in: 4226e51f user: drh tags: qp-enhancements | |
| 14:29 | Pass information around between the major routines of the query planner using a single pointer to a structure rather than a long list of parameters. check-in: 1104d42e user: drh tags: qp-enhancements | |
| 12:45 | Merge updates from trunk. check-in: 4a470741 user: mistachkin tags: configReadOnly | |
|
2012-09-24
| ||
| 19:50 | Remove an unused subfunction parameter and an obsolete comment from the query planner logic in where.c. check-in: 349a55cd user: drh tags: trunk | |
| 15:30 | Change the internal sqlite3WhereBegin() to report that the ORDER BY clause is satisfied by indices using the WhereInfo.nOBSat field of the returned structure. check-in: 22989f35 user: drh tags: trunk | |
| 11:43 | Update documentation to describe the threadsafety of sqlite3_enable_shared_cache(). check-in: e081890c user: drh tags: trunk | |
|
2012-09-21
| ||
| 22:50 | Enable query planner tracing using the new (and undocumented) ".wheretrace 1" command in the command-line shell if both the shell and the core are compiled with SQLITE_DEBUG and SQLITE_ENABLE_WHERETRACE. This is not a supported API. Use for testing and debugging only. check-in: 1be4b16b user: drh tags: trunk | |
| 13:40 | Command-line shell enhancements: Added the ".print" command. Enhanced the ".width" command so that negative widths will right-justify. check-in: a1d8269d user: drh tags: trunk | |
| 00:04 | Consolidate more of the DISTINCT processing logic into a single spot in the code. Reduce the number of OP_Column operations needed to perform a WHERE_DISTINCT_ORDERED. check-in: 79e922f7 user: drh tags: trunk | |
|
2012-09-20
| ||
| 15:41 | Continuing incremental enhancements of SELECT code generation: Remove the Select.affinity field. Use SelectDest.affSdst instead. check-in: cf40b7b5 user: drh tags: trunk | |
| 14:26 | Refactoring of DISTINCT code. Change the name of the local variable "distinct" to "distinctTab". Generate cleaner code w/o unnecessary P4 and P5 values on the OP_Null for WHERE_DISTINCT_ORDERED. check-in: 0cda241a user: drh tags: trunk | |
|
2012-09-19
| ||
| 21:15 | Tighter VDBE code for the WHERE_DISTINCT_ORDERED case of DISTINCT keyword handling. check-in: 94b48064 user: drh tags: trunk | |
| 17:31 | Add comments to the WHERE_DISTINCT_* macros. No changes to code. check-in: 82320501 user: drh tags: trunk | |
| 00:35 | Merge the covering-index-scan optimization into trunk. check-in: ddd5d789 user: drh tags: trunk | |
|
2012-09-18
| ||
| 23:21 | Silence harmless compiler warning seen with SQLITE_OMIT_DEPRECATED. check-in: c5cee969 user: mistachkin tags: trunk | |
| 19:29 | Enhance IN processing to allow efficient use of indices with numeric affinities. Add test cases for IN processing that would have spotted the error in the [2be661a48023f4] check-in. check-in: 5ded9b68 user: drh tags: trunk | |
| 18:52 | • Edit [2be661a48023f414|2be661a4]: Move to branch mistake. Mark "Closed". Edit check-in comment. artifact: e54de70f user: drh | |
| 17:32 | This change generates incorrect code when there are two or more IN operators in the WHERE clause that are both used by the same index. Was: Omit an unnecessary OP_IfNull that immediately follows an OP_Rowid. Closed-Leaf check-in: 2be661a4 user: drh tags: mistake | |
| 17:08 | Enhancements to the comments on sqlite3FindInIndex(). No code changes. check-in: b1a4c394 user: drh tags: trunk | |
| 14:00 | Add the stack_usage.tcl script for analyzing the output of objdump on the amalgamation and estimating the sizes of stack frames on each function. check-in: 030013ff user: drh tags: trunk | |
| 13:20 | Update the vdbe-compress.tcl script so that it accepts variable declarations inside of #ifdef...#endif. This enhancement is needed due to the change of check-in [39866c0ede5d6ef4]. check-in: e7db056a user: drh tags: trunk | |
|
2012-09-17
| ||
| 21:24 | Make sure the WHERE_IDX_ONLY flag is not set on query plans that will not be using an index. Closed-Leaf check-in: 698b2a28 user: drh tags: fullscan-covering-index | |
| 20:44 | Add the ability to disable the covering-index-scan optimization at compile-time, start-time, or at run-time. Add test cases to check this configurability. check-in: ccb8ecc3 user: drh tags: fullscan-covering-index | |
| 19:26 | Merge recent trunk changes into the fullscan-covering-index branch. check-in: 1c0bf030 user: drh tags: fullscan-covering-index | |
| 19:12 | Remove obsolete bits from the bitvector that defines disabled optimizations in the SQLITE_TESTCTRL_OPTIMIZATIONS verb of sqlite3_test_control(). check-in: 4c21ee2d user: drh tags: trunk | |
| 18:56 | Remove an unnecessary parameter from sqlite3Utf8Read() resulting in a slight performance increase. check-in: 8b962c94 user: drh tags: trunk | |
| 17:16 | Make sure the KeyInfo.aSortOrder array is always allocated so that we never have to test for KeyInfo.aSortOrder==0 in performance-critical loops. check-in: 45793f0b user: drh tags: trunk | |
| 15:36 | Performance enhancement in the sqlite3VdbeSerialType() routine. check-in: ad298f52 user: drh tags: trunk | |
|
2012-09-15
| ||
| 18:45 | Attempt to use a covering index even on a full table scan, under the theory that the index will be smaller and require less disk I/O and thus be faster. check-in: cfaa7bc1 user: drh tags: fullscan-covering-index | |
| 13:39 | Make sure the name of rollback journal files are double-zero terminated when they are passed into the VFS. check-in: 8711a844 user: drh tags: trunk | |
| 13:29 | Factor out the code that generates a co-routine for evaluating the SELECT on the RHS of an INSERT statement so that the same code can potentially be reused in other places. check-in: a93ee09c user: drh tags: trunk | |
|
2012-09-13
| ||
| 19:59 | Improved alignment of fields in the Expr object gives an 8-byte size reduction on 64-bit machines. check-in: 6b252a0d user: drh tags: trunk | |
| 16:12 | Fix WAL capability checking in one of the test files. check-in: 0ebe7cc5 user: mistachkin tags: trunk | |
| 15:26 | Fix an unused variable warning with SQLITE_OMIT_WAL. check-in: 39866c0e user: mistachkin tags: trunk | |
| 15:24 | Improved reporting of filename translation errors in the Windows VFS. check-in: eb0f1c29 user: mistachkin tags: trunk | |
| 14:42 | Reduce the size of the Table object by 16 bytes on 64-bit machines, mostly by avoiding intermixing pointer fields with integer fields. check-in: 1cb9aedf user: drh tags: trunk | |
| 14:22 | Change boolean fields in the Column object from unsigned characters into bits in a single bit mask variable. check-in: 4163f5f1 user: drh tags: trunk | |
| 12:10 | Add the RTREE_INT_ONLY configuration parameter to the compile-time options logic. check-in: 98b971fb user: drh tags: trunk | |
| 01:51 | Allow SQLite to work on Win32 with SQLITE_OS_WINNT=0 as long as WAL is disabled. check-in: c1a85570 user: mistachkin tags: trunk | |
|
2012-09-12
| ||
| 18:45 | Add an implementation of the REGEXP operator and function. Only defined if compiled with SQLITE_ENABLE_REGEXP. Closed-Leaf check-in: 8398f77c user: drh tags: regexp | |