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.

diff --git a/src/backend/utils/adt/jsonpath.c b/src/backend/utils/adt/jsonpath.c
index 91af030095239f562e065d00626b89e30aabceed..f9210441df533a3250a54c578a3f92ce7955a2ce 100644 (file)
--- a/src/backend/utils/adt/jsonpath.c
+++ b/src/backend/utils/adt/jsonpath.c
@@ -982,7 +982,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);