MySQL function not implemented: ->

[dengn]

Function Information

Function Name: ->
Category: operators

MySQL Function Description

MySQL -> operator:
JSON column path operator

Expected Behavior

Expected behavior:
According to MySQL documentation, the operator should return correct results.

Current Behavior in MatrixOne

This function is not implemented in MatrixOne.

Error Message: (1064, 'SQL parser error: You have an error in your SQL syntax; check the manual that corresponds to your MatrixOne server version for the right syntax to use. syntax error at line 1 column 37 near "

Test Case

SELECT JSON_OBJECT('key', 'value') -> '$.key' AS result1

MySQL Documentation

• MySQL Official Documentation

Request

Please implement the -> function to improve MySQL compatibility.

[fengttt]

This need parser support. We already implemented json_extract.