From 2ce8f8a1ad7592ef5e272ad301691cb7c85f1d2b Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Tue, 21 Jan 2014 13:29:43 -0500 Subject: [PATCH] Need to protect against null values for sorters Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/030.schema.metabib.sql | 2 +- Open-ILS/src/sql/Pg/upgrade/YYYY.schema.CRA.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/030.schema.metabib.sql b/Open-ILS/src/sql/Pg/030.schema.metabib.sql index ad9943aa61..2ab787dcd1 100644 --- a/Open-ILS/src/sql/Pg/030.schema.metabib.sql +++ b/Open-ILS/src/sql/Pg/030.schema.metabib.sql @@ -1539,7 +1539,7 @@ BEGIN attr_vector := attr_vector || attr_vector_tmp; END IF; - IF attr_def.sorter THEN + IF attr_def.sorter AND norm_attr_value[1] IS NOT NULL THEN DELETE FROM metabib.record_sorter WHERE source = rid AND attr = attr_def.name; INSERT INTO metabib.record_sorter (source, attr, value) VALUES (rid, attr_def.name, norm_attr_value[1]); END IF; diff --git a/Open-ILS/src/sql/Pg/upgrade/YYYY.schema.CRA.sql b/Open-ILS/src/sql/Pg/upgrade/YYYY.schema.CRA.sql index cdc3e78ad2..9fae927991 100644 --- a/Open-ILS/src/sql/Pg/upgrade/YYYY.schema.CRA.sql +++ b/Open-ILS/src/sql/Pg/upgrade/YYYY.schema.CRA.sql @@ -224,7 +224,7 @@ BEGIN attr_vector := attr_vector || attr_vector_tmp; END IF; - IF attr_def.sorter THEN + IF attr_def.sorter AND norm_attr_value[1] IS NOT NULL THEN DELETE FROM metabib.record_sorter WHERE source = rid AND attr = attr_def.name; INSERT INTO metabib.record_sorter (source, attr, value) VALUES (rid, attr_def.name, norm_attr_value[1]); END IF; -- 2.11.0