Add proper regression test for the recent SRFs-in-pathkeys problem.
Tom Lane <tgl@sss.pgh.pa.us>
Add proper regression test for the recent SRFs-in-pathkeys problem. Remove the test case added by commit fac1b470a, which never actually worked to expose the problem it claimed to test. Replace it with a case that does expose the problem, and also covers the SRF-not- at-the-top deficiency repaired in 1aa8dad41. Richard Guo, with some editorialization by me Discussion: https://postgr.es/m/17564-c7472c2f90ef2da3@postgresql.org
Files
| Path | Change | +/− |
|---|---|---|
| src/test/regress/expected/incremental_sort.out | modified | +0 −12 |
| src/test/regress/expected/select_parallel.out | modified | +24 −0 |
| src/test/regress/sql/incremental_sort.sql | modified | +0 −2 |
| src/test/regress/sql/select_parallel.sql | modified | +6 −0 |
Discussion
- BUG #17564: Planner bug in combination of generate_series(), unnest() and ORDER BY 18 messages · 2022-08-01 → 2022-08-17