-
-
Notifications
You must be signed in to change notification settings - Fork 1.3k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Support for JSON_TABLE function from mysql #1713
Comments
Greetings. It is not supported since it is far away from any standard. Since I see no point in that construct (why not just provide a `Sub Query with JSON columns?!) you would need to provide or sponsor an implementation to make it happen. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
It seems that the following json function is not supported:
Failed to process, Error SQL:
SELECT
epcItem.epc
FROM
s_delivery_bill_detail detail
CROSS JOIN JSON_TABLE (
detail.epc_list,
'$[*]' COLUMNS (
epc VARCHAR ( 24 ) path '$.epc'
)
) epcItem
WHERE
bill_id = ?
.....
Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "(" "(" at line 5, column 35. Was expecting one of:
....
Json is an important data type, the support for these will be useful.
The text was updated successfully, but these errors were encountered: