Horton

Re: Bug in jsonb_in function (14 & 15 version are affected)

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Nikolay Shaplov <dhyan@nataraj.su>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2023-03-13T17:58:02Z
Lists: pgsql-hackers

Attachments

Nikolay Shaplov <dhyan@nataraj.su> writes:
> I found a bug in jsonb_in function (it converts json from sting representation
>  into jsonb internal representation).

Yeah.  Looks like json_lex_string is failing to honor the invariant
that it needs to set token_terminator ... although the documentation
of the function certainly isn't helping.  I think we need the attached.

A nice side benefit is that the error context reports get a lot more
useful --- somebody should have inquired before as to why they were
so bogus.

			regards, tom lane

Commits

  1. Fix JSON error reporting for many cases of erroneous string values.