JBAS-1050 Avoid stripping periods from search indexes
authorBill Erickson <berickxx@gmail.com>
Mon, 2 Apr 2018 19:13:41 +0000 (15:13 -0400)
committerBill Erickson <berickxx@gmail.com>
Thu, 21 Mar 2019 19:46:23 +0000 (15:46 -0400)
commitc1495303dc627a6bd03a8e493b507b291d50e2d0
treeacc95745b66a31d34d40abd23cd081116536c768
parentbc94c3831079ffe93c6e78a0e26563da1b9df2b1
JBAS-1050 Avoid stripping periods from search indexes

Roll back an old customization that stripped periods from search index
values.  Removing the periods is unnecessary becuase the values are also
normalized by the search_normalize() function, which replaces periods
with spaces.

Adds an additional keyword index using the 'replace' normalizer to strip
periods from indexed values (without replacing them with a space) so
that we can additionaly index (for example) "g.i. joe" as "gi joe".

Signed-off-by: Bill Erickson <berickxx@gmail.com>
KCLS/sql/schema/deploy/search-index-keep-periods.sql [new file with mode: 0644]
KCLS/sql/schema/revert/search-index-keep-periods.sql [new file with mode: 0644]
KCLS/sql/schema/sqitch.plan