Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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(-)

pgsql-committers by date

Next:From: Robert HaasDate: 2012-08-20 20:32:11
Subject: pgsql: Tab complete "TABLE whatever DROP CONSTRAINT" with aconstraint
Previous:From: Heikki LinnakangasDate: 2012-08-20 16:59:15
Subject: pgsql: Don't get confused if a WAL partial record header hasxl_tot_len

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group