Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
55 check-ins using file test/e_expr.test version 3f9e639b
|
2016-08-22
| ||
| 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) | |
|
2016-08-01
| ||
| 20:14 | Fix a problem with vector range constraints involving the rowid column. And other issues. (check-in: 3ef75d45 user: dan tags: rowvalue) | |
| 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) | |
|
2016-07-30
| ||
| 21:02 | Fix problems with vector == comparisons and NULL values. (check-in: 059d0d05 user: dan tags: rowvalue) | |
| 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) | |
|
2016-07-28
| ||
| 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) | |
| 13:59 | Merge latest trunk changes into this branch. (check-in: 9685880f user: dan tags: rowvalue) | |
|
2016-07-27
| ||
| 19:33 | Fix some problems with multi-column IN(SELECT...) processing. (check-in: 719a3b20 user: dan tags: rowvalue) | |
|
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) | |