JSON_EXTRACT() returns quotes with strings

When working with JSON_EXTRACT() on a path who's value is a string, the function returns the enclosing quotes which are part of the JSON syntax rather than actually part of the value.

SELECT JSON_EXTRACT('{"test":"hi"}', '$.test') AS test

+------+

| test |

+------+

| "hi" |

+------+

1 row in set (0.000 sec)

Expected Result:

+------+

| test |

+------+

| hi |

+------+

1 row in set (0.000 sec)