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-0001Iz-Fv@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_2_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/e0badf67e9cd409ea35f2c2d5e3ca36ffecb47d7

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