在使用mybatis的一个无法查询的问题
环境:jdk1.8 数据库mysql
在使用mybatis 去重加分页的时候 出现了下列错误
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: java.lang.UnsupportedOperationException: Cannot support subquery
### The error may exist in com/miya/marketing/dal/coupon/dao/CouponApplyMarketDAO.java (best guess)
### The error may involve com.miya.marketing.dal.coupon.dao.CouponApplyMarketDAO.getPubIdsByCityCode-Inline
### The error occurred while setting parameters
### SQL: SELECT count(0) FROM (SELECT DISTINCT pub_id FROM coupon_apply_market WHERE city_code = ? AND status = 1) table_count
### Cause: java.lang.UnsupportedOperationException: Cannot support subquery
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:79)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:447)
出问题的sql在数据库中是可以执行的,把sql中的DISTINCT 去掉之后 可以正常运行
求解 完全不明白啊