On 5/23/19 1:45 AM, David Rowley wrote: > On Thu, 23 May 2019 at 15:31, Jonathan S. Katz <jkatz@postgresql.org> wrote: >> Attached is >> v3 of the patch, along with a diff. > > Minor details, but this query is not valid: > >> WITH c AS MATERIALIZED ( >> SELECT * FROM a WHERE a.x % 4 >> ) >> SELECT * FROM c JOIN d ON d.y = a.x; > > a.x % 4 is not a boolean clause, and "a" is not in the main query, so > a.x can't be referenced there.
...that's the only gotcha I'm actually embarrassed about. Fixed.
The ON d.y = a.x still needs to be changed to ON d.y = c.x
