Assert !bms_overlap(joinrel->relids, required_outer)

From: Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Assert !bms_overlap(joinrel->relids, required_outer)
Date: 2023-06-27 04:05:43
Message-ID: CAJKUy5g2uZRrUDZJ8p-=giwcSHVUn0c9nmdxPSY0jF0Ov8VoEA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

The attached query makes beta2 crash with attached backtrace.
Interestingly the index on ref_6 is needed to make it crash, without
it the query works fine.

--
Jaime Casanova
Director de Servicios Profesionales
SYSTEMGUARDS - Consultores de PostgreSQL

Attachment Content-Type Size
backtrace.txt text/plain 18.9 KB
query_to_crash.sql application/sql 1.1 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2023-06-27 04:09:31 Re: ReadRecentBuffer() doesn't scale well
Previous Message Peter Geoghegan 2023-06-27 03:44:27 Re: ReadRecentBuffer() doesn't scale well