Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-9143

JSON_xxx functions

    XMLWordPrintable

Details

    • Task
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Fixed
    • 10.2.3
    • OTHER
    • 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

          Task - A task that needs to be done. MDEV-9056 JSON support

          • Major - Major loss of function.
          • Closed
          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-40609 JSON_KEYS is documented to return a JSON array but the server does not treat its result as one

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11461 JSON_TYPE does not recognize integer/double types

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11463 Server crashes in mark_array upon JSON_VALID

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11464 Server crashes in mark_object upon JSON_VALID

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11465 JSON_LENGTH returns incorrect length

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11467 JSON_EXTRACT returns incorrect results

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11468 JSON_UNQUOTE returns incorrect results

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11469 JSON_SEARCH returns incorrect results

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11470 JSON_KEYS accepts arguments in invalid format

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11471 JSON_ARRAY_APPEND returns incorrect results

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11472 JSON_ARRAY_INSERT returns incorrect results

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11473 JSON_REMOVE returns invalid results

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11474 JSON_DEPTH returns incorrect results

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11475 JSON_TYPE accepts arguments in invalid format

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11562 Assertion `js->state == JST_VALUE' failed in check_contains(json_engine_t*, json_engine_t*)

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11568 JSON_CONTAINS_PATH returns incorrect results and produces wrong warning

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11569 JSON_ARRAY_INSERT produces an invalid result

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11570 JSON_MERGE returns incorrect result

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11571 JSON_EXTRACT returns wrong results

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11572 JSON_DEPTH returns wrong results

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11573 JSON_LENGTH returns incorrect results

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11433 JSON_MERGE returns a non-NULL result with a NULL argument

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11436 CREATE TABLE .. AS SELECT JSON_OBJECT truncates data

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11437 JSON_QUOTE function does not quote and uses wrong character set

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11438 Assertion `null_value' failed in Item::send(Protocol*, String*) upon casting NULL as JSON

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11439 No data type JSON, but CAST(something AS JSON) pretends to work

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11440 JSON has become a reserved word in MariaDB

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11441 Server crashes in String::append / Item_func_json_extract::val_str

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11442 Server crashes in String::length / parse_one_or_all / Item_func_json_contains_path::val_int

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11443 Server crashes in json_string_set_cs

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11444 Server crashes in String::ptr / Item_func_json_depth::val_int

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11445 JSON_MERGE requires at least two arguments in MySQL, but not in MariaDB

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11446 JSON_MERGE accepts arguments in invalid format

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11447 JSON_MERGE merges valid JSON objects incorrectly

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11448 Assertion `*p_cur_step < p->last_step' failed in strings/json_lib.c handle_match

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11449 Server crashes in Item_func_or_sum::agg_item_collations

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11450 Assertion `!null_value' failed invirtual bool Item::send on json_search

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11452 JSON_CONTAINS accepts wrong number of arguments

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11453 JSON_CONTAINS returns incorrect values

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11489 Assertion `0' failed in json_find_path

          • Major - Major loss of function.
          • Closed
          links to

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

          Activity

            People

              holyfoot Alexey Botchkov
              serg Sergei Golubchik
              Votes:
              2 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 20d
                  20d
                  Remaining:
                  Time Spent - 9d 6.5h Remaining Estimate - 10d 1.5h
                  10d 1.5h
                  Logged:
                  Time Spent - 9d 6.5h Remaining Estimate - 10d 1.5h
                  9d 6.5h

                  Git Integration

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