Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Changes In Branch left-join-view Excluding Merge-Ins
This is equivalent to a diff from 6bf673767b to 3a5860d86f
|
2017-04-18
| ||
| 11:20 | Improved optimizations of views as the right operand of a LEFT JOIN. (check-in: 41c27bc0ff user: drh tags: trunk) | |
|
2017-04-14
| ||
| 19:03 | Add the TK_IF_NULL_ROW opcode to deal with non-NULL result columns in the result set of a view or subquery on the RHS of a LEFT JOIN that gets flattened. (Closed-Leaf check-in: 3a5860d86f user: drh tags: left-join-view) | |
| 17:30 | When doing a DISTINCT query using an index, try to use the index to skip ahead to the next distinct element, rather than doing a full scan of the index. (This is the "skip-ahead-distinct" optimization.) (check-in: f489b5bb6b user: drh tags: trunk) | |
| 17:18 | An initial attempt to optimize VIEWs that occur as the right operand of a LEFT JOIN. This particular check-in does not work correctly because it does not deal with the case of columns in the VIEW that return non-NULL even when all columns in the table of the VIEW are NULL because of the LEFT JOIN. (check-in: 1838a59c8a user: drh tags: left-join-view) | |
| 14:50 | Make USE_FULLWARN=1 the default for MSVC and fix harmless compiler warnings. (check-in: 6bf673767b user: mistachkin tags: trunk) | |
| 14:02 | Enhance the sqlite3TreeView() display for Expr objects so that it shows the iRightJoinTable value for Expr nodes that have the EP_FromJoin property. (check-in: 5159cb8f2b user: drh tags: trunk) | |
Changes to src/expr.c.
Changes to src/parse.y.
Changes to src/select.c.
Changes to src/treeview.c.
Changes to src/vdbe.c.
Changes to src/where.c.
Changes to tool/addopcodes.tcl.