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

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

From
Tom Lane
Date:
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(-)