From 051bbf260d1a6325c1996872891c5e3a2982445c Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Wed, 2 Oct 2019 15:23:21 -0400 Subject: [PATCH] more dynamic repairs Signed-off-by: Bill Erickson --- Open-ILS/src/sql/Pg/upgrade/XXXX.schema.elastic-search.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.elastic-search.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.elastic-search.sql index dd74baf1e2..d890540ced 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.elastic-search.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.elastic-search.sql @@ -102,14 +102,14 @@ BEGIN SELECT cmf.field_class AS search_group, cmf.name, - mfe.source, + compiled.source, -- Index individual values instead of string-joined values -- so they may be treated individually. This is useful, -- for example, when aggregating on subjects. CASE WHEN cmf.joiner IS NOT NULL THEN - REGEXP_SPLIT_TO_TABLE(mfe.value, cmf.joiner) + REGEXP_SPLIT_TO_TABLE(compiled.value, cmf.joiner) ELSE - mfe.value + compiled.value END AS value FROM ( -- Extract the values from the source MARC record instead -- 2.11.0