[age] branch PG12 updated: Fix issue 1000: Indexes created on WHERE (#1133) (#1147)

[dehowef]

This is an automated email from the ASF dual-hosted git repository.

dehowef pushed a commit to branch PG12
in repository https://gitbox.apache.org/repos/asf/age.git


The following commit(s) were added to refs/heads/PG12 by this push:
     new 48f169b2 Fix issue 1000: Indexes created on WHERE (#1133) (#1147)
48f169b2 is described below

commit 48f169b26d168b7cb694152388fc90f8f10f8a3f
Author: John Gemignani <jrgemign...@gmail.com>
AuthorDate: Tue Aug 15 14:46:51 2023 -0700

    Fix issue 1000: Indexes created on WHERE (#1133) (#1147)
    
    This fixes the issue with applying indexes on the WHERE clause.
    
    It does this by modifying the volatility flag for 3 functions -
    
        _agtype_build_vertex
        _agtype_build_edge
        _label_name
    
    All three were verified to meet the specifications for IMMUTABLE.
---
 age--1.3.0.sql | 9 +++++----
 1 file changed, 5 insertions(+), 4 deletions(-)

diff --git a/age--1.3.0.sql b/age--1.3.0.sql
index b90ba32b..cbad5ee2 100644
--- a/age--1.3.0.sql
+++ b/age--1.3.0.sql
@@ -364,7 +364,7 @@ AS 'MODULE_PATHNAME';
 CREATE FUNCTION ag_catalog._label_name(graph_oid oid, graphid)
 RETURNS cstring
 LANGUAGE c
-STABLE
+IMMUTABLE
 PARALLEL SAFE
 AS 'MODULE_PATHNAME';
 
@@ -3104,7 +3104,7 @@ AS 'MODULE_PATHNAME';
 CREATE FUNCTION ag_catalog._agtype_build_vertex(graphid, cstring, agtype)
 RETURNS agtype
 LANGUAGE c
-STABLE
+IMMUTABLE
 CALLED ON NULL INPUT
 PARALLEL SAFE
 AS 'MODULE_PATHNAME';
@@ -3112,10 +3112,11 @@ AS 'MODULE_PATHNAME';
 --
 -- agtype - edge
 --
-CREATE FUNCTION ag_catalog._agtype_build_edge(graphid, graphid, graphid, 
cstring, agtype)
+CREATE FUNCTION ag_catalog._agtype_build_edge(graphid, graphid, graphid,
+                                              cstring, agtype)
 RETURNS agtype
 LANGUAGE c
-STABLE
+IMMUTABLE
 CALLED ON NULL INPUT
 PARALLEL SAFE
 AS 'MODULE_PATHNAME';