Test GROUP BY matching of join columns that are type-coerced by USING.
Tom Lane <tgl@sss.pgh.pa.us>
Test GROUP BY matching of join columns that are type-coerced by USING. 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.
Files
| Path | Change | +/− |
|---|---|---|
| src/test/regress/expected/aggregates.out | modified | +26 −0 |
| src/test/regress/sql/aggregates.sql | modified | +15 −0 |