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

Execution of JSON_REPLACE failed on Spider

Details

    Description

      How to repeat

      On Spider:

      spd.sql

      CREATE TABLE tbl_a (
        i INT,
        j JSON,
        PRIMARY KEY(i)
      ) ENGINE=SPIDER, PARTITION BY ...
       
      INSERT INTO tbl_a VALUES (1, '{ "a": 1, "b": [2, 3]}');
      UPDATE tbl_a SET j = JSON_REPLACE(j, '$.a', 10, '$.c', '[1, 2]');
      

      When the update statement is executed, it fails with

      query 'UPDATE tbl_a SET j = JSON_REPLACE(j, '$.a', 10, '$.c', '[1, 2]')' failed: 1305: FUNCTION auto_test_remote.json_update does not exist

      More critically, it will make the server crash on Windows on debug mode.

      Suggest fix

      https://github.com/MariaDB/server/pull/1735

      Attachments

        Activity

          JSON functions were introduced by 10.2.3. So, we should check 10.2 also. https://mariadb.com/kb/en/json_replace/

          nayuta-yanagisawa Nayuta Yanagisawa (Inactive) added a comment - JSON functions were introduced by 10.2.3. So, we should check 10.2 also. https://mariadb.com/kb/en/json_replace/
          nayuta-yanagisawa Nayuta Yanagisawa (Inactive) added a comment - Please review https://github.com/MariaDB/server/pull/1841

          ralf.gebhardt@mariadb.com This does not affect 10.2, because the Spider bundled with 10.2 does not pushdown functions to data nodes. I added not-10.2 label to the issue.

          nayuta-yanagisawa Nayuta Yanagisawa (Inactive) added a comment - ralf.gebhardt@mariadb.com This does not affect 10.2, because the Spider bundled with 10.2 does not pushdown functions to data nodes. I added not-10.2 label to the issue.

          People

            serg Sergei Golubchik
            yongxinxu Yongxin Xu
            Votes:
            0 Vote for this issue
            Watchers:
            5 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.