Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 10.6, 10.3.27, 10.4.17, 10.5.8
-
Component/s: JSON, Storage Engine - Spider
-
Labels:
-
Environment:ALL
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.