docsgood first issue
Repository metrics
- Stars
- (9,113 stars)
- PR merge metrics
- (Avg merge 6d 3h) (251 merged PRs in 30d)
Description
Taken from this awesome example from @kasiafi, I was initially confused when I ran the following query, I got the error message, Column 't2.y' cannot be resolved:
WITH
t (x, y) AS (
VALUES
(1, ARRAY['a', 'b', 'c'])
),
t2 (x, y) AS (
VALUES
(1, ARRAY['a', 'b', 'c'])
),
t3 (x, y) AS (
SELECT
x,
y_unnested
FROM
t
CROSS JOIN UNNEST (t2.y) t4 (y_unnested)
)
SELECT
*
FROM
t3;
Eventually I figured out that t3 query's FROM statement I was joining between two different tables. UNNEST (according to the docs) references relations from the left side of the join (which apparently means the tables in the join need to be the same). So I needed to be joining t2 on the left side with UNNEST(t2.y) rather than t on the left side.
t3 (x, y) AS (
SELECT
x,
y_unnested
FROM
t2
CROSS JOIN UNNEST (t2.y) t4 (y_unnested)
)
We should add a cleaned up example of this and make that requirement clearer.