Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Changes In Branch reuse-subqueries Excluding Merge-Ins
This is equivalent to a diff from f856676c to 4fcdc7a2
|
2018-12-31
| ||
| 20:39 | Additional steps to help ensure that scalar subqueries are only evaluated once even if they are used in multiple places within the query. This fixes a performance regression reported on the mailing list and caused by check-in [531eca6104e41e43] which was a fix for ticket [787fa716be3a7f650c]. Think of this check-in as an improved fix for that ticket. (check-in: e1303193 user: drh tags: trunk) | |
| 20:13 | Remove an optimization that can no longer occur, being superceded by the subquery-reuse optimization. Put an assert in place of the optimization to detect if the need for this optimization ever returns. (Closed-Leaf check-in: 4fcdc7a2 user: drh tags: reuse-subqueries) | |
| 18:30 | Merge enhancements and bug fixes from trunk. (check-in: 9fb646f2 user: drh tags: reuse-subqueries) | |
| 17:58 | Small changes to the OP_OpenEphemeral opcode to improve testability. (check-in: f856676c user: drh tags: trunk) | |
| 16:36 | Fix the OP_OpenEphemeral opcode in the bytecode engine so that if it is called a second or subsequent time, it merely clears the existing table rather than creating a new one. Proposed fix for ticket [d0866b26f83e9c55e30de0821f5d]. (check-in: 4678cb10 user: drh tags: trunk) | |
Changes to ext/expert/expert1.test.
Changes to src/expr.c.
Changes to src/select.c.
Changes to src/sqliteInt.h.
Changes to src/vdbe.c.
Changes to src/vdbe.h.
Changes to src/vdbeaux.c.
Changes to src/where.c.
Changes to src/whereInt.h.
Changes to src/wherecode.c.
Changes to test/autoindex1.test.
Changes to test/bestindex3.test.
Changes to test/cost.test.
Changes to test/eqp.test.
Changes to test/join5.test.
Changes to test/rowvalue4.test.
Changes to test/tkt-80ba201079.test.
Changes to test/where7.test.
Changes to test/where9.test.
Changes to test/whereI.test.
Changes to test/with3.test.