SQLite

Check-in [e15e100660]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Avoid unnecessary loads of columns in an aggregate query that are not within an aggregate function and that are not part of the GROUP BY clause.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: e15e100660d290249ef235e7a8927b88296e56ec0f80ec626eecbd542adc7633
User & Date: drh 2018-06-05 23:21:11.926
Context
2018-06-05
23:51
Update the version number to 3.25.0 for the next development cycle. (check-in: 7598236c35 user: drh tags: trunk)
23:21
Avoid unnecessary loads of columns in an aggregate query that are not within an aggregate function and that are not part of the GROUP BY clause. (check-in: e15e100660 user: drh tags: trunk)
20:04
Calculate non-aggregate expressions in the SELECT list of an aggregate query that does not use min() or max() once per group, instead of once per row visited. (Closed-Leaf check-in: dce2dfbe15 user: dan tags: exp-agg-opt)
13:43
Update and correct the documentation on the OP_OpenRead, OP_OpenWrite, and OP_ReopenIdx opcodes. No code changes other than the addition of an assert(). (check-in: 8a0b730d0e user: drh tags: trunk)
Changes
Unified Diff Side-by-Side Diff Patch
Changes to src/select.c.
Changes to test/aggnested.test.
Changes to test/e_select.test.
Changes to test/select5.test.