使用select语句会出现获取的数据量错误的情况

版本是5.1.3
错误现象:

mysql> select prov_id from csys_company_buffer_info;
±--------+
| prov_id |
±--------+
| 63 |
。。。。
| 63 |
| 63 |
| 63 |
±--------+
563275 rows in set (0.88 sec)

mysql> select prov_id from csys_company_buffer_info;
±--------+
| prov_id |
±--------+
| 63 |
。。。
| 63 |
| 63 |
| 63 |
| 63 |
±--------+
501 rows in set (0.00 sec)

mysql> select count() from csys_company_buffer_info;
±---------+
| count() |
±---------+
| 563275 |
±---------+
1 row in set (0.25 sec)

这个表没有进行分库分表,只是一个单表。
输出日志:
[INFO ] 2022-07-14 14:36:07.631 [ShardingSphere-Command-20] ShardingSphere-SQL - Logic SQL: select prov_id from csys_company_buffer_info
[INFO ] 2022-07-14 14:36:07.631 [ShardingSphere-Command-20] ShardingSphere-SQL - SQLStatement: MySQLSelectStatement(table=Optional.empty, limit=Optional.empty, lock=Optional.empty, window=Optional.empty)
[INFO ] 2022-07-14 14:36:07.631 [ShardingSphere-Command-20] ShardingSphere-SQL - Actual SQL: ds_2 ::: select prov_id from csys_company_buffer_info"
"

京ICP备2021015875号