]> git.ipfire.org Git - thirdparty/sqlite.git/commit
projects / thirdparty / sqlite.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(merge: 8d5cee1 ab31400)
Move terms of the HAVING clause that reference only columns in the GROUP BY
authordrh <drh@noemail.net>
Tue, 2 May 2017 16:55:07 +0000 (16:55 +0000)
committerdrh <drh@noemail.net>
Tue, 2 May 2017 16:55:07 +0000 (16:55 +0000)
commita1f5c0c90bd9d4c787fb4475329fef3b15ed3845
treef0fb45a0c494d313f3b24e207bc449e7a5c73348tree
parent8d5cee166e040eadb05ca68411c8919728c429b1commit | diff
parentab314001b80737422a101b6600a0531fb867f38dcommit | diff
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.

FossilOrigin-Name: 47cbb471d056c8e1834a5ca72491404a3bfb273b5ff7bdd84b98d263938ea874
manifest diff1 | diff2 | blob | history
manifest.uuid diff1 | diff2 | blob | history
src/select.c diff1 | diff2 | blob | history
Mirror of https://github.com/sqlite/sqlite.git