Re: BUG #18035: Assertion failure in jsonb_path_query

On Tue, 25 Jul 2023 at 22:01, PG Bug reporting form
<noreply@postgresql.org> wrote:
> On REL_16_BETA2 the following query: select jsonb_path_query('{}', '($[0]
> like_regex "").type()');
> produces assert for me:

I'm no json path expert, but from what I can tell, this Assert is just
missing a condition for jpiLikeRegex.

With that added, it seems to properly determine that the regex test
returns boolean.

postgres=# select jsonb_path_query($$["string", "string"]$$, '($[0]
like_regex ".{5}")');
 jsonb_path_query
------------------
 true
(1 row)


postgres=# select jsonb_path_query($$["string", "string"]$$, '($[0]
like_regex ".{7}")');
 jsonb_path_query
------------------
 false
(1 row)


postgres=# select jsonb_path_query($$["string", "string"]$$, '($[0]
like_regex ".{7}").type()');
 jsonb_path_query
------------------
 "boolean"
(1 row)

The only other enum value missing from that Assert is jpiSubscript.

David