• Tom Lane's avatar
    Add support for doing FULL JOIN ON FALSE. While this is really a rather · 90f4c2d9
    Tom Lane authored
    peculiar variant of UNION ALL, and so wouldn't likely get written directly
    as-is, it's possible for it to arise as a result of simplification of
    less-obviously-silly queries.  In particular, now that we can do flattening
    of subqueries that have constant outputs and are underneath an outer join,
    it's possible for the case to result from simplification of queries of the
    type exhibited in bug #5263.  Back-patch to 8.4 to avoid a functionality
    regression for this type of query.
    90f4c2d9
join.sql 13.8 KB