]> git.ipfire.org Git - thirdparty/sqlite.git/commit
projects / thirdparty / sqlite.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(merge: dee1cb3 34a224a)
Allow WHERE terms to be pushed down into sub-queries that contain window functions...
authordan <Dan Kennedy>
Tue, 23 Feb 2021 15:53:22 +0000 (15:53 +0000)
committerdan <Dan Kennedy>
Tue, 23 Feb 2021 15:53:22 +0000 (15:53 +0000)
commit601ec240a9c5d8086bdde0fd4d94aad3d818f098
treecb3db9e95cf675b3b5541ab7238855627ff51c51tree | snapshot
parentdee1cb300648b06ea56f02de9cfe94c4eb92e79bcommit | diff
parent34a224a13bbcfa71cb3f5d05f8f340395ada243ecommit | 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: 20689468100aed264877111367b42837ca19e63e717fed2ebd4b20b908f13178
manifest diff1 | diff2 | blob | history
manifest.uuid diff1 | diff2 | blob | history
test/windowpushd.test | diff2 | blob | history
Mirror of https://github.com/sqlite/sqlite.git