Skip to content
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

[BUG] SQL语法解析异常 #6192

Open
puyongqqq opened this issue Oct 23, 2024 · 0 comments
Open

[BUG] SQL语法解析异常 #6192

puyongqqq opened this issue Oct 23, 2024 · 0 comments

Comments

@puyongqqq
Copy link

Database Type

MySQL

Database Version

MySQL 5.7

Druid Version

1.2.23

JDK Version

OpenJDK 17

Error SQL

UPDATE table_a SET ext = '{"extMap":{"address":"1 RenMin's Road, Hang Zhou"}}' WHERE id = 1729512194000

Testcase Code

String sql = "UPDATE table_a SET ext = '{"extMap":{"address":"1 RenMin's Road, Hang Zhou"}}' WHERE id = 172950";
SQLStatement sqlStatement = SQLUtils.parseSingleMysqlStatement(sql);

Stacktrace Info

Exception in thread "main" com.alibaba.druid.sql.parser.ParserException: not supported.pos 58, line 1, column 58, token IDENTIFIER s
at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:654)
at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:106)
at com.alibaba.druid.sql.SQLUtils.parseSingleStatement(SQLUtils.java:626)
at com.alibaba.druid.sql.SQLUtils.parseSingleMysqlStatement(SQLUtils.java:657)

Error Info

已知是 "1 RenMin's Road, Hang Zhou" 的 ' 导致了异常

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant