`*` should not expand to aggregate columns about materialize

[jamii]

SELECT DISTINCT * FROM tab0 AS cor0 GROUP BY cor0.col0, cor0.col1, cor0.col0, cor0.col2
InferenceFailure { expected_types: [Integer, Integer, Integer], inferred_types: [Int64, Int64, Int64, Int64] }

Similarly, this query repeated cor0.col0 twice in the output because it is used twice in the GROUP BY, but * should only pick things from before group by / aggregate.

[jamii]

These rules are ridiculous:

postgres=# select * from foo;
 a | b 
---+---
 1 | 7
(1 row)

postgres=# select * from foo group by a;
ERROR:  column "foo.b" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: select * from foo group by a;
               ^

postgres=# select * from foo group by a,b;
 a | b 
---+---
 1 | 7
(1 row)

postgres=# select * from foo group by a,a,b;
 a | b 
---+---
 1 | 7
(1 row)

postgres=# select * from foo group by a,a+1,b;
 a | b 
---+---
 1 | 7
(1 row)

postgres=# select a+1 from foo group by a,a+1;
 ?column? 
----------
        2
(1 row)

postgres=# select a+2 from foo group by a,a+1;
 ?column? 
----------
        3
(1 row)

postgres=# select a+2 from foo group by a+1;
ERROR:  column "foo.a" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: select a+2 from foo group by a+1;
               ^

postgres=# select (a+1)+1 from foo group by a+1;
 ?column? 
----------
        3
(1 row)