Re: JSON_ARRAY_APPEND adding escape slash

[Derek McKinnon]

OK, this worked.


-- SET @i = NULL;
SET @i = JSON_ARRAY(JSON_OBJECT('a', '1', 'b', '2'));
SET @j = JSON_OBJECT('c', '3', 'd', '3');
-- SET @j = CAST('{"a": "1"}' AS JSON);
SET @a = IF( @i IS NULL OR JSON_TYPE(@i) != 'ARRAY',
JSON_ARRAY_APPEND(JSON_ARRAY(), '$', @j),
JSON_ARRAY_APPEND(@i, '$', JSON_OBJECT('c', '3', 'd', '3'))
);
SELECT @j, @a

Now I have to work out how to pass that string type object in to a function.