pgsql: Fix bugs in contrib/pg_trgm's LIKE pattern analysis code. - Mailing list 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(-)