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

Tom Lane <tgl@sss.pgh.pa.us>

Commit: e0badf67e9cd409ea35f2c2d5e3ca36ffecb47d7
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2012-08-20T17:24:58Z
Releases: 9.2.0
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

Files

PathChange+/−
contrib/pg_trgm/expected/pg_trgm.out modified +12 −0
contrib/pg_trgm/sql/pg_trgm.sql modified +2 −0
contrib/pg_trgm/trgm_op.c modified +25 −19