luoyexiaoran opened a new issue, #18949: URL: https://github.com/apache/shardingsphere/issues/18949
error sql: select count(1) from ( select r.name, r.rubbishType,left(cd.collectDate,4) as collectDate,sum(cd.collectVolumeOfToday) as dailyOutput, sum(cd.collectTrashSumNum) as collectTrashSumNum,sum(cd.collectTimes) as collectTimes,cd.districtName,sum(cd.alarmNums) as alarmNum,r.classesName from cc_restaurant_collect_data cd LEFT JOIN cc_restaurant r on cd.restaurantId = r.id where cd.beenDeleted = 0 and r.beenDeleted = 0 and left(cd.collectDate,4)>=? and left(cd.collectDate,4)<=? group by cd.districtId,cd.restaurantId,left(cd.collectDate,4) ) a  every actual sql result is correct! but the aggregate result simply adds up all the results! -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
