Re: SQL/JSON revisited

On Tue, Feb 21, 2023 at 12:09 PM Amit Langote <amitlangote09(at)gmail(dot)com> wrote:
> On Mon, Feb 20, 2023 at 11:41 PM Erik Rijkers <er(at)xs4all(dot)nl> wrote:
> > Op 20-02-2023 om 08:35 schreef Amit Langote:
> > > Rebased again over queryjumble overhaul.
> > But the following statement is a problem. It does not crash but it goes
> > off, half-freezing the machine, and only comes back after fanatic
> > Ctrl-C'ing.
> >
> > select json_query(jsonb '[3,4]', '$[*]' returning bigint[] empty object
> > on error);
> >
> > Can you have a look?
>
> Thanks for the test case. It caused ExecInterpExpr() to enter an
> infinite loop, which I've fixed in the attached updated version. I've
> also merged Elena's documentation changes; I can see that
> <replaceable> is more correct.

Oops, I hadn't actually done the latter. Will do when posting the next version.

--
Thanks, Amit Langote
EDB: http://www.enterprisedb.com