strongduanmu commented on issue #13541:
URL:
https://github.com/apache/shardingsphere/issues/13541#issuecomment-966198847
Hi @Jenyow Thank you very much for the perfect demo, but everything is ok
when I run it. Below is my log.
```
==> Preparing: select count(id) from statistic_data
==> Parameters:
[2021-11-11 18:43:55] [INFO ] http-nio-8080-exec-1 --Logic SQL: select
count(id)
from statistic_data
[2021-11-11 18:43:55] [INFO ] http-nio-8080-exec-1 --SQLStatement:
MySQLSelectStatement(limit=Optional.empty, lock=Optional.empty,
window=Optional.empty)
[2021-11-11 18:43:55] [INFO ] http-nio-8080-exec-1 --Actual SQL:
statistics2020 ::: select count(id)
from statistic_data_1820a01
[2021-11-11 18:43:55] [INFO ] http-nio-8080-exec-1 --Actual SQL:
statistics2020 ::: select count(id)
from statistic_data_1820a02
[2021-11-11 18:43:55] [INFO ] http-nio-8080-exec-1 --Actual SQL:
statistics2020 ::: select count(id)
from statistic_data_1820a03
[2021-11-11 18:43:55] [INFO ] http-nio-8080-exec-1 --Actual SQL:
statistics2021 ::: select count(id)
from statistic_data_1820a01
[2021-11-11 18:43:55] [INFO ] http-nio-8080-exec-1 --Actual SQL:
statistics2021 ::: select count(id)
from statistic_data_1820a02
[2021-11-11 18:43:55] [INFO ] http-nio-8080-exec-1 --Actual SQL:
statistics2021 ::: select count(id)
from statistic_data_1820a03
[2021-11-11 18:43:55] [INFO ] http-nio-8080-exec-1 --Actual SQL:
statistics2022 ::: select count(id)
from statistic_data_1820a01
[2021-11-11 18:43:55] [INFO ] http-nio-8080-exec-1 --Actual SQL:
statistics2022 ::: select count(id)
from statistic_data_1820a02
[2021-11-11 18:43:55] [INFO ] http-nio-8080-exec-1 --Actual SQL:
statistics2022 ::: select count(id)
from statistic_data_1820a03
<== Columns: count(id)
<== Row: 0
<== Total: 1
```
BTW, your sql-show parameter configuration is wrong, it should be configured
as.
```
spring:
application:
name: sharding-demo
main:
allow-bean-definition-overriding: true
shardingsphere:
props:
sql-show: true
datasource:
......
```
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
