Confusing (wrong) error message.

[den-crane]

SELECT v.x, r.a, sum(c)
FROM (select 1 x, 2 c) AS v 
ANY LEFT JOIN (SELECT 1 x, 2 a) AS r ON v.x = r.x
GROUP BY v.x

DB::Exception: Not found column a in block. There are only columns: x, sum(c).

Expected:
DB::Exception: Column r.a is not under aggregate function and not in GROUP BY..

[den-crane]

.

[qoega]

Reproducing in 20.4
How to reproduce

SELECT
    dummy,
    x
FROM system.one
ANY LEFT JOIN
(
    SELECT
        dummy,
        materialize(1) AS x
) AS t2 USING (dummy)
GROUP BY dummy

DB::Exception: Not found column x in block. There are only columns: dummy.

Expected behavior

SELECT
    a,
    b
FROM
(
    SELECT
        number AS a,
        number + 1 AS b
    FROM system.numbers
    LIMIT 10
)
GROUP BY a

DB::Exception: Column b is not under aggregate function and not in GROUP BY.

Additional context
Correct query - any(x) instead of x

SELECT
    dummy,
    any(x)
FROM system.one
ANY LEFT JOIN
(
    SELECT
        dummy,
        materialize(1) AS x
) AS t2 USING (dummy)
GROUP BY dummy

┌─dummy─┬─any(x)─┐
│     0 │      1 │
└───────┴────────┘

[alexey-milovidov]

#31796