Re: [sqlsmith] Planner crash on foreign table join

Andrew Gierth <andrew@tao11.riddles.org.uk>

From: Andrew Gierth <andrew@tao11.riddles.org.uk>

To: Andreas Seltenreich <seltenreich@gmx.de>

Cc: pgsql-hackers@postgresql.org, Simon Riggs <simon@2ndquadrant.com>

Date: 2017-04-08T07:57:04Z

Lists: pgsql-hackers

>>>>> "Andreas" == Andreas Seltenreich <seltenreich@gmx.de> writes:

 Andreas> Hi,
 
 Andreas> testing master at f0e44021df with a loopback postgres_fdw
 Andreas> installed, I see lots of crashes on queries joining foreign
 Andreas> tables with various expressions.  Below is a reduced recipe
 Andreas> for the regression database and a backtrace.

Commit ac2b095088 assumes that clauselist_selectivity is being passed a
list of RelOptInfo, but postgres_fdw is passing it a list of bare
clauses.  One of them is wrong :-)

-- 
Andrew (irc:RhodiumToad)

Commits

Improve castNode notation by introducing list-extraction-specific variants.
- 8f0530f58061 10.0 landed
- ff9398052df5 9.3.17 landed
- be182d570210 9.6.3 landed
- bcb1a27dc039 9.5.7 landed
- ba0a0f3ed9e0 9.2.21 landed
- 89a41a1b6b71 9.4.12 landed
Clean up bugs in clause_selectivity() cleanup.
- eef8c0069e4d 10.0 landed
Add newly-symlinked files to "make clean" target.
- aba696d1af9a 10.0 cited
Reset API of clause_selectivity()
- ac2b09508834 10.0 cited