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