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) Not processed
Stats (from CFBot) Unknown
Tags Bugfix
Created 2026-10-02 04:29:51
Last modified 2026-10-02 04:29:51 (1 hour ago)
Latest email 2026-09-27 15:08:08 (4 days 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-09-27 15:08:08 by Palak Chaturvedi <chaturvedipalak1911 at gmail.com>
Latest 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>
    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