Returns NULL, if the value is empty object/array

[venugopp]

When the value is empty, the parser fails and returns NULL.
In the example below name is empty object. So when you try to extract the value, it returns null. The behaviour is the same if its an empty array as well.

{ "menu": { "id": "file", "value": "File", "name" : {}, "popup": { "menuitem": [ {"value": "New", "onclick": "CreateNewDoc()"}, {"value": "Open", "onclick": "OpenDoc()"}, {"value": "Close", "onclick": "CloseDoc()"} ] } } }

SQL Command used:
SELECT common_schema.extract_json_value(@json, '//menu//value') AS result;