[MDEV-9143] JSON_xxx functions Created: 2015-11-17  Updated: 2017-09-09  Resolved: 2016-11-15

Status: Closed
Project: MariaDB Server
Component/s: OTHER
Fix Version/s: 10.2.3

Type: Task Priority: Blocker
Reporter: Sergei Golubchik Assignee: Alexey Botchkov
Resolution: Fixed Votes: 2
Labels: None

Issue Links:
Blocks
blocks MDEV-9056 JSON support Closed
Relates
relates to MDEV-11461 JSON_TYPE does not recognize integer/... Closed
relates to MDEV-11463 Server crashes in mark_array upon JSO... Closed
relates to MDEV-11464 Server crashes in mark_object upon JS... Closed
relates to MDEV-11465 JSON_LENGTH returns incorrect length Closed
relates to MDEV-11467 JSON_EXTRACT returns incorrect results Closed
relates to MDEV-11468 JSON_UNQUOTE returns incorrect results Closed
relates to MDEV-11469 JSON_SEARCH returns incorrect results Closed
relates to MDEV-11470 JSON_KEYS accepts arguments in invali... Closed
relates to MDEV-11471 JSON_ARRAY_APPEND returns incorrect r... Closed
relates to MDEV-11472 JSON_ARRAY_INSERT returns incorrect r... Closed
relates to MDEV-11473 JSON_REMOVE returns invalid results Closed
relates to MDEV-11474 JSON_DEPTH returns incorrect results Closed
relates to MDEV-11475 JSON_TYPE accepts arguments in invali... Closed
relates to MDEV-11562 Assertion `js->state == JST_VALUE' fa... Closed
relates to MDEV-11568 JSON_CONTAINS_PATH returns incorrect ... Closed
relates to MDEV-11569 JSON_ARRAY_INSERT produces an invalid... Closed
relates to MDEV-11570 JSON_MERGE returns incorrect result Closed
relates to MDEV-11571 JSON_EXTRACT returns wrong results Closed
relates to MDEV-11572 JSON_DEPTH returns wrong results Closed
relates to MDEV-11573 JSON_LENGTH returns incorrect results Closed
relates to MDEV-11433 JSON_MERGE returns a non-NULL result ... Closed
relates to MDEV-11436 CREATE TABLE .. AS SELECT JSON_OBJECT... Closed
relates to MDEV-11437 JSON_QUOTE function does not quote an... Closed
relates to MDEV-11438 Assertion `null_value' failed in Item... Closed
relates to MDEV-11439 No data type JSON, but CAST(something... Closed
relates to MDEV-11440 JSON has become a reserved word in Ma... Closed
relates to MDEV-11441 Server crashes in String::append / It... Closed
relates to MDEV-11442 Server crashes in String::length / pa... Closed
relates to MDEV-11443 Server crashes in json_string_set_cs Closed
relates to MDEV-11444 Server crashes in String::ptr / Item_... Closed
relates to MDEV-11445 JSON_MERGE requires at least two argu... Closed
relates to MDEV-11446 JSON_MERGE accepts arguments in inval... Closed
relates to MDEV-11447 JSON_MERGE merges valid JSON objects ... Closed
relates to MDEV-11448 Assertion `*p_cur_step < p->last_step... Closed
relates to MDEV-11449 Server crashes in Item_func_or_sum::a... Closed
relates to MDEV-11450 Assertion `!null_value' failed invirt... Closed
relates to MDEV-11452 JSON_CONTAINS accepts wrong number of... Closed
relates to MDEV-11453 JSON_CONTAINS returns incorrect values Closed
relates to MDEV-11489 Assertion `0' failed in json_find_path Closed
Sprint: 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3, 10.2.1-4, 10.2.1-5, 10.2.2-1, 10.2.2-1, 10.2.2-2, 10.2.2-3, 5.5.51 & 10.2.2, 10.2.2-1, 10.2.2-2, 10.2.2-3, 10.2.2-4, 10.2.3-1, 10.2.3-2, 10.0.28, 10.2.4-2

 Description   

JSON_xxx functions as in 5.7 and SQL standard (?)



 Comments   
Comment by Alexey Botchkov [ 2016-05-31 ]

First patch proposal:
http://lists.askmonty.org/pipermail/commits/2016-May/009406.html

Comment by Alexey Botchkov [ 2016-07-25 ]

patch v2.0
http://lists.askmonty.org/pipermail/commits/2016-July/009555.html

Comment by Alexey Botchkov [ 2016-09-13 ]

patch v3.0
http://lists.askmonty.org/pipermail/commits/2016-September/009854.html

Comment by Alexey Botchkov [ 2016-10-01 ]

unittest added.
http://lists.askmonty.org/pipermail/commits/2016-October/009959.html

Comment by Alexey Botchkov [ 2016-10-01 ]

See my reply to your review, and the new unittest commit.

Comment by Alexey Botchkov [ 2016-11-15 ]

Implementing the rest of the functions.
http://lists.askmonty.org/pipermail/commits/2016-November/010087.html

Comment by Steven WdV [ 2017-09-09 ]

A have a question (sorry if this is the wrong place for it): why do the JSON functions not return compacted JSON?
For example:

SELECT JSON_ARRAY(1,2,3)

returns [1, 2, 3] instead of [1,2,3] (without spaces). Of course we can compact it with JSON_COMPACT, but it would probably more efficiënt to not put spaces in in the first place, since you rarely want loose JSON to appear in a database.

Generated at Thu Feb 08 07:32:27 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.