pgsql: Fix bugs in contrib/pg_trgm's LIKE pattern analysis code.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Fix bugs in contrib/pg_trgm's LIKE pattern analysis code.
Date: 2012-08-20 17:26:05
Message-ID: E1T3Vjp-0001J0-Et@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Fix bugs in contrib/pg_trgm's LIKE pattern analysis code.

Extraction of trigrams did not process LIKE escape sequences properly,
leading to possible misidentification of trigrams near escapes, resulting
in incorrect index search results.

Fujii Masao

Branch
------
REL9_1_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/874d97c2a8211cf7daaa70ee531037e69a18f4ba

Modified Files
--------------
contrib/pg_trgm/expected/pg_trgm.out | 12 +++++++++
contrib/pg_trgm/sql/pg_trgm.sql | 2 +
contrib/pg_trgm/trgm_op.c | 44 +++++++++++++++++++--------------
3 files changed, 39 insertions(+), 19 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Robert Haas 2012-08-20 20:32:11 pgsql: Tab complete "TABLE whatever DROP CONSTRAINT" with a constraint
Previous Message Heikki Linnakangas 2012-08-20 16:59:15 pgsql: Don't get confused if a WAL partial record header has xl_tot_len