right join with partitioned table crash

Поиск
Список
Период
Сортировка
От Jaime Casanova
Тема right join with partitioned table crash
Дата
Msg-id 20210915230959.GB17635@ahch-to
обсуждение исходный текст
Ответы Re: right join with partitioned table crash  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Bossart, Nathan"
Дата:
Сообщение: Re: Deduplicate code updating ControleFile's DBState.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: EXPLAIN(VERBOSE) to CTE with SEARCH BREADTH FIRST fails