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

[dehowef]

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

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


The following commit(s) were added to refs/heads/PG11 by this push:
     new 34b24ee7 Fix issue 1000: Indexes created on WHERE (#1133) (#1148)
34b24ee7 is described below

commit 34b24ee768c8b6d50ed61a13bddf25987cf48486
Author: John Gemignani <jrgemign...@gmail.com>
AuthorDate: Tue Aug 15 14:47:23 2023 -0700

    Fix issue 1000: Indexes created on WHERE (#1133) (#1148)
    
    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 5ffd1026..a906cba8 100644
--- a/age--1.3.0.sql
+++ b/age--1.3.0.sql
@@ -361,7 +361,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';
 
@@ -3102,7 +3102,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';
@@ -3110,10 +3110,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';