Details
-
Task
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
-
None
-
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
Activity
Remote Link | This issue links to "PeterG blog “Standard SQL/JSON and MySQL 5.7 JSON” (Web Link)" [ 26304 ] |
Fix Version/s | 10.2 [ 14601 ] |
Assignee | Alexey Botchkov [ holyfoot ] |
Sprint | 10.2.0-9 [ 43 ] |
Rank | Ranked higher |
Status | Open [ 1 ] | In Progress [ 3 ] |
Sprint | 10.2.0-9 [ 43 ] | 10.2.0-9, 10.2.0-10 [ 43, 46 ] |
Sprint | 10.2.0-9, 10.2.0-10 [ 43, 46 ] | 10.2.0-9, 10.2.0-10, 10.2.0-11 [ 43, 46, 47 ] |
Sprint | 10.2.0-9, 10.2.0-10, 10.2.0-11 [ 43, 46, 47 ] | 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1 [ 43, 46, 47, 56 ] |
Sprint | 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1 [ 43, 46, 47, 56 ] | 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-2 [ 43, 46, 47, 56, 63 ] |
Sprint | 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-2 [ 43, 46, 47, 56, 63 ] | 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3 [ 43, 46, 47, 56, 65 ] |
Rank | Ranked lower |
Sprint | 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3 [ 43, 46, 47, 56, 65 ] | 10.2.0-9, 10.2.0-10, 10.2.0-11, 10.2.1-1, 10.2.1-3, 10.2.1-4 [ 43, 46, 47, 56, 65, 66 ] |
Assignee | Alexey Botchkov [ holyfoot ] | Sergei Golubchik [ serg ] |
Status | In Progress [ 3 ] | In Review [ 10002 ] |
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 [ 43, 46, 47, 56, 65, 66 ] | 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 [ 43, 46, 47, 56, 65, 66, 68 ] |
Assignee | Sergei Golubchik [ serg ] | Alexey Botchkov [ holyfoot ] |
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 [ 43, 46, 47, 56, 65, 66, 68 ] | 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 [ 43, 46, 47, 56, 65, 66, 68, 77 ] |
Rank | Ranked lower |
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 [ 43, 46, 47, 56, 65, 66, 68, 77 ] | 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 [ 43, 46, 47, 56, 65, 66, 68, 77, 79 ] |
Rank | Ranked higher |
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 [ 43, 46, 47, 56, 65, 66, 68, 77, 79 ] | 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 [ 43, 46, 47, 56, 65, 66, 68, 77, 79, 82 ] |
Assignee | Alexey Botchkov [ holyfoot ] | Sergei Golubchik [ serg ] |
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 [ 43, 46, 47, 56, 65, 66, 68, 77, 79, 82 ] | 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 [ 43, 46, 47, 56, 65, 66, 68, 77, 79, 82, 83 ] |
Assignee | Sergei Golubchik [ serg ] | Alexey Botchkov [ holyfoot ] |
Status | In Review [ 10002 ] | Stalled [ 10000 ] |
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 [ 43, 46, 47, 56, 65, 66, 68, 77, 79, 82, 83 ] | 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.51 & 10.2 [ 43, 46, 47, 56, 65, 66, 68, 77, 79, 82, 83, 85 ] |
Rank | Ranked higher |
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 [ 43, 46, 47, 56, 65, 66, 68, 77, 79, 82, 83, 85 ] | 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 [ 43, 46, 47, 56, 65, 66, 68, 77, 79, 82, 83, 85, 89 ] |
Rank | Ranked higher |
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 [ 43, 46, 47, 56, 65, 66, 68, 77, 79, 82, 83, 85, 89 ] | 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 [ 43, 46, 47, 56, 65, 66, 68, 77, 79, 82, 83, 85, 89, 92 ] |
Rank | Ranked lower |
Status | Stalled [ 10000 ] | In Progress [ 3 ] |
Assignee | Alexey Botchkov [ holyfoot ] | Sergei Golubchik [ serg ] |
Status | In Progress [ 3 ] | In Review [ 10002 ] |
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 [ 43, 46, 47, 56, 65, 66, 68, 77, 79, 82, 83, 85, 89, 92 ] | 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 [ 43, 46, 47, 56, 65, 66, 68, 77, 79, 82, 83, 85, 89, 92, 94 ] |
Assignee | Sergei Golubchik [ serg ] | Alexey Botchkov [ holyfoot ] |
Status | In Review [ 10002 ] | Stalled [ 10000 ] |
Status | Stalled [ 10000 ] | In Progress [ 3 ] |
Assignee | Alexey Botchkov [ holyfoot ] | Sergei Golubchik [ serg ] |
Status | In Progress [ 3 ] | In Review [ 10002 ] |
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 [ 43, 46, 47, 56, 65, 66, 68, 77, 79, 82, 83, 85, 89, 92, 94 ] | 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 [ 43, 46, 47, 56, 65, 66, 68, 77, 79, 82, 83, 85, 89, 92, 94, 96 ] |
Assignee | Sergei Golubchik [ serg ] | Alexey Botchkov [ holyfoot ] |
Status | In Review [ 10002 ] | Stalled [ 10000 ] |
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 [ 43, 46, 47, 56, 65, 66, 68, 77, 79, 82, 83, 85, 89, 92, 94, 96 ] | 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 [ 43, 46, 47, 56, 65, 66, 68, 77, 79, 82, 83, 85, 89, 92, 94, 96, 102 ] |
Rank | Ranked lower |
Status | Stalled [ 10000 ] | In Progress [ 3 ] |
Assignee | Alexey Botchkov [ holyfoot ] | Sergei Golubchik [ serg ] |
Status | In Progress [ 3 ] | In Review [ 10002 ] |
Assignee | Sergei Golubchik [ serg ] | Alexey Botchkov [ holyfoot ] |
Status | In Review [ 10002 ] | Stalled [ 10000 ] |
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 [ 43, 46, 47, 56, 65, 66, 68, 77, 79, 82, 83, 85, 89, 92, 94, 96, 102 ] | 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 [ 43, 46, 47, 56, 65, 66, 68, 77, 79, 82, 83, 85, 89, 92, 94, 96, 102, 105 ] |
Priority | Major [ 3 ] | Blocker [ 1 ] |
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 [ 43, 46, 47, 56, 65, 66, 68, 77, 79, 82, 83, 85, 89, 92, 94, 96, 102, 105 ] | 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 [ 43, 46, 47, 56, 65, 66, 68, 77, 79, 82, 83, 85, 89, 92, 94, 96, 102, 105, 107 ] |
Rank | Ranked higher |
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 [ 43, 46, 47, 56, 65, 66, 68, 77, 79, 82, 83, 85, 89, 92, 94, 96, 102, 105, 107 ] | 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-1 [ 43, 46, 47, 56, 65, 66, 68, 77, 79, 82, 83, 85, 89, 92, 94, 96, 102, 105, 107, 110 ] |
Rank | Ranked higher |
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-1 [ 43, 46, 47, 56, 65, 66, 68, 77, 79, 82, 83, 85, 89, 92, 94, 96, 102, 105, 107, 110 ] | 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 [ 43, 46, 47, 56, 65, 66, 68, 77, 79, 82, 83, 85, 89, 92, 94, 96, 102, 105, 107, 113 ] |
Rank | Ranked lower |
issue.field.resolutiondate | 2016-11-15 13:23:59.0 | 2016-11-15 13:23:59.256 |
Component/s | OTHER [ 10125 ] | |
Fix Version/s | 10.2.5 [ 22117 ] | |
Fix Version/s | 10.2 [ 14601 ] | |
Resolution | Fixed [ 1 ] | |
Status | Stalled [ 10000 ] | Closed [ 6 ] |
Link |
This issue relates to |
Fix Version/s | 10.2.3 [ 22115 ] | |
Fix Version/s | 10.2.5 [ 22117 ] |
Link |
This issue relates to |
Link |
This issue relates to |
Link |
This issue relates to |
Link |
This issue relates to |
Link |
This issue relates to |
Link |
This issue relates to |
Link |
This issue relates to |
Link |
This issue relates to |
Link |
This issue relates to |
Link |
This issue relates to |
Link |
This issue relates to |
Link |
This issue relates to |
Link |
This issue relates to |
Link |
This issue relates to |
Link |
This issue relates to |
Link |
This issue relates to |
Link |
This issue relates to |
Link |
This issue relates to |
Link |
This issue relates to |
Link |
This issue relates to |
Link |
This issue relates to |
Link |
This issue relates to |
Link |
This issue relates to |
Link |
This issue relates to |
Link |
This issue relates to |
Link |
This issue relates to |
Link |
This issue relates to |
Link |
This issue relates to |
Link |
This issue relates to |
Link |
This issue relates to |
Link |
This issue relates to |
Link |
This issue relates to |
Link |
This issue relates to |
Link |
This issue relates to |
Link |
This issue relates to |
Link |
This issue relates to |
Link |
This issue relates to |
Link |
This issue relates to |
Link |
This issue relates to |
Link |
This issue relates to |
Workflow | MariaDB v3 [ 72619 ] | MariaDB v4 [ 132729 ] |
First patch proposal:
http://lists.askmonty.org/pipermail/commits/2016-May/009406.html