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-0001Iw-Fp@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
------
master

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

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