Re: SQL/JSON revisited

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.

Now looking at Andres' comments, though, posting a version containing
a fix for the above case so Erik may continue the testing in the
meantime.

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