mysql group by error

nested exception is org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Error: Method queryTotal execution error of sql : SELECT COUNT(1) FROM ( SELECT SUM(spl.out_total) outTotal, sp., spl.waybill_no waybillNo FROM sto_warehousing_plan sp LEFT JOIN sto_warehousing_plandtl spl ON sp.id = spl.plan_id LEFT JOIN sto_sku ss ON spl.sku_id = ss.id WHERE sp.is_deleted = ‘0’ AND spl.is_deleted = ‘0’ GROUP BY sp.id ORDER BY sp.update_time DESC ) TOTAL ### The error may exist in class path resource [mapper/StoWarehousingPlanMapper.xml] ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Error: Method queryTotal execution error of sql : SELECT COUNT(1) FROM ( SELECT SUM(spl.out_total) outTotal, sp., spl.waybill_no waybillNo FROM sto_warehousing_plan sp LEFT JOIN sto_warehousing_plandtl spl ON sp.id = spl.plan_id LEFT JOIN sto_sku ss ON spl.sku_id = ss.id WHERE sp.is_deleted = ‘0’ AND spl.is_deleted = ‘0’ GROUP BY sp.id ORDER BY sp.update_time DESC ) TOTAL

SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,’ONLY_FULL_GROUP_BY’,”));

自省推动进步,视野决定未来。
心怀远大理想。
为了家庭幸福而努力。
物流行业算法交流 QQ群:1138428297

Original: https://www.cnblogs.com/aarond/p/16379759.html
Author: McKay
Title: mysql group by error

原创文章受到原创版权保护。转载请注明出处:https://www.johngo689.com/8206/

转载文章受原作者版权保护。转载请注明原作者出处!

(0)

大家都在看

发表回复

登录后才能评论
免费咨询
免费咨询
扫码关注
扫码关注
联系站长

站长Johngo!

大数据和算法重度研究者!

持续产出大数据、算法、LeetCode干货,以及业界好资源!

2022012703491714

微信来撩,免费咨询:xiaozhu_tec

分享本页
返回顶部