Commit270eb4b

committed

Fix failure to set correct operator in window run condition

This was a simple omission in9d9c02c where the code didn't correctlyset the operator to use in the run condition OpExpr when the windowfunction was both monotonically increasing and decreasing.Bug discovered by Julien Roze, although he did not report it.Reported-by: Phil FlorentDiscussion:https://postgr.es/m/PA4P191MB160009A09B9D0624359278CFBA9F9@PA4P191MB1600.EURP191.PROD.OUTLOOK.COMBackpatch-through: 15, where9d9c02c was added

1 parent6f7e7d0 commit270eb4bCopy full SHA for 270eb4b

File tree

+29

-0

lines changed

+29

-0

lines changed

Lines changed: 1 addition & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -2306,6 +2306,7 @@ find_window_run_conditions(Query subquery, RangeTblEntry rte, Index rti,`
`2306`	`2306`	`{`
`2307`	`2307`	`*keep_original= false;`
`2308`	`2308`	`runopexpr=opexpr;`
	`2309`	`+runoperator=opexpr->opno;`
`2309`	`2310`	`break;`
`2310`	`2311`	`}`
`2311`	`2312`

Lines changed: 17 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -3646,6 +3646,23 @@ WHERE c <= 3;`
`3646`	`3646`	`3 \| sales \| 4800 \| 3`
`3647`	`3647`	`(8 rows)`
`3648`	`3648`
	`3649`	`+-- Ensure we get the correct run condition when the window function is both`
	`3650`	`+-- monotonically increasing and decreasing.`
	`3651`	`+EXPLAIN (COSTS OFF)`
	`3652`	`+SELECT * FROM`
	`3653`	`+ (SELECT empno,`
	`3654`	`+ depname,`
	`3655`	`+ salary,`
	`3656`	`+ count(empno) OVER () c`
	`3657`	`+ FROM empsalary) emp`
	`3658`	`+WHERE c = 1;`
	`3659`	`+ QUERY PLAN`
	`3660`	`+--------------------------------------------------------`
	`3661`	`+ WindowAgg`
	`3662`	`+ Run Condition: (count(empsalary.empno) OVER (?) = 1)`
	`3663`	`+ -> Seq Scan on empsalary`
	`3664`	`+(3 rows)`
	`3665`	`+`
`3649`	`3666`	`-- Some more complex cases with multiple window clauses`
`3650`	`3667`	`EXPLAIN (COSTS OFF)`
`3651`	`3668`	`SELECT * FROM`

Lines changed: 11 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -1150,6 +1150,17 @@ SELECT * FROM`
`1150`	`1150`	`FROM empsalary) emp`
`1151`	`1151`	`WHERE c<=3;`
`1152`	`1152`
	`1153`	`+-- Ensure we get the correct run condition when the window function is both`
	`1154`	`+-- monotonically increasing and decreasing.`
	`1155`	`+EXPLAIN (COSTS OFF)`
	`1156`	`+SELECT*FROM`
	`1157`	`+ (SELECT empno,`
	`1158`	`+ depname,`
	`1159`	`+ salary,`
	`1160`	`+count(empno) OVER () c`
	`1161`	`+FROM empsalary) emp`
	`1162`	`+WHERE c=1;`
	`1163`	`+`
`1153`	`1164`	`-- Some more complex cases with multiple window clauses`
`1154`	`1165`	`EXPLAIN (COSTS OFF)`
`1155`	`1166`	`SELECT*FROM`

Comments

(0)