]> git.ipfire.org Git - thirdparty/sqlite.git/commit
projects / thirdparty / sqlite.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: dee1cb3) | patch
Allow WHERE terms to be pushed down into sub-queries that contain window functions...
authordan <Dan Kennedy>
Mon, 22 Feb 2021 20:56:13 +0000 (20:56 +0000)
committerdan <Dan Kennedy>
Mon, 22 Feb 2021 20:56:13 +0000 (20:56 +0000)
commit903fdd483415cd3e5db94cd532ef42734aeac0c1
tree842440e24f74a751a6bc0d96517d4ecc8e3b2407tree | snapshot
parentdee1cb300648b06ea56f02de9cfe94c4eb92e79bcommit | diff
Allow WHERE terms to be pushed down into sub-queries that contain window functions, provided that the WHERE term is made up of entirely of constants and copies of expressions found in the PARTITION BY clauses of all window functions in the sub-query.

FossilOrigin-Name: dac51f303bba1a0aac7768c688b0c134deb7641062cce2071d546f2d8f241dec
manifest diff | blob | blame | history
manifest.uuid diff | blob | blame | history
src/select.c diff | blob | blame | history
src/sqliteInt.h diff | blob | blame | history
src/window.c diff | blob | blame | history
test/windowpushd.test [new file with mode: 0644] blob
Mirror of https://github.com/sqlite/sqlite.git