postgres.git / summary / log / commit / refs

commit    deae1657ee6dd6f7b3effab3d44429d5434f5bbf
Author:   David Rowley <drowley@postgresql.org>
Date:     Tue Aug 01 13:39:47 2023 +0000
First released in: 17.0, 12.16, 13.12, 14.9, 15.4, 16.0

    Fix overly strict Assert in jsonpath code
    
    This was failing for queries which try to get the .type() of a
    jpiLikeRegex.  For example:
    
    select jsonb_path_query('["string", "string"]',
                            '($[0] like_regex ".{7}").type()');
    
    Reported-by: Alexander Kozhemyakin
    Bug: #18035
    Discussion: https://postgr.es/m/18035-64af5cdcb5adf2a9@postgresql.org
    Backpatch-through: 12, where SQL/JSON path was added.


 src/backend/utils/adt/jsonpath.c | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/src/backend/utils/adt/jsonpath.c b/src/backend/utils/adt/jsonpath.c
index 7891fde3105..c5ba3b7f1d0 100644
--- a/src/backend/utils/adt/jsonpath.c
+++ b/src/backend/utils/adt/jsonpath.c
@@ -1014,7 +1014,8 @@ jspGetNext(JsonPathItem *v, JsonPathItem *a)
 			   v->type == jpiDouble ||
 			   v->type == jpiDatetime ||
 			   v->type == jpiKeyValue ||
-			   v->type == jpiStartsWith);
+			   v->type == jpiStartsWith ||
+			   v->type == jpiLikeRegex);
 
 		if (a)
 			jspInitByBuffer(a, v->base, v->nextPos);


[parent: d3a38318ac61]