Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Changes In Branch having-where-optimization Excluding Merge-Ins
This is equivalent to a diff from d7bb79ed to 8424492e
|
2017-05-02
| ||
| 16:55 | Move terms of the HAVING clause that reference only columns in the GROUP BY clause over to the WHERE clause, resulting in a faster query plan. (check-in: 47cbb471 user: drh tags: trunk) | |
| 16:46 | Additional comments on the sqlite3ExprIsConstantOrGroupBy() routine. No code changes. (Closed-Leaf check-in: 8424492e user: drh tags: having-where-optimization) | |
|
2017-05-01
| ||
| 19:53 | Remove an unnecessary branch. (check-in: a3317959 user: drh tags: having-where-optimization) | |
|
2017-04-29
| ||
| 20:53 | Automatically transfer terms from the HAVING clause to the WHERE clause of an aggregate query in cases where the result of evaluating the term depends only one one or more of the GROUP BY expressions (and on no other inputs). (check-in: 5375a3ce user: dan tags: having-where-optimization) | |
| 18:02 | Improvements to opcode documentation in the bytecode engine. No changes to code. (check-in: e54c9f8d user: drh tags: trunk) | |
| 15:27 | Evaluate WHERE clause terms that reference only the index before evaluating terms that require the table, and thereby avoid seeking the table row if index terms are false. This is called the "push-down" optimization in the MySQL world, we are told. Do not confuse with WHERE-clause push-down. (check-in: d7bb79ed user: drh tags: trunk) | |
| 14:56 | Minor size and performance improvements to the push-down optimization. (Closed-Leaf check-in: 91dfb61a user: drh tags: pushdown-optimization) | |
|
2017-04-26
| ||
| 17:21 | Add new test file cachespill.test. (check-in: 2d0b6431 user: dan tags: trunk) | |
Changes to src/expr.c.
Changes to src/select.c.
Changes to src/sqliteInt.h.
Added test/having.test.