EXPLAIN Verbose issue - custom_scan_tlist can directly refer CTE and Subquery - Mailing list pgsql-bugs

From Lepikhov Andrei
Subject EXPLAIN Verbose issue - custom_scan_tlist can directly refer CTE and Subquery
Date
Msg-id dfe47e78-f9c3-4f59-a345-591f7fd3ceec@app.fastmail.com
Whole thread Raw
Responses Re: EXPLAIN Verbose issue - custom_scan_tlist can directly refer CTE and Subquery
List pgsql-bugs
Hi,

While designing a CustomScan node, I got stuck into two errors:
1. "failed to find plan for CTE."
2. "failed to find plan for subquery."
After a short research, I found commit 3f50b82, which shows the problem's origins - setrefs don't change the varno of
custom_scan_tlistand can directly reference CTE or Subquery entry. In the "EXPLAIN VERBOSE" case, the deparsing routine
can'tfind dpns->inner_plan for such an entry.
 

Regards,
Andrei Lepikhov



pgsql-bugs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: BUG #17950: Incorrect memory access in gtsvector_picksplit()
Next
From: Duke Astar
Date:
Subject: Re: BUG #18082: coredump during initdb