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

JSON_xxx functions

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
          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

            Ascending order - Click to sort in descending order
            holyfoot Alexey Botchkov added a comment -

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

            holyfoot Alexey Botchkov added a comment - First patch proposal: http://lists.askmonty.org/pipermail/commits/2016-May/009406.html
            holyfoot Alexey Botchkov added a comment -

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

            holyfoot Alexey Botchkov added a comment - patch v2.0 http://lists.askmonty.org/pipermail/commits/2016-July/009555.html
            holyfoot Alexey Botchkov added a comment -

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

            holyfoot Alexey Botchkov added a comment - patch v3.0 http://lists.askmonty.org/pipermail/commits/2016-September/009854.html
            holyfoot Alexey Botchkov added a comment -

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

            holyfoot Alexey Botchkov added a comment - unittest added. http://lists.askmonty.org/pipermail/commits/2016-October/009959.html
            holyfoot Alexey Botchkov added a comment -

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

            holyfoot Alexey Botchkov added a comment - See my reply to your review, and the new unittest commit.
            holyfoot Alexey Botchkov added a comment -

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

            holyfoot Alexey Botchkov added a comment - Implementing the rest of the functions. http://lists.askmonty.org/pipermail/commits/2016-November/010087.html
            StevenWdV Steven WdV added a comment -

            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.

            StevenWdV Steven WdV added a comment - 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.

            People

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

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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