Extracting value from a JSON array using JSON_EXTRACT inconsistent among versions

Step1: Create table

CREATE TABLE IF NOT EXISTS brands (
name VARCHAR(255) NOT NULL,
sold longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL
);

Step2: Insert values into table

INSERT INTO brands (name, sold)
VALUES
('test', '[

{"id":"0","name":"0","count":5000}

,

{"id":"1","name":"1","count":5000}

]'),
('test2', '[

{"id":"0","name":"0","count":10000}

,

{"id":"1","name":"1","count":10000}

]'),
('test3', '[

{"id":"0","name":"0","count":15000}

,

{"id":"1","name":"1","count":15000}

]'),
('test4', '[

{"id":"0","name":"0","count":700}

,

{"id":"1","name":"1","count":700}

]');

Step3: Extract values using query

SELECT name, JSON_EXTRACT(sold, '$[*].count') as cnt FROM brands;

Output is incorrect when running V10.9 and above:

Output is correct when running V10.8 and below:

Test fiddle here: https://dbfiddle.uk/0A5oD29V