JSON UDF functions version 0.2.2 have been released.

New version of JSON UDF functions 0.2.2 have been just released. It is last maintenance release of 0.2 series. However it contains two new features:

JSON_VALID now accepts array as a root element of the JSON document (Bug#70567/17583282)

JSON functions can now be installed and uninstalled using a script (Bug#71263/18022788 Easy installation sql script).

This feature is Community contribution. Thank you, Daniel van Eeden!

This release also 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

71267/18020724 buffer underrun in JParser::parse_pair

71264/18022761 No uninstall information in the README

71261/18023002
References in README missing
Comments:

Great stuff, Sveta - thanks for your hard work here!

Posted by Todd Farmer on January 30, 2014 at 06:54 PM MSK #

Great work, Sveta - thanks for your continued dedication to making JSON data more consumable within MySQL!

Posted by Todd Farmer on January 30, 2014 at 06:55 PM MSK #

Hi Sveta,

Thanks for your hard work!
These JSON Udf's are potentially just gold for MySQL!
But I have one problem to use them.
The only function I really need is the JSON merge but currently when merging two json docs it duplicates key's and values that are present on both the docs being merged instead of just updates the value with the new doc... for example: json_merge( {"a":"b"}, {"a":"c"} ) returns: {"a":"b","a":"c"} instead of: {"a":"c"}
this is causing the returned doc to be non serializable and i think non legal json.
what i really need is a function that acts like json_set but for two json docs..

can you please add this?

thanks!

Posted by Yaniv Hakim on February 23, 2014 at 12:35 PM MSK #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Working blog of Sveta Smirnova - MySQL Senior Principal Support Engineer working in Bugs Analysis Support Group

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today