JSON UDF functions version 0.3.1 have been released.

Today new version of JSON UDF functions: 0.3.1 was released. This is development release which contains new functionality. You can download functions from the MySQL Labs website.

What is new?

Default value for compile option `WITH_PCRE` now is `bundled` independently from the
platform (Bug #71265/18081332 Library name mismatch for PCRE on Ubuntu)

New values, passed to functions `JSON_APPEND`, `JSON_REPLACE`, `JSON_SET` as numbers, empty strings or `NULL`s are converted to JSON objects. Objects, passed as strings are not converted: you are still responsible to put quotes around string values. Also these functions check if element which needs to be inserted is valid JSON value. (Bug #70394/17491708 MySQL JSON UDFs: json_replace can generate invalid target JSON)

README and ChangeLog files use Markdown format (Bug #71261/18023002 REFERENCES IN README MISSING)

`JSON_SEARCH` now accepts third argument: occurrence number, allowing to specify number of occurrence needed. (Bug #70607/17597479 ADD POSSIBILITY TO SEARCH ALL OCCURRENCES WITH JSON_SEARCH)

Added function `JSON_DEPTH` which returns depth of the JSON document.

Bugs fixed:


71510/18154696 `JSON_EXTRACT` returns wrong value if extracts from object which holds two arrays

71530/18160842 `JSON_EXTRACT` RETURNS WRONG RESULT IN VERSION 0.3

71949/18355404 `JSON_VALID` DOES NOT REJECT INVALID DOCUMENTS

70606/17596818 Implement SAFE versions for all JSON functions

And, of course, this release contains all changes made in version 0.2.2

Comments:

I'm trying to run the json_extract function through cmd bt I'm getting a error showing function db.json_extract donot exist what shud I do.??? Plzzz guide me..

Posted by guest on June 26, 2014 at 08:24 PM MSD #

You need to install functions first. Please read README file and use script install_jsonudf.sql

Posted by Sveta Smirnova on July 02, 2014 at 12:54 PM MSD #

Possibly a bug (0.3.1):
select json_set('{}', 'a', '"b"') => {} (empty object)
expeted result:
select json_set('{}', 'a', '"b"') => {"a":"b"}
Thank you.

Posted by guest on August 01, 2014 at 01:40 AM MSD #

Yes, looks like a bug. Please report at bugs.mysql.com

Posted by Sveta Smirnova on August 01, 2014 at 04:04 AM MSD #

Not needed, posted myself at http://bugs.mysql.com/bug.php?id=73486

Posted by Sveta Smirnova on August 06, 2014 at 11:49 PM MSD #

Issue seems fixed now

Posted by guest on November 12, 2014 at 08:42 AM 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
« May 2015
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
31
      
Today