]> git.ipfire.org Git - thirdparty/sqlite.git/commit
Allow queries that use "GROUP BY e1 ORDER BY e2" where e1 and e2 are identical aprt...
authordan <Dan Kennedy>
Thu, 18 Dec 2025 18:47:49 +0000 (18:47 +0000)
committerdan <Dan Kennedy>
Thu, 18 Dec 2025 18:47:49 +0000 (18:47 +0000)
commit65bc1f0ff4326da3458187ad569da19288308044
tree3eee4e43ed6c7ff07fc5e84d8329f5def99465ff
parentae66a8d760477615909d82879edef12889e54c66
Allow queries that use "GROUP BY e1 ORDER BY e2" where e1 and e2 are identical aprt from ASC/DESC sort-orders to be optimized using a single index. Also allow virtual tables to optimize DISTINCT in cases where the result-set of a query does not exactly match the ORDER BY clause.

FossilOrigin-Name: fba29a8b560d839e42c2a46421ab870da6e6ed6e15a17aa51f223e32ec3aa8ae
manifest
manifest.uuid
src/select.c
src/where.c
test/bestindex8.test
test/bestindexF.test