• Tom Lane's avatar
    Test GROUP BY matching of join columns that are type-coerced by USING. · 823e739d
    Tom Lane authored
    If we have, say, an int column that is left-joined to a bigint column
    with USING, the merged column is the int column promoted to bigint.
    GROUP BY's tests for whether grouping on the merged column allows a
    reference to the underlying column, or vice versa, should know about
    that relationship --- and they do.  But I nearly broke this case with
    an ill-advised optimization, so the lack of any test coverage for it
    seems like a bad idea.
    823e739d
aggregates.sql 32.6 KB