最近在项目中遇到个比较奇怪的问题,使用QueryWrapper查询一条数据时,如果表中有大于1条命中,则会报:org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.TooManyResultsException: Expected one result (or null) to be returned by selectOne(), but found: 2 异常。
代码如下:
QueryWrapper<Crm> queryWrapper = new QueryWrapper<>();
queryWrapper.lambda().eq(Crm::getShopId, cdtShopId)
.orderByDesc(Crm::getId).last(" limit 1");
return baseMapper