abel533 / Mapper

Mybatis Common Mapper - Easy to use
https://mybatis.io
MIT License
7.32k stars 1.63k forks source link

PageHelper分页是limit ?,?导致异常 #361

Closed 269941633 closed 6 years ago

269941633 commented 6 years ago

java代码

public PageInfo<User> queryPage(String userName,int pageNum,int pageSize){ Page<User> page = PageHelper.startPage(pageNum, pageSize); //PageHelper会自动拦截到下面这查询sql this.userMapper.query(userName); return page.toPageInfo(); }

xml里面的sql

``

异常信息:

sql : select id ,user_name from sys_user where 1=1 limit ?,? com.alibaba.druid.sql.parser.ParserException: syntax error, error in :' 1=1 limit ?,?',expect IDENTIFIER, actual IDENTIFIER limit at com.alibaba.druid.sql.parser.SQLParser.printError(SQLParser.java:239) at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStateme

能得到最终想要的结果。但是有异常日志打印。是druid引起的?

269941633 commented 6 years ago

是druid的问题,使用最新版本1.1.10后就不报错了