当前使用版本(必填,否则不予处理)
3.4.0
该问题是如何引起的？(确定最新版也有问题再提!!!)
逻辑删除，正确的sql 应该是
UPDATE mall_goods set is_delete = 1 WHERE id=? AND is_delete=0
重现步骤(如果有就写完整)
Preparing: UPDATE mall_goods WHERE id=? AND is_delete=0
2020-10-18 18:56:08.655 DEBUG 14616 --- [nio-8199-exec-3] c.p.m.d.g.m.MallGoodsMapper.updateById : ==> Parameters: 1317072498139947009(Long) 2020-10-18 18:56:08.656 DEBUG 14616 --- [nio-8199-exec-3] c.p.m.d.g.m.MallGoodsMapper.updateById : ==> Parameters: 1317070633038950401(Long)
报错信息
1、sql执行报错
2、用deleteBatchIds 逻辑删除 报错
Error updating database. Cause: java.lang.IllegalStateException: Type handler was null on parameter mapping for property '__frch_item_0'. It was either not specified and/or could not be found for the javaType (com.xxx.mall.dao.goods.entity.MallGoods) : jdbcType (null) combination.
The error may exist in com/xxx/mall/dao/goods/mapper/MallGoodsMapper.java (best guess)
The error may involve com.xxx.mall.dao.goods.mapper.MallGoodsMapper.deleteBatchIds
The error occurred while executing an update
3、updateBatchById 批量更新其他字段正常 传入的是MallGoods实体 的一个list
Comment From: miemieYaho
mp提供的方法均已屏蔽对逻辑删除字段的update,除非使用updatewrapper.set或setSql来更改值