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 по дате отправления
От: Bossart, Nathan
Дата:
От: Tom Lane
Дата:
FAQ