为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:8
【操作系统】:WIN_64
【CPU】:X86
【问题描述】:mysql数据库迁移达梦数据库;后台执行sql报错,但是不影响程序运行返回结果。sql没有写错,达梦数据库客户端能执行。有没有大佬遇到过,怎么解决?具体报错信息如下:
2023-04-03 15:16:39,771 [http-nio-8080-exec-7] ERROR [com.alibaba.druid.filter.stat.StatFilter] - merge sql error, dbType dm, sql :
SELECT t1.id,t1.loginname,t1.password,t1.personid,t1.personname,t1.email,t1.logincount,t1.islock,t1.validatecode,t1.outdate,t1.status,t1.createuser,t1.createtime,t1.checkno,t1.type,t1.idcard,t1.mobile,t1.address,t2.duty,t2.position,t2.unitid,t2.unitname,t2.deptid,t2.deptname,t2.sex,t2.birth FROM sys_user t1 LEFT JOIN sys_person t2 ON t2.id = t1.personid WHERE 1=1 and t1.region like '13%' order by t1.createtime desc limit ?,?
com.alibaba.druid.sql.parser.ParserException: syntax error, error in :'desc limit ?,?',expect IDENTIFIER, actual IDENTIFIER limit
at com.alibaba.druid.sql.parser.SQLParser.printError(SQLParser.java:230)
at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:324)
at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:120)
at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:115)
at com.alibaba.druid.sql.visitor.ParameterizedOutputVisitorUtils.parameterize(ParameterizedOutputVisitorUtils.java:53)
at com.alibaba.druid.filter.stat.StatFilter.mergeSql(StatFilter.java:145)
at com.alibaba.druid.filter.stat.StatFilter.createSqlStat(StatFilter.java:630)
at com.alibaba.druid.filter.stat.StatFilter.statementPrepareAfter(StatFilter.java:305)
......(超字数了)
框架有问题吧。
把limmit ?,?改成
select top ?,? .... 试试