We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
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
SQL: SELECT temp.* FROM flow_instance_data CROSS JOIN JSON_TABLE( flow_instance_data.business_data, '$.payDetails[*]' COLUMNS ( workNum varchar(255) PATH '$.workNum', staffName varchar(255) PATH '$.staffName' ) ) AS temp WHERE flow_template_id = 9 AND mark = 0
The text was updated successfully, but these errors were encountered:
解析到right join 抛出错误来
Sorry, something went wrong.
把数据库类型这些都发出来,最好完整的复现异常的测试代码。
No branches or pull requests
SQL:
SELECT temp.*
FROM flow_instance_data
CROSS JOIN JSON_TABLE(
flow_instance_data.business_data,
'$.payDetails[*]' COLUMNS (
workNum varchar(255) PATH '$.workNum',
staffName varchar(255) PATH '$.staffName'
)
) AS temp
WHERE flow_template_id = 9
AND mark = 0
The text was updated successfully, but these errors were encountered: