You signed in with another tab or window.
Reload
to refresh your session.
You signed out in another tab or window.
Reload
to refresh your session.
You switched accounts on another tab or window.
Reload
to refresh your session.
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
JSON_TABLE(json_col, '$.people[*]' COLUMNS (
name VARCHAR(40) PATH '$.name',
address VARCHAR(100) PATH '$.address')
) people;
问题代码:com.alibaba.druid.sql.dialect.mysql.ast.expr.MySqlJSONTableExpr 的 toString()
问题描述:想通过druid解析sql代码实例如下:
SQLStatementParser parser = SQLParserUtils.createSQLStatementParser(sql, dbType); final List<SQLStatement> sqlStatements = parser.parseStatementList();
发现当sql中含有 JSON_TABLE 会导致解析后的sql缺少一个逗号,执行时直接抛异常。