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

Execution of JSON_REPLACE failed on Spider

    XMLWordPrintable

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

          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.