Hello,
I've lost some time to debug a large Query with many CTE.
I couldn't really believe the error message.
it was correct after all , though surprising.
a short version to illustrate my error:
WITH t1 (a,b) AS (
SELECT
1 as x,
2 as a,
3 as b
)
select * from t1 WHERE b =0
ERROR: column reference "b" is ambiguous.
It would be nice, if extra undeclared columns would not be visible outside the CTE.
regards,
Marc Mamin