git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 3ec5f6b) | patch
Forbid numeric NaN in jsonpath
2020年7月11日 00:21:00 +0000 (03:21 +0300)
2020年7月11日 00:21:57 +0000 (03:21 +0300)
commit f4ae676e3178124c2bc2b3a3530efe8f3cdbc442
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
src/backend/utils/adt/jsonb_util.c diff | blob | blame | history
src/backend/utils/adt/jsonpath_exec.c diff | blob | blame | history
src/test/regress/expected/jsonb_jsonpath.out diff | blob | blame | history
This is the main PostgreSQL git repository.
RSS Atom

AltStyle によって変換されたページ (->オリジナル) /