版本是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"
"