From 456f88a6277aa648c6d4b06a7c5e0c4f2fdde7ca Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Thu, 22 Jan 2015 11:57:43 -0500 Subject: [PATCH] LP#1413660 Mark 39.50 config function STABLE Mark SQL function evergreen.z3950_attr_name_is_valid(text) as STABLE instead of IMMUTABLE, since the output may vary with a single input over time. Signed-off-by: Bill Erickson Signed-off-by: Ben Shum --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- Open-ILS/src/sql/Pg/upgrade/XXXX.schema.z39_func_stable.sql | 5 +++++ 2 files changed, 6 insertions(+), 1 deletion(-) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.schema.z39_func_stable.sql diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 7f4aa2d1a5..4405cfc20a 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -1050,7 +1050,7 @@ ALTER TABLE config.best_hold_order ADD CHECK (( CREATE OR REPLACE FUNCTION evergreen.z3950_attr_name_is_valid(TEXT) RETURNS BOOLEAN AS $func$ SELECT EXISTS (SELECT 1 FROM config.z3950_attr WHERE name = $1); -$func$ LANGUAGE SQL STRICT IMMUTABLE; +$func$ LANGUAGE SQL STRICT STABLE; COMMENT ON FUNCTION evergreen.z3950_attr_name_is_valid(TEXT) IS $$ Results in TRUE if there exists at least one config.z3950_attr diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.z39_func_stable.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.z39_func_stable.sql new file mode 100644 index 0000000000..31a44d7e35 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.z39_func_stable.sql @@ -0,0 +1,5 @@ +BEGIN; + +ALTER FUNCTION evergreen.z3950_attr_name_is_valid (TEXT) STABLE; + +COMMIT; -- 2.43.2