• Robert Haas's avatar
    postgres_fdw: Fix incorrect NULL handling in join pushdown. · 9e9c38e1
    Robert Haas authored
    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.
    9e9c38e1
postgres_fdw.sql 56.9 KB