right join with partitioned table crash - Mailing list pgsql-hackers

From Jaime Casanova
Subject right join with partitioned table crash
Date
Msg-id 20210915230959.GB17635@ahch-to
Whole thread Raw
Responses Re: right join with partitioned table crash
List pgsql-hackers
Hi everyone,

Here's another crash caught by sqlsmith.

"""
drop table if exists fkpart3_pk5 cascade;
drop table if exists inet_tbl;

create table fkpart3_pk5 (
    a integer not null primary key
)
partition by range (a);

create table fkpart3_pk51 partition of fkpart3_pk5
    for values from (4000) to (4500);

create table inet_tbl (
    c cidr,
    i inet
);

select
    1 as c0
from
    (select null::integer as c9,
            ref_0.a as c24
       from fkpart3_pk5 as ref_0
          ) as subq_0
          right join public.inet_tbl as sample_0 on (cast(null as cidr) = c)
where subq_0.c9 <= subq_0.c24
"""


Attached the backtrace.

-- 
Jaime Casanova
Director de Servicios Profesionales
SystemGuards - Consultores de PostgreSQL

Attachment

pgsql-hackers by date:

Previous
From: "Bossart, Nathan"
Date:
Subject: Re: Deduplicate code updating ControleFile's DBState.
Next
From: Tom Lane
Date:
Subject: Re: EXPLAIN(VERBOSE) to CTE with SEARCH BREADTH FIRST fails