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

[dehowef]

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

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


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

commit 7632208458b9eccdad7be982217f0f5098e99b20
Author: John Gemignani <jrgemign...@gmail.com>
AuthorDate: Thu Aug 10 17:05:54 2023 -0700

    Fix issue 1000: Indexes created on WHERE (#1133)
    
    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 met 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 2b0ddef5..90097a7e 100644
--- a/age--1.3.0.sql
+++ b/age--1.3.0.sql
@@ -365,7 +365,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';