select count(1) with group by statement return one row when there is actual no data

[peacefulprogram]

Which version of ShardingSphere did you use?

5.5.0

Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?

both ShardingSphere-JDBC and ShardingSphere-Proxy

Reproduce

enviroment:
mysql 5.7
shardingsphere 5.5.0
table:
t_user

the following two sql, only the order by statement is differenet, but have diffenrent result;

1. order by fields is same with group by fields, returns no data
   

2. order by fields is different from group by fields, returns one row
   

they both should returns no data;

Reason analyze

when order by fields is differenet from group by fields, GroupByMemoryMergedResult will be used.
in GroupByMemoryMergedResult, if there is no data, it will try to generate one row, when select fields have count(1), it will renturn 0

[terrymanu]

What is the configuration?

[peacefulprogram]

zookeeper cluster mode, and the sharding rules is in follow image

[terrymanu]

The issue contains only images, which is not conducive to search or code copying by contributors. Could you please recreate an new issue and describe it again using text and code?

[peacefulprogram]

Sure. I'll create a new issue.