FindAndCount 分组查询分页-统计总数BUG ？ #1859

New Issue

dafa168 · 2021-02-01T08:44:45Z

dafa168 commented

sql： select count(*) from order group by goods_id ;

这条sql 返回的一个列表，总数取的是第一行数据里的字段。但其实返回的行数只有8行。总数应该是8。

sql： select count(*) from `order` group by goods_id ; 这条sql 返回的一个列表，总数取的是第一行数据里的字段。但其实返回的行数只有8行。总数应该是8。

lunny commented

duplicated with #1726

lunny closed this issue

Sign in to join this conversation.

No Milestone

No Assignees

2 Participants

Notifications

Due Date

The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: xorm/xorm#1859