From: | Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | right join with partitioned table crash |
Date: | 2021-09-15 23:09:59 |
Message-ID: | 20210915230959.GB17635@ahch-to |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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 | Content-Type | Size |
---|---|---|
failed_assert_bms_overlap.txt | text/plain | 10.5 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2021-09-15 23:40:31 | Re: EXPLAIN(VERBOSE) to CTE with SEARCH BREADTH FIRST fails |
Previous Message | Bossart, Nathan | 2021-09-15 22:49:39 | Re: Deduplicate code updating ControleFile's DBState. |