Re: Asymmetric partition-wise JOIN

From: Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec>
To: Aleksander Alekseev <afiskon(at)gmail(dot)com>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org, KaiGai Kohei <kaigai(at)heterodb(dot)com>, Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>
Subject: Re: Asymmetric partition-wise JOIN
Date: 2021-09-09 15:38:33
Message-ID: 20210909153833.GA6514@ahch-to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On Thu, Sep 09, 2021 at 09:50:46AM +0000, Aleksander Alekseev wrote:
> It looks like this patch needs to be updated. According to it applies but doesn't pass any tests. Changing the status to save time for reviewers.
> The new status of this patch is: Waiting on Author

Just to give some more info to work on I found this patch made postgres
crash with a segmentation fault.

Program terminated with signal SIGSEGV, Segmentation fault.
#0 0x0000556e37ef1b55 in bms_equal (a=0x7f6e37a9c5b0, b=0x7f6e37a9c5b0) at bitmapset.c:126
126 if (shorter->words[i] != longer->words[i])

attached are the query that triggers the crash and the backtrace.

Jaime Casanova
Director de Servicios Profesionales
SystemGuards - Consultores de PostgreSQL

Attachment Content-Type Size
bug.sql application/x-sql 365 bytes
gdb.txt text/plain 14.7 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Etsuro Fujita 2021-09-09 15:45:32 Re: BUG #16583: merge join on tables with different DB collation behind postgres_fdw fails
Previous Message Anton Voloshin 2021-09-09 15:17:35 Re: missing warning in pg_import_system_collations