search

alibaba / druid

阿里云计算平台DataWorks(https://help.aliyun.com/document_detail/137663.html) 团队出品，为监控而生的数据库连接池
https://github.com/alibaba/druid/wiki
Apache License 2.0
27.91k stars 8.57k forks source link

java.sql.SQLException: sql injection violation, syntax error: syntax error, expect RPAREN, actual IDENTIFIER pos 43, line 1, column 36, token IDENTIFIER INTEGER : SELECT MAX(CAST(ROLE_CODE AS SIGNED INTEGER)) FROM T_MGT_ROLE\r\n### The error may exist in file #2934

Open zeroMolly opened 5 years ago

zeroMolly commented 5 years ago

java.sql.SQLException: sql injection violation, syntax error: syntax error, expect RPAREN, actual IDENTIFIER pos 43, line 1, column 36, token IDENTIFIER INTEGER : SELECT MAX(CAST(ROLE_CODE AS SIGNED INTEGER)) FROM T_MGT_ROLE\r\n### The error may exist in file

zeroMolly commented 5 years ago

CAST(ROLE_CODE AS SIGNED INTEGER) CAST函数不支持吗？

zeroMolly commented 5 years ago

springboot版本为2.0.4.RELEASE