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

[dehowef]

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

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


The following commit(s) were added to refs/heads/PG13 by this push:
     new 5d1f1a13 Fix issue 1000: Indexes created on WHERE (#1133) (#1146)
5d1f1a13 is described below

commit 5d1f1a13b219602f745e7de8d09ac3f1224083e3
Author: John Gemignani <jrgemign...@gmail.com>
AuthorDate: Tue Aug 15 14:46:28 2023 -0700

    Fix issue 1000: Indexes created on WHERE (#1133) (#1146)
    
    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 a77e9a30..e97a3ce5 100644
--- a/age--1.3.0.sql
+++ b/age--1.3.0.sql
@@ -367,7 +367,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';
 
@@ -3106,7 +3106,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';
@@ -3114,10 +3114,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';