异常现象
c.alibaba.druid.filter.stat.StatFilter : merge sql error, dbType mysql, druid-1.2.19, sql :
······
com.alibaba.druid.sql.parser.ParserException: syntax error, expect ), actual IDENTIFIER pos 282, line 7, column 20, token IDENTIFIER RECURSIVE
at com.alibaba.druid.sql.parser.SQLExprParser.accept(SQLExprParser.java:4626) ~[druid-1.2.19.jar:na]
at com.alibaba.druid.sql.parser.SQLExprParser.primary(SQLExprParser.java:384) ~[druid-1.2.19.jar:na]
at com.alibaba.druid.sql.dialect.mysql.parser.MySqlExprParser.primary(MySqlExprParser.java:527) ~[druid-1.2.19.jar:na]
at com.alibaba.druid.sql.parser.SQLExprParser.expr(SQLExprParser.java:106) ~[druid-1.2.19.jar:na]
at com.alibaba.druid.sql.parser.SQLExprParser.parseSelectItem(SQLExprParser.java:6327) ~[druid-1.2.19.jar:na]
at com.alibaba.druid.sql.parser.SQLSelectParser.parseSelectList(SQLSelectParser.java:1068) ~[druid-1.2.19.jar:na]
at com.alibaba.druid.sql.dialect.mysql.parser.MySqlSelectParser.query(MySqlSelectParser.java:235) ~[druid-1.2.19.jar:na]
at com.alibaba.druid.sql.parser.SQLSelectParser.select(SQLSelectParser.java:61) ~[druid-1.2.19.jar:na]
at com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser.parseSelect(MySqlStatementParser.java:112) ~[druid-1.2.19.jar:na]
at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:200) ~[druid-1.2.19.jar:na]
at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:101) ~[druid-1.2.19.jar:na]
at com.alibaba.druid.sql.visitor.ParameterizedOutputVisitorUtils.parameterize(ParameterizedOutputVisitorUtils.java:164) ~[druid-1.2.19.jar:na]
at com.alibaba.druid.sql.visitor.ParameterizedOutputVisitorUtils.parameterize(ParameterizedOutputVisitorUtils.java:135) ~[druid-1.2.19.jar:na]
at com.alibaba.druid.filter.stat.StatFilter.mergeSql(StatFilter.java:148) ~[druid-1.2.19.jar:na]
at com.alibaba.druid.filter.stat.StatFilter.createSqlStat(StatFilter.java:672) ~[druid-1.2.19.jar:na]
at com.alibaba.druid.filter.stat.StatFilter.statementPrepareAfter(StatFilter.java:325) ~[druid-1.2.19.jar:na]
控制台sql解析报错,不影响接口查询结果
版本
spring-boot 2.7.6
druid-spring-boot-starter 1.2.19
解决方式
druid-spring-boot-starter 1.2.23