right join with partitioned table crash
Jaime Casanova <jcasanov@systemguards.com.ec>
From: Jaime Casanova <jcasanov@systemguards.com.ec>
To: pgsql-hackers@postgresql.org
Date: 2021-09-15T23:09:59Z
Lists: pgsql-hackers
Attachments
- failed_assert_bms_overlap.txt (text/plain)
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
Commits
-
Fix pull_varnos to cope with translated PlaceHolderVars.
- febe013cad59 12.9 landed
- e0b0d1eab48c 13.5 landed
- a21049fd3f64 15.0 landed
- 4d5b4483db1c 14.0 landed