Caused by: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Error: Method queryTotal execution error of sql :
SELECT COUNT(1) FROM ( SELECT id,third_code,amount,target_data,code,target_id,target_amount,refund_time,refund_res,channel,verify_time,type,expired_time,uid,cancel_time,create_time,merid,pay_id,use_expired_time,status FROM uni_order
WHERE (code = ? AND uid IN () AND merid = ? AND channel = ? AND type = ? AND create_time >= ? AND create_time < ? AND status <> ?) ORDER BY id DESC ) TOTAL
大致意思 sql 执行误差
仔细看了下日记 发现sql where 条件这块uid 并没有传值 我是少加了判断所以导致
我错误案例:
uids 不为null 但是size为0 所以这个条件是通过的 但是我uids 又没值 ,所以加上size判断就解决了
总结:
where 里面条件可能没有值,所以会报错:sql执行误差