| From: | Daniel Gustafsson <daniel(at)yesql(dot)se> |
|---|---|
| To: | xinwen(at)stu(dot)scu(dot)edu(dot)cn, pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: BUG #17700: An assert failed in prepjointree.c |
| Date: | 2022-11-28 12:32:45 |
| Message-ID: | 9A80C40B-75A3-43EA-845C-6C225B6D24B4@yesql.se |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
> On 28 Nov 2022, at 10:09, PG Bug reporting form <noreply(at)postgresql(dot)org> wrote:
> When executing the following query:
>
> WITH table3 ( column34 ) AS NOT MATERIALIZED ( SELECT 1 ) SELECT 1 FROM (
> SELECT 1 FROM table3 WHERE column34 = ANY ( SELECT alias4 . column34 FROM
> table3 FULL JOIN table3 AS alias4 ON TRUE )) AS alias5 ;
The full join on the rhs of the semi join creates a PlaceHolderVar due to
table3 not being materialized. A slightly shorter repro is:
with table3 as not materialized (
select 1 as column34
)
select 1 from table3
where column34 in (
select alias4.column34 from table3
full join table3 as alias4 on true
);
--
Daniel Gustafsson https://vmware.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | PG Bug reporting form | 2022-11-28 15:27:17 | BUG #17701: Certificate verification problem when using proxies to access the server |
| Previous Message | Richard Guo | 2022-11-28 12:32:15 | Re: BUG #17700: An assert failed in prepjointree.c |