Re: Broken EXPLAIN output for SubPlan in MERGE

2024-03-21 Thread Alvaro Herrera
On 2024-Mar-12, Dean Rasheed wrote: > While playing around with EXPLAIN and SubPlans, I noticed that there's > a bug in how this is handled for MERGE. [...] > However, that isn't working properly for MERGE because the inner_plan > and inner_tlist of the corresponding deparse_namespace aren't set

Broken EXPLAIN output for SubPlan in MERGE

2024-03-12 Thread Dean Rasheed
While playing around with EXPLAIN and SubPlans, I noticed that there's a bug in how this is handled for MERGE. For example: drop table if exists src, tgt, ref; create table src (a int, b text); create table tgt (a int, b text); create table ref (a int); explain (verbose, costs off) merge into