On 24.03.2017 00:50, Richard Hipp wrote:
This second beta adds a new SQL function: json_patch(). See
https://www.sqlite.org/draft/json1.html#jpatch for details.
json_patch() fails to produce the expected result for the last example
in https://tools.ietf.org/html/rfc7396#appendix-A
SELECT json_patch('{}','{"a":{"bb":{"ccc":null}}}');
should return
{"a":{"bb":{}}}
but instead returns
{"a":{"bb":{"ccc":null}}}
As far as I read the document, the "ccc" value should be removed
according to this rule:
if Value is null:
if Name exists in Target:
remove the Name/Value pair from Target
Ralf
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users