Horton

Prevent inlining of multiply-referenced CTEs with outer recursive refs.

Tom Lane <tgl@sss.pgh.pa.us>

View on postgr.es
Commit: 9476131278c7bfc435ad9a21fc8e981272ac0dd2
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2019-04-09T19:47:35Z
Releases: 12.0 
Prevent inlining of multiply-referenced CTEs with outer recursive refs.

This has to be prevented because inlining would result in multiple
self-references, which we don't support (and in fact that's disallowed
by the SQL spec, see statements about linearly vs. nonlinearly
recursive queries).  Bug fix for commit 608b167f9.

Per report from Yaroslav Schekin (via Andrew Gierth)

Discussion: https://postgr.es/m/87wolmg60q.fsf@news-spur.riddles.org.uk

Files

PathChange+/−
src/backend/optimizer/plan/subselect.c modified +66 −0
src/test/regress/expected/subselect.out modified +100 −0
src/test/regress/sql/subselect.sql modified +35 −0

Discussion