yql/essentials/tests/sql/suites/pg/projection_subquery_ref_agg.sql


1
2
3
4
5
6
7
8
9
10
11
12
13

--!syntax_pg

/* custom error: Member not found: _alias_t.x */

-- TODO(YQL-20943): bad test.

SELECT (Count(x) / (
    SELECT Count(y)
    FROM (VALUES ('1')) AS t(y)
    HAVING Count(x) = Count(y)
))
FROM (VALUES (1)) AS t(x)
GROUP BY x;