pgsql: Forbid numeric NaN in jsonpath - Mailing list pgsql-committers

From Alexander Korotkov
Subject pgsql: Forbid numeric NaN in jsonpath
Date
Msg-id E1ju3Ki-00014Z-1E@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Forbid numeric NaN in jsonpath

SQL standard doesn't define numeric Inf or NaN values.  It appears even more
ridiculous to support then in jsonpath assuming JSON doesn't support these
values as well.  This commit forbids returning NaN from .double(), which was
previously allowed.  NaN can't be result of inner-jsonpath computation over
non-NaNs.  So, we can not expect NaN in the jsonpath output.

Reported-by: Tom Lane
Discussion: https://postgr.es/m/203949.1591879542%40sss.pgh.pa.us
Author: Alexander Korotkov
Reviewed-by: Tom Lane
Backpatch-through: 12

Branch
------
REL_13_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/89a0b1a7ca0af36818ed7076c12ac00bcf4f007d

Modified Files
--------------
src/backend/utils/adt/jsonb_util.c           |  8 --------
src/backend/utils/adt/jsonpath_exec.c        | 15 ++++++++-------
src/test/regress/expected/jsonb_jsonpath.out | 12 ++----------
3 files changed, 10 insertions(+), 25 deletions(-)


pgsql-committers by date:

Previous
From: Alexander Korotkov
Date:
Subject: pgsql: Improve error reporting for jsonpath .double() method
Next
From: Alexander Korotkov
Date:
Subject: pgsql: Forbid numeric NaN in jsonpath