From 3dfd7055bb024a385165ceca9e88b49014a8e515 Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Wed, 19 Feb 2014 13:06:32 -0500 Subject: [PATCH] LP#1053397: Correct operator thinko on CRA sorters Signed-off-by: Mike Rylander Signed-off-by: Dan Wells --- Open-ILS/src/sql/Pg/030.schema.metabib.sql | 2 +- Open-ILS/src/sql/Pg/upgrade/QQQQ.MVF_CRA-upgrade.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 e5c96731e7..ba9818ba4d 100644 --- a/Open-ILS/src/sql/Pg/030.schema.metabib.sql +++ b/Open-ILS/src/sql/Pg/030.schema.metabib.sql @@ -1613,7 +1613,7 @@ BEGIN END IF; IF attr_def.sorter THEN - IF attr_vector ~~ tmp_val THEN + IF attr_vector @@ tmp_val 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, ccvm_row.code); END IF; diff --git a/Open-ILS/src/sql/Pg/upgrade/QQQQ.MVF_CRA-upgrade.sql b/Open-ILS/src/sql/Pg/upgrade/QQQQ.MVF_CRA-upgrade.sql index c04d8f4501..4148fa45c8 100644 --- a/Open-ILS/src/sql/Pg/upgrade/QQQQ.MVF_CRA-upgrade.sql +++ b/Open-ILS/src/sql/Pg/upgrade/QQQQ.MVF_CRA-upgrade.sql @@ -450,7 +450,7 @@ BEGIN END IF; IF attr_def.sorter THEN - IF attr_vector ~~ tmp_val THEN + IF attr_vector @@ tmp_val 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, ccvm_row.code); END IF; -- 2.43.2