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
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
------
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(-)

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