right join with partitioned table crash
От
Jaime Casanova
Тема
right join with partitioned table crash
Дата
Msg-id
20210915230959.GB17635@ahch-to
Список
Дерево обсуждения
right join with partitioned table crash Jaime Casanova <jcasanov@systemguards.com.ec>
Re: right join with partitioned table crash Tom Lane <tgl@sss.pgh.pa.us>
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
В списке pgsql-hackers по дате отправления