postgres_fdw: Fix incorrect NULL handling in join pushdown. something.* IS NOT NULL means that every attribute of the row is not NULL, not that the row itself is non-NULL (e.g. because it's coming from below an outer join. Use (somevar.*)::pg_catalog.text IS NOT NULL instead.
Ashutosh Bapat, per a report by Rushabh Lathia. Reviewed by Amit Langote and Etsuro Fujita. Schema-qualification added by me. Branch ------ master Details ------- http://git.postgresql.org/pg/commitdiff/9e9c38e15947f4f3ed478f8b70e74b55e31fe950 Modified Files -------------- contrib/postgres_fdw/deparse.c | 8 ++-- contrib/postgres_fdw/expected/postgres_fdw.out | 62 +++++++++++++++++--------- contrib/postgres_fdw/sql/postgres_fdw.sql | 5 +++ 3 files changed, 50 insertions(+), 25 deletions(-) -- Sent via pgsql-committers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers
