Horton

Improve reporting for syntax errors in multi-line JSON data.

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

View on postgr.es
Commit: ffd3944ab9d481906137bc7d20f5325a2bd68acc
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2021-03-01T21:44:17Z
Releases: 14.0 
Improve reporting for syntax errors in multi-line JSON data.

Point to the specific line where the error was detected; the
previous code tended to include several preceding lines as well.
Avoid re-scanning the entire input to recompute which line that
was.  Simplify the logic a bit.  Add test cases.

Simon Riggs and Hamid Akhtar, reviewed by Daniel Gustafsson and myself

Discussion: https://postgr.es/m/CANbhV-EPBnXm3MF_TTWBwwqgn1a1Ghmep9VHfqmNBQ8BT0f+_g@mail.gmail.com

Files

PathChange+/−
src/backend/utils/adt/jsonfuncs.c modified +6 −17
src/common/jsonapi.c modified +5 −3
src/include/common/jsonapi.h modified +2 −2
src/test/regress/expected/jsonb.out modified +31 −0
src/test/regress/expected/json.out modified +35 −0
src/test/regress/sql/jsonb.sql modified +17 −0
src/test/regress/sql/json.sql modified +17 −0

Discussion