| 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: | Whole Thread | Raw Message | 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. |