Re: BUG #19720: pg_trgm GiST index corruption from gtrgm_union() dropping SIGNKEY

From: Ayush Tiwari <ayushtiwari(dot)slg01(at)gmail(dot)com>
To: Nate Clark <natec425(at)gmail(dot)com>
Cc: Kirill Reshke <reshkekirill(at)gmail(dot)com>, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #19720: pg_trgm GiST index corruption from gtrgm_union() dropping SIGNKEY
Date: 2026-10-05 03:37:02
Message-ID: CAJTYsWWQYfmzYwb1ruDeYbVb5g9FCOvx_VDNs8EhHPaPfBbpoA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi,

On Sat, 26 Sept 2026 at 19:56, Nate Clark <natec425(at)gmail(dot)com> wrote:
>
> > Your analysis also looks correct for me, would you share a patch with
> > result->flag = ALLISTRUE; -> result->flag |= ALLISTRUE; ?
>
> Of course. I've attached a patch with that one line change.

Thanks for the report and patch. The fix looks right to me.

I wonder if we should add a regression test for this too. Since we
have the reproducer above, I'll defer to the committer on whether to
include one..

Marking it RfC.

Regards,
Ayush

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Paquier 2026-10-05 03:49:46 Re: BUG #19730: PostgreSQL `pg_backup_start` accepts newlines in the backup label, producing an unrestorable `backup
Previous Message shihao zhong 2026-10-05 02:39:02 Re: BUG #19732: first_value/last_value/nth_value return NULL with EXCLUDE TIES when the current row is outside its f