Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.11.2
Description
to reproduce:
DROP TABLE t3;
|
|
CREATE TABLE t3 (
|
|
j JSON
|
|
);
|
|
|
|
INSERT INTO t3 (j) VALUES ('[{"id": 1, "name": "Monty"},{"id": 2, "name": "Widenius"},{"id": 3, "name": "Michael"}]'); |
|
INSERT INTO t3 (j) VALUES ('[{"id": 1, "name": "Monty"},{"id": 2, "name": "Widenius"},{"id": 3, "name": "Michael"}]'); |
|
|
|
SELECT JSON_REMOVE(j, '$[0 to 1]') FROM t |
Result
(NULL)
(NULL)