Attempt to stabilize new window agg regression test
authorDavid Rowley <drowley@postgresql.org>
Fri, 4 Aug 2023 01:27:19 +0000 (13:27 +1200)
committerDavid Rowley <drowley@postgresql.org>
Fri, 4 Aug 2023 01:27:19 +0000 (13:27 +1200)
commit7516056c584e3f7e04269f2e80835d1433e869c4
tree0424cb1c421f8f0c0e892bda9edb10d4e15448f6
parent3fd19a9b23c2906da52f3f3732dbc533477f284d
Attempt to stabilize new window agg regression test

This test was recently added in 3900a02c9.  It appears to be unstable in
regards to the join order presumably due to the relations at either side
of the join being equal in side.  Here we add a qual to make one of them
smaller so the planner is more likely to choose to hash the smaller of the
two.

Reported-by: Nathan Bossart, Tom Lane
Discussion: https://www.postgr.es/m/20230803235403.GC1238296@nathanxps13
src/test/regress/expected/window.out
src/test/regress/sql/window.sql