Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 descendants and 100 ancestors of [1559f4c4]
|
2016-09-09
| ||
| 20:26 | Make the new file test_delete.c portable to MSVC on Windows. Closed-Leaf check-in: 0e3ace39 user: mistachkin tags: test_delete | |
| 20:23 | Remove an unnecessary call to sqlite3VdbeMemExpandBlob() when casting to text. check-in: 19e2e595 user: drh tags: trunk | |
| 20:00 | Add new file test_delete.c, containing test code for deleting an sqlite database. check-in: fb0b95e9 user: dan tags: test_delete | |
| 19:33 | Performance improvements to the comparison operators in the bytecode engine. check-in: 37803b19 user: drh tags: trunk | |
| 15:12 | Fix a out-of-order variable declaration for some compile-time configurations. check-in: 6ac932c9 user: drh tags: trunk | |
| 13:23 | In releasetest.tcl, the --srcdir option is automatic, so no need to mention it in the --help output. check-in: 2bdd838e user: drh tags: trunk | |
| 13:17 | Fix an obsolete comment in the releasetest.tcl source code. check-in: afaaa276 user: drh tags: trunk | |
| 12:29 | In releasetest.tcl: Improved testing for uncommitted changes. If uncommitted changes are seen, exit immediately unless the --force option is used. check-in: 9a14e6c4 user: drh tags: trunk | |
|
2016-09-08
| ||
| 23:12 | Issue a warning and prompt the user to continue if the releasetest.tcl script is run in a checkout with uncommitted changes. check-in: 30e917ff user: drh tags: trunk | |
|
2016-09-07
| ||
| 19:54 | Add support for row-value comparisons, including IN operators, and row-value updates in the UPDATE statement. check-in: ddb5f055 user: drh tags: trunk | |
| 19:37 | Fix a problem handling expressions like "(a, b) IN (SELECT ... ORDER BY 1, 2)" when there is an index on "a" but not "b". Closed-Leaf check-in: 7f2c5c9e user: dan tags: rowvalue | |
| 13:30 | Simplify the affinity handling logic in codeAllEqualityTerms(). Logically the same, just a little easier to read and understand. check-in: bbab9621 user: drh tags: rowvalue | |
| 13:12 | Merge fixes from trunk. check-in: 193f036c user: drh tags: rowvalue | |
|
2016-09-06
| ||
| 19:08 | Remove obsolete vector-IN test cases. Fix a bad testcase() macro. check-in: ab3f8f19 user: drh tags: rowvalue | |
| 18:51 | Fix corer cases of vector IN operators where the RHS is a compound SELECT that includes an ORDER BY clause. check-in: 8329ac6f user: drh tags: rowvalue | |
| 17:21 | Remove an unnecessary branch from expr.c. check-in: 7cc9746c user: dan tags: rowvalue | |
| 17:13 | Avoid unnecessary memory allocations for aiMap in codeEqualityTerm(). check-in: 70319c3d user: drh tags: rowvalue | |
| 16:53 | Avoid a NULL pointer deref in codeAllEqualityConstraints() following an OOM. check-in: c6e528c1 user: drh tags: rowvalue | |
| 16:33 | Simplify the fix in commit [7d9bd22c]. check-in: bd5a3420 user: dan tags: rowvalue | |
| 15:25 | Fix the header comment on codeEqualityTerm(). check-in: b7e710e4 user: drh tags: rowvalue | |
| 14:58 | Fix a problem handling (a, b) IN (SELECT ...) expressions when there is an index on just one of "a" or "b". check-in: 231c72d9 user: dan tags: rowvalue | |
| 14:37 | Enhance the sqlite3GetTempRange() and sqlite3ReleaseTempRange() internal routines so that they use sqlite3GetTempReg() and sqlite3ReleaseTempReg() when nReg==1. check-in: 4071da2f user: drh tags: rowvalue | |
| 12:04 | Fix a typo in a comment in expr.c. check-in: 288e934f user: dan tags: rowvalue | |
|
2016-09-05
| ||
| 22:50 | Simplified logic to extract a column from a row value. check-in: e8f105c3 user: drh tags: rowvalue | |
| 19:57 | Fix an assert() so that it does C-compiler does not combine an assert() conditional with a production code conditional and thereby confuse the mutation testing script. check-in: 2fa5288a user: drh tags: rowvalue | |
| 15:02 | Simplifications to the SQLITE_KEEPNULL flag on VDBE comparison operators. check-in: 96269f01 user: drh tags: rowvalue | |
| 12:12 | Do vector comparison size checking early - at name resolution time - to forestall future problems. check-in: ae127bcc user: drh tags: rowvalue | |
| 12:02 | Catch vector size mismatch problems during name resolution to avoid later problems. Closed-Leaf check-in: 56562a03 user: drh tags: early-vector-size-check | |
| 09:44 | Fix a crash that could occur under certain circumstances if the vectors on either side of a comparison operator were of a different size. check-in: 42670935 user: dan tags: rowvalue | |
|
2016-09-03
| ||
| 19:52 | Fix a problem causing the affinity of sub-select row-value elements to be ignored in some contextes. check-in: 7d9bd22c user: dan tags: rowvalue | |
| 16:24 | Merge the fuzzershell enhancement from trunk. check-in: ed206048 user: drh tags: rowvalue | |
| 15:31 | Consider the affinity of "b" when using an "a IN (SELECT b ...)" expression with an index on "a". Fix for [199df416]. check-in: f5e49855 user: dan tags: rowvalue | |
| 01:46 | Performance optimizations. check-in: f1d06c49 user: drh tags: rowvalue | |
|
2016-09-02
| ||
| 23:56 | Merge recent changes from trunk. check-in: c7271fbd user: drh tags: rowvalue | |
|
2016-08-27
| ||
| 14:13 | Merge updates from trunk. check-in: 082fd5f8 user: drh tags: rowvalue | |
| 01:41 | Fix the "Synopsis" on the OP_Lt, OP_Le, OP_Gt, and OP_Ge opcodes, which has been backwards for time out of mind. check-in: f51248dc user: drh tags: rowvalue | |
|
2016-08-26
| ||
| 22:09 | Fix a minor problem in sqlite3FindInIndex() related to rowids being used as part of the index. check-in: 829f802b user: drh tags: rowvalue | |
| 21:15 | Fix the sqlite3FindInIndex() to ensure that it always uses a prefix of the index and uses no repeated columns. Enhanced comments. check-in: b9fc89e4 user: drh tags: rowvalue | |
| 19:54 | Add an EXPLAIN QUERY PLAN line for when a index is used to implement an IN operator. check-in: 171aa833 user: drh tags: rowvalue | |
| 19:47 | Add test cases to rowvalue2.test. check-in: 078bb69e user: dan tags: rowvalue | |
| 19:31 | Enhance sqlite3FindInIndex() so that it is able to make use of the primary keys at the end of an index. check-in: 4b589fbf user: drh tags: rowvalue | |
| 18:17 | Fix a post-OOM crash in updateRangeAffinityStr(). Add several ALWAYS() macros on unreachable branches. check-in: 87d40195 user: drh tags: rowvalue | |
| 17:54 | Fix a problem with affinity changes and vector range comparisons. check-in: b34413ac user: dan tags: rowvalue | |
| 13:19 | Allow ROWID values in indexed vector comparisons. check-in: b0cc6be4 user: drh tags: rowvalue | |
| 03:42 | Comment improvements. Put ALWAYS and NEVER macros on three unreachable branches. check-in: 39761700 user: drh tags: rowvalue | |
| 01:02 | Remove an unreachable branch from sqlite3ExprAffinity() check-in: 9d96f614 user: drh tags: rowvalue | |
|
2016-08-25
| ||
| 22:31 | Merge recent changes from trunk. check-in: 5789aab8 user: drh tags: rowvalue | |
| 21:14 | Refactor the sqlite3ExprCodeIN() routine for improved maintainability. check-in: b56705ae user: drh tags: rowvalue | |
| 17:47 | Another fix in the IN-operator algorithm description. check-in: f474aeac user: drh tags: rowvalue | |
| 17:40 | Further refinement of the in-operator.md documentation. check-in: df064837 user: drh tags: rowvalue | |
| 15:46 | Improvements to IN operator code generator comments. Avoid unnecessary Copy operations on the LHS of the IN operator. check-in: b6344298 user: drh tags: rowvalue | |
| 14:23 | Corrections to the IN-operator notes. check-in: 25033ee9 user: drh tags: rowvalue | |
| 14:00 | Add notes on the implementation of the IN operator. check-in: d256b2ca user: drh tags: rowvalue | |
|
2016-08-24
| ||
| 21:54 | Simplified VDBE code for the vector NOT IN null-scanning loop. check-in: 7ae504e6 user: drh tags: rowvalue | |
| 21:24 | Improved extended comments of comparison operators when the SQLITE_STOREP2 flags is set on P5. No changes to non-debug code. check-in: bbc1b016 user: drh tags: rowvalue | |
| 18:51 | In sqlite3FindInIndex(), improve internal comments and avoid an unreachable branch. check-in: 55945fc1 user: drh tags: rowvalue | |
| 17:49 | Fix more unreachable branches. check-in: 6099c180 user: drh tags: rowvalue | |
| 15:37 | Add a NEVER() on an unreachable branch in comparisonAffinity(). check-in: 505a2f20 user: drh tags: rowvalue | |
| 12:22 | Fix a buffer overrun in the code for handling IN(...) operators when the LHS of the operator contains indexed columns or expressions. check-in: f41a0391 user: dan tags: rowvalue | |
| 00:51 | The previous OOM fix was bad. Back it out and replace it with a better one. check-in: 1e3bc369 user: drh tags: rowvalue | |
| 00:25 | Avoid a potential null-pointer dereference following an OOM. check-in: 25f6ed8d user: drh tags: rowvalue | |
|
2016-08-23
| ||
| 19:02 | Simplify the row value misuse error message. check-in: 838c50a5 user: drh tags: rowvalue | |
| 18:30 | Fix a problem with rowvalue UPDATE when the rowvalue is not the left-most and the RHS is a multi-column subquery. check-in: e149e6b9 user: drh tags: rowvalue | |
| 17:30 | Fix an uninitialized variable in CASE expression code generation. check-in: c8ffae05 user: drh tags: rowvalue | |
|
2016-08-22
| ||
| 14:30 | Fix the vector BETWEEN operator so that it only evaluates the left-most vector expression once. Add support for vector comparisons in the CASE operator. check-in: 07e69f43 user: drh tags: rowvalue | |
| 00:48 | Reinstate the mechanism in BETWEEN that avoids evaluating the first expression more than once, but fix the affinity extractor so that it works with this mechanism. The de-duplication of the first expression still does not work for vector expressions, though. check-in: 2f39987f user: drh tags: rowvalue | |
|
2016-08-20
| ||
| 22:49 | The docs promise the in "x BETWEEN y AND z" the x expression is only evaluated once. That is no longer true, and so some tests are failing. This needs to be fixed before merging to trunk. check-in: e50d264f user: drh tags: rowvalue | |
| 21:11 | Further comment enhancements. No changes to code. check-in: d4562a9e user: drh tags: rowvalue | |
| 21:02 | Clarification of code comments in expr.c. Clean up the implementations of sqlite3ExprIsVector() and sqlite3ExprVectorSize() slightly. check-in: 4fb66d65 user: drh tags: rowvalue | |
| 18:06 | Fixes for problems following OOM errors. check-in: 9041ee4a user: drh tags: rowvalue | |
| 17:00 | Do not duplicate the Expr.pLeft subtree of a TK_SELECT_COLUMN node. check-in: 8384c77e user: drh tags: rowvalue | |
| 15:01 | Fix a segfault that could occur if a query that used a vector comparison contained certain types of syntax errors. check-in: 203f07c5 user: dan tags: rowvalue | |
| 12:00 | Improvements to the vector comparison splitter in exprAnalyze(). check-in: a3ffd283 user: drh tags: rowvalue | |
| 01:06 | Improvements to comments. No code changes. check-in: 4165d20f user: drh tags: rowvalue | |
| 00:51 | Add support for vector assignments in the SET clause of an UPDATE statement. check-in: f320d47d user: drh tags: rowvalue | |
| 00:07 | Change the way TK_SELECT_COLUMN is handled so that the subquery is only generated once even if part of the vector comparison is used for indexing and the other part is now. This change also is a pathway to vector assignment in UPDATE statements. check-in: d8feea7d user: drh tags: rowvalue | |
|
2016-08-19
| ||
| 19:58 | Replace the magic number (-2) with its symbol XN_EXPR in the exprMightBeIndexed() routine. No logic changes. check-in: d4a5af69 user: drh tags: rowvalue | |
| 19:12 | Improved comments on sqlite3CodeSubquery(). No changes to code. check-in: acea4ee1 user: drh tags: rowvalue | |
| 18:40 | Show the WhereTerm.iField value on debugging output, when it is non-zero. check-in: 931c9535 user: drh tags: rowvalue | |
| 18:28 | Fix an obsolete comment on codeEqualityTerm(). No changes to code. check-in: d07be5af user: drh tags: rowvalue | |
| 15:41 | Merge recent enhancements from trunk. check-in: b1787236 user: drh tags: rowvalue | |
|
2016-08-18
| ||
| 19:04 | Fix a SQL NULL handling bug in the vector IN operator code generation. check-in: 936146b1 user: drh tags: rowvalue | |
| 18:09 | Display SELECT_COLUMN expressions in the .wheretrace debugging output. check-in: 3b27a5da user: drh tags: rowvalue | |
| 17:55 | Display VECTOR expressions in .wheretrace and .selecttrace debugging output. check-in: 157347e2 user: drh tags: rowvalue | |
| 15:36 | Since the TK_VECTOR token is not actually used by the parser, make it an extra token code added by the tool/addopcodes.tcl script during parser build. check-in: b40b202c user: drh tags: rowvalue | |
| 15:21 | Merge recent enhancements from trunk. check-in: 4768a106 user: drh tags: rowvalue | |
| 15:15 | Simplify the vector comparison code generator logic, and the resulting VDBE code. check-in: e2ad0b5d user: drh tags: rowvalue | |
|
2016-08-13
| ||
| 14:17 | Remove an unnecessary stack variable from sqlite3VdbeExec(). Closed-Leaf check-in: c54bd9c8 user: drh tags: vector-compare | |
| 13:03 | Improvements to commits. No code changes. check-in: 18f5a3be user: drh tags: vector-compare | |
| 12:37 | Fix to the vector less-than operator. All legacy tests passing now. check-in: ec70a67e user: drh tags: vector-compare | |
| 10:02 | Attempt to simplify the logic and generated code for vector comparisons. Basic comparison operators are working, but there are many indexing test failures still to be worked through. check-in: dfc028cf user: drh tags: vector-compare | |
|
2016-08-12
| ||
| 11:25 | Add VdbeCoverage() macros on newly added VDBE branch operations. check-in: 381aa731 user: drh tags: rowvalue | |
| 11:01 | Fix a post-OOM memory leak. check-in: 14009b32 user: drh tags: rowvalue | |
|
2016-08-11
| ||
| 12:31 | Merge recent changes from trunk. check-in: 959677b9 user: drh tags: rowvalue | |
| 12:01 | Fix some problems with handling "no such collation sequence" errors. check-in: 8278be06 user: dan tags: rowvalue | |
|
2016-08-09
| ||
| 05:48 | Add rowvalue5.test, which should have been part of the previous commit on this branch. check-in: ea03e219 user: dan tags: rowvalue | |
|
2016-08-08
| ||
| 20:15 | Fix some cases involving row values and virtual tables. check-in: 156a41f3 user: dan tags: rowvalue | |
| 18:42 | Fix the EXPLAIN QUERY PLAN output for row value range constaints that use an index. check-in: bb606511 user: dan tags: rowvalue | |
| 16:52 | Merge trunk changes with this branch. check-in: 0e927a7e user: dan tags: rowvalue | |
|
2016-08-03
| ||
| 18:00 | Fix a problem with estimating the number of rows visited by a query that uses a multi-column IN(SELECT...) constraint. check-in: 3c2f908f user: dan tags: rowvalue | |
| 16:39 | Fix another problem involving vector range constraints and mixed ASC/DESC indexes. check-in: 1559f4c4 user: dan tags: rowvalue | |
| 16:14 | Fix stat4-based cost estimates for vector range constraints. check-in: 18af74ab user: dan tags: rowvalue | |
|
2016-08-02
| ||
| 20:45 | Add new test file rowvaluefault.test. check-in: e496b2d6 user: dan tags: rowvalue | |
| 18:50 | Add tests and fixes for vector operations that use sub-queries with different combinations of LIMIT, OFFSET and ORDER BY clauses. check-in: 092b1c5f user: dan tags: rowvalue | |
| 17:45 | Fix SQLITE_OMIT_SUBQUERY builds. check-in: 339f85f4 user: dan tags: rowvalue | |
| 17:07 | Fix a problem with vector range constraints and mixed ASC/DESC indexes. check-in: e2ad30c8 user: dan tags: rowvalue | |
| 16:24 | Merge latest trunk changes into this branch. check-in: d468101b user: dan tags: rowvalue | |
| 16:18 | Add missing comments and make some code on this branch clearer. check-in: 6937677c user: dan tags: rowvalue | |
| 13:26 | Updates to requirements marks. No changes to code. check-in: b23c10ac user: drh tags: trunk | |
| 11:29 | Fix a problem introduced by [77948b5eceab92a7] causing duplicate calls to be made to the xSavepoint() method of virtual tables under some circumstances. check-in: e64a4173 user: dan tags: trunk | |
| 08:45 | Fix harmless compiler warnings in sqlite3_status(). check-in: 7c38a79c user: drh tags: trunk | |
|
2016-08-01
| ||
| 21:17 | Update the wordcount.c test program and add a new script "time-wordcount.sh" for additional performance testing. check-in: d8ef9f58 user: drh tags: trunk | |
| 20:14 | Fix a problem with vector range constraints involving the rowid column. And other issues. check-in: 3ef75d45 user: dan tags: rowvalue | |
| 17:06 | Fix other harmless compiler warnings. check-in: 90d2c490 user: drh tags: trunk | |
| 16:57 | Remove a duplicate typedef from loadext.c (remaining copy is in sqlite3ext.h). check-in: fd184e5a user: dan tags: trunk | |
| 16:50 | Add an extra compiler switch to loadext.test to ensure that it picks up the correct version of sqlite3.h when building a test extension. check-in: e57fa6af user: dan tags: trunk | |
| 16:37 | Fix a problem with IN(...) constraints where the LHS is a sub-select that is an aggregate query. check-in: 1f4dba87 user: dan tags: rowvalue | |
| 15:00 | Update releasetest.tcl to automatically do one round of tests with USE_STDCALL=1 when running on Windows with MSVC. check-in: a6a112de user: drh tags: trunk | |
| 14:35 | Avoid making unnecessary changes to the signatures of the sqlite3_auto_extension() and sqlite3_cancel_auto_extension() interfaces. check-in: b6ea2f21 user: drh tags: trunk | |
|
2016-07-30
| ||
| 21:02 | Fix problems with vector == comparisons and NULL values. check-in: 059d0d05 user: dan tags: rowvalue | |
| 18:54 | Fix harmless compiler warning seen with MSVC. check-in: 390a38a1 user: mistachkin tags: trunk | |
| 17:59 | Merge latest trunk with this branch. check-in: 63ae02d0 user: dan tags: rowvalue | |
| 16:39 | Remove the EP_Vector expression flag. check-in: e9d9c6d4 user: dan tags: rowvalue | |
|
2016-07-29
| ||
| 20:58 | Fix some issues with vector range constraints and the column cache. Also vector range constraints and rowid columns. check-in: 42607366 user: dan tags: rowvalue | |
| 18:12 | Change the way "(a, b) = (SELECT *)" expressions are handled in where.c if there is an index on one of the columns only. check-in: 4dfebff2 user: dan tags: rowvalue | |
| 17:36 | Using the header file 'intrin.h' requires MSVC 2005 or later. check-in: 9fae75c0 user: mistachkin tags: trunk | |
| 04:12 | For test 'shell1-5.0', disable round-trip testing for characters in the range 0xE0 to 0xEF on Linux, due to intermittent shell portability issues. check-in: 544c990a user: mistachkin tags: trunk | |
| 02:04 | Fix typo in a test file interactive output string. check-in: 4fedd790 user: mistachkin tags: trunk | |
| 01:55 | Merge additional linkage macro changes from the branch. check-in: 8b0eb22e user: drh tags: trunk | |
| 01:49 | Further refinement to the calling convention macros. check-in: 45588de3 user: drh tags: trunk | |
| 01:47 | Merge updates from trunk. check-in: 71ffa195 user: mistachkin tags: callbackConv | |
| 01:46 | Update the autoconf makefile for MSVC. check-in: 2daf2098 user: mistachkin tags: callbackConv | |
| 01:32 | Undo some unhelpful changes to skip-scan scoring that were added by the check-in [9e2b2681] that improved scoring of index scan. check-in: c7d51934 user: drh tags: trunk | |
| 01:31 | Add macro necessary for building several extensions when the __stdcall calling convention is not in use. check-in: bc8c9b55 user: mistachkin tags: callbackConv | |
|
2016-07-28
| ||
| 23:58 | Missed a couple Tcl command deletion callbacks. check-in: fc5c1876 user: mistachkin tags: callbackConv | |
| 23:54 | Use the SQLITE_TCLAPI macro in several extensions that were missed in the previous check-in. check-in: df254365 user: mistachkin tags: callbackConv | |
| 22:53 | More compiler warning fixes for GCC related to the auto-extension mechanism. check-in: b8218129 user: mistachkin tags: callbackConv | |
| 22:46 | The return type used by the auto-extension entry points is 'int', not 'void'. check-in: bf9c86c7 user: mistachkin tags: callbackConv | |
| 22:38 | Make sure all the auto-extension mechanism function signatures match up precisely. check-in: 87ba69b5 user: mistachkin tags: callbackConv | |
| 22:23 | Make the extension auto-loading mechanism work with the __stdcall calling convention. Also, fix a couple Tcl command calling conventions missed in the previous check-in. check-in: 3ea567c4 user: mistachkin tags: callbackConv | |
| 19:47 | Fix further issues with multi-column IN(...) operators. Also some error handling cases surrounding row values. check-in: cc3f6542 user: dan tags: rowvalue | |
| 19:28 | The 'sqlite3ext.h' content should be processed before being included in the amalgamation. check-in: cbe1de47 user: mistachkin tags: trunk | |
| 18:55 | Decorate all interfaces with calling convention macros. check-in: fd784887 user: drh tags: trunk | |
| 18:49 | All SQLite API functions and callbacks in the 'sqlite3ext.h' header file must be decorated with the calling convention. Closed-Leaf check-in: 97fc6e43 user: mistachkin tags: callbackConv | |
| 18:38 | Disable the authorizer callback when reparsing the schema. This avoids undesirable authorization failures following an ALTER TABLE. check-in: 805d01cd user: drh tags: trunk | |
| 18:18 | Fixup reserved function pointers in the Tcl stubs table and several macros containing Tcl function pointers. check-in: 959cd013 user: mistachkin tags: callbackConv | |
| 18:06 | Adjustments to get 'testfixture.exe' compiling with Tcl 8.6 when __stdcall is enabled. check-in: 90e89ec9 user: mistachkin tags: callbackConv | |
| 17:24 | Improvements to the way the COMPILER compile-time option is set when compiling with Clang. check-in: 81f9cf86 user: drh tags: trunk | |
| 17:11 | Make sure the SQLITE_TCLAPI macro is always defined and use it for all callback functions that must interface with the Tcl C API. check-in: f2f1323c user: mistachkin tags: callbackConv | |
| 16:09 | More work on getting the 'testfixture.exe' target to work correctly. check-in: 36b72fd6 user: mistachkin tags: callbackConv | |
| 15:38 | Modify the mksqlite3h.tcl tool to handle the syscall typedef specially. check-in: 478a84ef user: mistachkin tags: callbackConv | |
| 15:09 | Change mksqlite3h.tcl to automatically insert the SQLITE_CALLBACK calling convention macros. check-in: 11ab9c9a user: drh tags: callbackConv | |
| 14:37 | Allow the 'testfixture.exe' target to be compiled with the __stdcall calling convention. check-in: e8be3dfe user: mistachkin tags: callbackConv | |
| 13:59 | Merge latest trunk changes into this branch. check-in: 9685880f user: dan tags: rowvalue | |
| 12:52 | New test case to insure legacy CREATE TABLE syntax is supported. check-in: 6feff15c user: drh tags: trunk | |
| 04:14 | Work in progress on setting a calling convention for all callback functions. check-in: 02b8040e user: mistachkin tags: callbackConv | |
|
2016-07-27
| ||
| 19:33 | Fix some problems with multi-column IN(SELECT...) processing. check-in: 719a3b20 user: dan tags: rowvalue | |
| 19:30 | Enhance the query planner cost estimation for index scans to take into account WHERE clause terms that can be computed using only the index and that do not require looking up rows in the original table. This fixes an obscure performance regression that arose when the ORDER BY LIMIT optimization was added by check-in [bf46179d44843]. check-in: 9e2b2681 user: drh tags: trunk | |
| 19:20 | Add test cases and fix a comment. Closed-Leaf check-in: 50f8ea37 user: drh tags: improved-index-scan | |
| 18:27 | When estimating the cost of an index scan, factor in the cost savings of being able to use the index to evaluate some WHERE clause terms without having to do a table lookup. check-in: a59b5622 user: drh tags: improved-index-scan | |
| 16:03 | Initialize a variable in where.c to avoid a valgrind warning. check-in: 4d59df02 user: dan tags: trunk | |
|
2016-07-26
| ||
| 18:15 | Merge latest trunk changes into this branch. check-in: d4f3d52c user: dan tags: rowvalue | |
| 18:06 | Fix where.c handling of "IN (SELECT ...)" expressions when the SELECT returns more than one result column. Also error handling for other row value constructor cases. check-in: 061b8006 user: dan tags: rowvalue | |
| 10:46 | Ensure that the sqlite3_scrub_backup() extension creates a backup database at least as large as indicated by the database header, even if the last page of the input database is a free-list leaf. check-in: 483994a5 user: dan tags: trunk | |
| 04:49 | Copy the cache_spill setting from the main database over to the vacuum_db transient database when running a VACUUM. check-in: c0e7d98e user: drh tags: trunk | |
| 04:31 | Make sure affinity is applied correctly on lower-bound range constraints in the min() optimization. Fix for ticket [a0bac8b3c3d1bb]. check-in: b819bace user: drh tags: trunk | |
|
2016-07-25
| ||
| 22:40 | In the VACUUM command, set the cache_size of the transient vacuum_db database to be the same as the database being vacuumed. check-in: b78d9954 user: drh tags: trunk | |
| 21:11 | Fix a test case in FTS5 to make it compatible with Tcl 8.5. check-in: a495f8e7 user: drh tags: trunk | |
| 16:10 | Minor test infrastructure changes to better support SEE testing. check-in: 8dcb9d50 user: drh tags: trunk | |
| 14:40 | Add a new %ifdef to parse.y so that the build works with SQLITE_OMIT_SUBQUERY. check-in: 38a48cfb user: drh tags: trunk | |
| 14:20 | Changes to test scripts to get them all running on OpenBSD. check-in: 9e7bedee user: drh tags: trunk | |
| 12:10 | Disable the DBSTATUS_CACHE_USED_SHARED tests on mac when memsys3/5 is disabled due to differences in the allocation sizes for the Darwin memory allocator. check-in: d6f6c87c user: drh tags: trunk | |
| 12:01 | Update the vacuummem.test script so that it works on mac as well as on linux. check-in: ea7fb98b user: drh tags: trunk | |
| 11:57 | If both MEMSYS3 and MEMSYS5 are enabled, than automatically disable MEMSYS3. check-in: ccc22e14 user: drh tags: trunk | |
| 11:39 | Another attempt at getting --enable-memsysN working. check-in: 5f40e6ad user: drh tags: trunk | |
| 11:32 | Fix the --enable-memsysN options in configure so that they actually work. check-in: 67955255 user: drh tags: trunk | |
| 11:27 | Add --enable-memsys3 and --enable-memsys5 options to the configure script. check-in: 67e1dc98 user: drh tags: trunk | |
| 02:42 | Evidence marks and code reformatting for SQLITE_TRACE_STMT operation. check-in: e1e02238 user: drh tags: trunk | |
| 02:31 | Change SQLITE_TRACE_STMT to return unexpanded SQL text in the X argument. Add documentation on how and when to use sqlite3_expanded_sql(P) to compute the expanded text for legacy sqlite3_trace() compatibility. check-in: 163e1522 user: drh tags: trunk | |
| 00:05 | Fix code so that the deprecated sqlite3_trace() and sqlite3_profile() interfaces are not called when SQLITE_OMIT_DEPRECATED is used. check-in: 1c5baae3 user: drh tags: trunk | |
|
2016-07-23
| ||
| 20:27 | Use sqlite3_trace_v2() instead of sqlite3_trace() in the shell. check-in: c8e0539b user: drh tags: trunk | |
| 20:24 | Allow vector IN(SELECT ...) expressions to use an index if either all the indexed columns are declared NOT NULL or if there is no difference between the expression evaluating to 0 and NULL (as in a WHERE clause). check-in: e2fd6f49 user: dan tags: rowvalue | |
| 19:34 | Add the json_quote() function to the JSON1 extension. check-in: 269892ab user: drh tags: trunk | |
| 19:18 | Small tweak to the btree balancer for improved tree balance. check-in: 8817dedb user: drh tags: trunk | |
| 14:50 | Fix recently added tests so that they work in all configurations. check-in: d0bcaf0c user: drh tags: trunk | |
| 05:22 | Add the sqlite3_expanded_sql() and sqlite3_trace_v2() interfaces. check-in: 99a6c518 user: drh tags: trunk | |
| 04:58 | Improvements to sqlite3_trace_v2() documentation. Fix the sqlite3VdbeExpandSql() routine to respond better to OOM conditions. Closed-Leaf check-in: 0400f642 user: drh tags: sqlite3_trace_v2 | |
| 02:07 | Add requirements marks to the sqlite3_trace_v2() interface documentation. check-in: ebd388e9 user: drh tags: sqlite3_trace_v2 | |
| 00:43 | Fix sqlite3VdbeExpandSql() so that it handles OOMs by always returning NULL. check-in: 5a027fe4 user: drh tags: sqlite3_trace_v2 | |
|
2016-07-22
| ||
| 21:35 | Revise a warning fix from the previous check-in to improve clarity. Also, fix an incorrect test prefix (typo). check-in: f50a3fd6 user: mistachkin tags: trunk | |
| 21:26 | Fix harmless compiler warnings seen with MSVC. check-in: 8bb6e6fc user: mistachkin tags: trunk | |
| 20:45 | Be sure to hold the database connection mutex while calling sqlite3VdbeExpand() from within sqlite3_expanded_sql(). check-in: 527b5ba6 user: drh tags: sqlite3_trace_v2 | |
| 20:20 | Add requirements marks to the sqlite3_expanded_sql() documentation. check-in: 409535e6 user: drh tags: sqlite3_trace_v2 | |
| 17:58 | Merge latest trunk changes with this branch. check-in: 60fed5cd user: dan tags: rowvalue | |
| 10:09 | Fix a problem with upper case module names in the "sqldiff --vtab" command. check-in: 87e25fc4 user: dan tags: trunk | |
|
2016-07-21
| ||
| 18:02 | Add extra test cases to verify the fix in [64ca1a835]. check-in: bf98a2de user: dan tags: trunk | |
| 16:43 | Add new test file vacuummem.test. To test that any temporary memory used by VACUUM is freed as soon as the VACUUM has finished (not, for example, when sqlite3_close() is finally called). check-in: 1b1ad0b2 user: dan tags: trunk | |
|
2016-07-15
| ||
| 19:17 | Add the largely untested SQLITE_FTS5_NO_WITHOUT_ROWID compile time option to fts5. For building a dynamically loadable extension that does not use WITHOUT ROWID. check-in: d0a1cf1c user: dan tags: trunk | |
| 10:01 | The sqlite3_expanded_sql() function compiles, but always returns NULL, when the SQLITE_OMIT_TRACE compile-time option is used. check-in: 53c25ebe user: drh tags: sqlite3_trace_v2 | |
| 02:55 | Merge fixes from trunk. Fix the tclsqlite.test script. check-in: d2b1fa55 user: drh tags: sqlite3_trace_v2 | |
| 02:50 | Disable the CSV extension when virtual tables are disabled. check-in: ec718089 user: drh tags: trunk | |