> > * Bug reported by Thom Brown > > ----------------------------- > > # EXPLAIN VERBOSE SELECT NULL FROM (SELECT people.id FROM people INNER JOIN > countries ON people.country_id = countries.id LIMIT 3) x; > > ERROR: could not open relation with OID 0 > > > > Sorry, it was a problem caused by my portion. The patched setrefs.c > > checks fdw_/custom_ps_tlist to determine whether Foreign/CustomScan > > node is associated with a certain base relation. If *_ps_tlist is > > valid, it also expects scanrelid == 0. > > However, things we should check is incorrect. We may have a case > > with empty *_ps_tlist if remote join expects no columns. > > So, I adjusted the condition to check scanrelid instead. > > Is this issue fixed by v5 custom/foreign join patch? > Yes, please rebase it.
-- NEC OSS Promotion Center / PG-Strom Project KaiGai Kohei <kai...@ak.jp.nec.com> -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
