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:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0d
                0d
                Logged:
                Time Spent - 3h
                3h

                Git Integration

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