Re: BUG #18035: Assertion failure in jsonb_path_query - Mailing list pgsql-bugs

From David Rowley
Subject Re: BUG #18035: Assertion failure in jsonb_path_query
Date
Msg-id CAApHDvrZS7tpiSB=XorYJDq4m=BB3uPmwpYzJbKWRDxouOoE1g@mail.gmail.com
Whole thread Raw
In response to BUG #18035: Assertion failure in jsonb_path_query  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #18035: Assertion failure in jsonb_path_query
List pgsql-bugs
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

Attachment

pgsql-bugs by date:

Previous
From: Alexander Lakhin
Date:
Subject: Re: BUG #18014: Releasing catcache entries makes schema_to_xmlschema() fail when parallel workers are used
Next
From: Andres Freund
Date:
Subject: Re: BUG #18031: Segmentation fault after deadlock within VACUUM's parallel worker