[MDEV-9143] JSON_xxx functions - Jira

XML

Word

Printable

Details

Type: Task
Status: Closed (View Workflow)
Priority: Blocker
Resolution: Fixed
Fix Version/s: 10.2.3
Component/s: OTHER
Labels:
None

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 (?)

Attachments

Issue Links

blocks

MDEV-9056 JSON support

Closed

relates to

MDEV-11461 JSON_TYPE does not recognize integer/double types

Closed

MDEV-11463 Server crashes in mark_array upon JSON_VALID

Closed

MDEV-11464 Server crashes in mark_object upon JSON_VALID

Closed

MDEV-11465 JSON_LENGTH returns incorrect length

Closed

MDEV-11467 JSON_EXTRACT returns incorrect results

Closed

MDEV-11468 JSON_UNQUOTE returns incorrect results

Closed

MDEV-11469 JSON_SEARCH returns incorrect results

Closed

MDEV-11470 JSON_KEYS accepts arguments in invalid format

Closed

MDEV-11471 JSON_ARRAY_APPEND returns incorrect results

Closed

MDEV-11472 JSON_ARRAY_INSERT returns incorrect results

Closed

MDEV-11473 JSON_REMOVE returns invalid results

Closed

MDEV-11474 JSON_DEPTH returns incorrect results

Closed

MDEV-11475 JSON_TYPE accepts arguments in invalid format

Closed

MDEV-11562 Assertion `js->state == JST_VALUE' failed in check_contains(json_engine_t*, json_engine_t*)

Closed

MDEV-11568 JSON_CONTAINS_PATH returns incorrect results and produces wrong warning

Closed

MDEV-11569 JSON_ARRAY_INSERT produces an invalid result

Closed

MDEV-11570 JSON_MERGE returns incorrect result

Closed

MDEV-11571 JSON_EXTRACT returns wrong results

Closed

MDEV-11572 JSON_DEPTH returns wrong results

Closed

MDEV-11573 JSON_LENGTH returns incorrect results

Closed

MDEV-11433 JSON_MERGE returns a non-NULL result with a NULL argument

Closed

MDEV-11436 CREATE TABLE .. AS SELECT JSON_OBJECT truncates data

Closed

MDEV-11437 JSON_QUOTE function does not quote and uses wrong character set

Closed

MDEV-11438 Assertion `null_value' failed in Item::send(Protocol*, String*) upon casting NULL as JSON

Closed

MDEV-11439 No data type JSON, but CAST(something AS JSON) pretends to work

Closed

MDEV-11440 JSON has become a reserved word in MariaDB

Closed

MDEV-11441 Server crashes in String::append / Item_func_json_extract::val_str

Closed

MDEV-11442 Server crashes in String::length / parse_one_or_all / Item_func_json_contains_path::val_int

Closed

MDEV-11443 Server crashes in json_string_set_cs

Closed

MDEV-11444 Server crashes in String::ptr / Item_func_json_depth::val_int

Closed

MDEV-11445 JSON_MERGE requires at least two arguments in MySQL, but not in MariaDB

Closed

MDEV-11446 JSON_MERGE accepts arguments in invalid format

Closed

MDEV-11447 JSON_MERGE merges valid JSON objects incorrectly

Closed

MDEV-11448 Assertion `*p_cur_step < p->last_step' failed in strings/json_lib.c handle_match

Closed

MDEV-11449 Server crashes in Item_func_or_sum::agg_item_collations

Closed

MDEV-11450 Assertion `!null_value' failed invirtual bool Item::send on json_search

Closed

MDEV-11452 JSON_CONTAINS accepts wrong number of arguments

Closed

MDEV-11453 JSON_CONTAINS returns incorrect values

Closed

MDEV-11489 Assertion `0' failed in json_find_path

Closed

links to

PeterG blog “Standard SQL/JSON and MySQL 5.7 JSON”

(35 relates to, 1 links to)

Activity

People

Assignee:: Alexey Botchkov

Reporter:: Sergei Golubchik

Votes:: 2 Vote for this issue

Watchers:: 6 Start watching this issue

Dates

Created:: 2015-11-17 16:37

Updated:: 2017-09-09 19:58

Resolved:: 2016-11-15 13:23

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.