diff options
| author | David Rowley <drowley@postgresql.org> | 2024-01-22 22:45:02 +1300 |
|---|---|---|
| committer | David Rowley <drowley@postgresql.org> | 2024-01-22 22:45:02 +1300 |
| commit | 2bcf0785cd1080b85f0d2ccd595b195970730491 (patch) | |
| tree | 68719a93e0ac9fda90c7af1ae3a7ab605eb7b598 /contrib/postgres_fdw/sql/postgres_fdw.sql | |
| parent | b199eb89c67d737ced55721590f7fc8ff585e837 (diff) | |
| download | postgresql-2bcf0785cd1080b85f0d2ccd595b195970730491.tar.gz postgresql-2bcf0785cd1080b85f0d2ccd595b195970730491.zip | |
Re-disallow Memoize for parameterized nested loops with join filters
This was previously fixed in 9e215378d but got broken again as a result
of 2489d76c4. It seems that commit causes ppi_clauses to contain
duplicate clauses and it's no longer safe to check the list_length of
that list to determine if there are join conditions other than what's
mentioned in ppi_clauses.
Here we adjust the check to count the distinct rinfo_serial mentioned in
ppi_clauses. We expect that extra->restrictlist won't have duplicate
rinfo_serials.
Reported-by: Amadeo Gallardo
Author: Richard Guo
Discussion: https://postgr.es/m/CADFREbW-BLJd7-a5J%2B5wjVumeFG1ByXiSOFzMtkmY_SDWckTxw%40mail.gmail.com
Backpatch-through: 16, where 2489d76c4 was introduced.
Diffstat (limited to 'contrib/postgres_fdw/sql/postgres_fdw.sql')
0 files changed, 0 insertions, 0 deletions