I get a JSON Array from an external System. When no data is available the system insert the string null in the Data. When the Data is parsed with sp_parse_json the returned data contains a 0 for that element instead of a SQL NULL.
The null exists in the JSON Definition at www.json.org. Do I miss something? Is it planned to follow the JSON definition in the future? Is SA17 behave differently?
Hm, the special JSON null value seems to be parsed partly wrong, possibly due to the other supplied values:
In my tests with 126.96.36.1990, this is returned:
In my humble impression, there seems to be a bug that as soon as a number is involved, null is treated as 0.