Request a Demo
Home   >   mailing lists

Re: BUG #19720: pg_trgm GiST index corruption from gtrgm_union() dropping SIGNKEY - Mailing list pgsql-bugs

From Ayush Tiwari
Subject Re: BUG #19720: pg_trgm GiST index corruption from gtrgm_union() dropping SIGNKEY
Date
Msg-id CAJTYsWWQYfmzYwb1ruDeYbVb5g9FCOvx_VDNs8EhHPaPfBbpoA@mail.gmail.com
Whole thread
In response to Re: BUG #19720: pg_trgm GiST index corruption from gtrgm_union() dropping SIGNKEY  (Nate Clark <natec425@gmail.com>)
List pgsql-bugs
Tree view 
Hi,

On Sat, 26 Sept 2026 at 19:56, Nate Clark <natec425@gmail.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

pgsql-bugs by date:

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