You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2022/07/14 06:14:45 UTC
[GitHub] [shardingsphere] novice-gamer opened a new issue, #19133: Error using select statement to obtain data volume
novice-gamer opened a new issue, #19133:
URL: https://github.com/apache/shardingsphere/issues/19133
The version is shardingsphere-5.1.3-snapshot
This table is only a single table, and there is no sub table
error message：
`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)`
--
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: notifications-unsubscribe@shardingsphere.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] novice-gamer commented on issue #19133: Error using select statement to obtain data volume
Posted by GitBox <gi...@apache.org>.
novice-gamer commented on issue #19133:
URL: https://github.com/apache/shardingsphere/issues/19133#issuecomment-1185087223
There is no error message, which is a strange phenomenon when querying; The version used was pulled by the master a month ago
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] github-actions[bot] commented on issue #19133: Error using select statement to obtain data volume
Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #19133:
URL: https://github.com/apache/shardingsphere/issues/19133#issuecomment-1272349373
Hello , this issue has not received a reply for several days.
This issue is supposed to be closed.
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] novice-gamer closed issue #19133: Error using select statement to obtain data volume
Posted by GitBox <gi...@apache.org>.
novice-gamer closed issue #19133: Error using select statement to obtain data volume
URL: https://github.com/apache/shardingsphere/issues/19133
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] strongduanmu commented on issue #19133: Error using select statement to obtain data volume
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #19133:
URL: https://github.com/apache/shardingsphere/issues/19133#issuecomment-1186073849
Hi @novice-gamer, thank you for your feedback. What is the actual count of csys_company_buffer_info table?
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] github-actions[bot] closed issue #19133: Error using select statement to obtain data volume
Posted by GitBox <gi...@apache.org>.
github-actions[bot] closed issue #19133: Error using select statement to obtain data volume
URL: https://github.com/apache/shardingsphere/issues/19133
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] terrymanu commented on issue #19133: Error using select statement to obtain data volume
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #19133:
URL: https://github.com/apache/shardingsphere/issues/19133#issuecomment-1184320426
What is the error message?
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] novice-gamer commented on issue #19133: Error using select statement to obtain data volume
Posted by GitBox <gi...@apache.org>.
novice-gamer commented on issue #19133:
URL: https://github.com/apache/shardingsphere/issues/19133#issuecomment-1186735012
The actual quantity is 563275 lines
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org