pg_trgm: don't lose rows in index scans with a zero similarity threshold

Edit
ID 7382
Title pg_trgm: don't lose rows in index scans with a zero similarity threshold
CI (CFBot) Summary
Stats (from CFBot) Patch version: v3, Patch count: 2, First patch: +12−1, All patches: +263−6
Tags Bugfix
Created 2026-10-02 04:29:51
Last modified 2026-10-02 04:29:51 (3 weeks ago)
Latest email 2026-10-02 18:01:07 (2 weeks ago)
Status
PG20-3 (2026-11-01 – 2026-11-30): Needs review
Target version
Authors Manuel Reyes Bravo (manu15)
Reviewers Become reviewer
Committer
Links
Emails
BUG #19701: GIN trigram index loses rows at similarity_threshold 0
First at 2026-09-19 05:17:25 by PG Bug reporting form <noreply at postgresql.org>
Latest at 2026-10-02 18:01:07 by Manu <manuelreyesbravo at gmail.com>
Latest attachment (v3-0001-Fix-out-of-bounds-read-in-pg_trgm-word-similarity.patch) at 2026-10-02 18:01:07 from Manu <manuelreyesbravo at gmail.com>
    Attachment (v3-0001-Fix-out-of-bounds-read-in-pg_trgm-word-similarity.patch) at 2026-10-02 18:01:07 from Manu <manuelreyesbravo at gmail.com> (Patch: No)
    Attachment (v2-0001-Don-t-lose-rows-in-pg_trgm-index-scans-with-a-zer.patch) at 2026-09-25 15:38:08 from Manu <manuelreyesbravo at gmail.com> (Patch: No)
    Attachment (0001-Don-t-lose-rows-in-pg_trgm-index-scans-with-a-zero-s.patch) at 2026-09-23 19:26:42 from Manu <manuelreyesbravo at gmail.com> (Patch: No)
History
When Who What
2026-10-02 04:29:51 Manuel Reyes Bravo (manu15) Attached mail thread 19701-c861a62e79bf49ce@postgresql.org
2026-10-02 04:29:51 Manuel Reyes Bravo (manu15) Created patch record
Edit