By Sveta Smirnova on Dec 31, 2013
Today new version of JSON UDF functions: 0.3.0 was released. This is major release which contains new functionality. You can download functions from the MySQL Labs website.
What was added?
Functions JSON_EXTRACT, JSON_CONTAINS_KEY, JSON_APPEND, JSON_REMOVE, JSON_REPLACE, JSON_SET now accept both string and integer arguments as array indexes. (Bug #70393/17491709)
Now syntax JSON_EXTRACT(doc, 'key', 1); is accepted.
New function JSON_SAFE_MERGE checks JSON documents for validity before merging them. In addition JSON_MERGE now merges valid documents, having array as root element. (Bug #70575/17583568)
JSON_VALID now accepts array as a root element of the JSON document (Bug #70567/17583282)
Also this release contains following bug fixes:
71050/17882710 json_extract returning same column twice if key names are not fully distinct. (Fixed for JSON_EXTRACT, JSON_CONTAINS_KEY, JSON_APPEND, JSON_REMOVE, JSON_REPLACE, JSON_SET)
71180/17975709 JSON_CONTAINS_KEY founds not existent key in the array element
70579/17584678 Add ability to append last element to array in JSON_APPEND
And, of course, this release contains all changes which version 0.2.1 has