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/04/07 10:40:54 UTC
[GitHub] [shardingsphere] lixaviers opened a new issue, #16640: SQL does not print parameters after the Read-Write Split are configured
lixaviers opened a new issue, #16640:
URL: https://github.com/apache/shardingsphere/issues/16640
## Bug Report
**For English only**, other languages will not accept.
Before report a bug, make sure you have:
- Searched open and closed [GitHub issues](https://github.com/apache/shardingsphere/issues).
- Read documentation: [ShardingSphere Doc](https://shardingsphere.apache.org/document/current/en/overview).
Please pay attention on issues you submitted, because we maybe need more details.
If no response anymore and we cannot reproduce it on current information, we will **close it**.
Please answer these questions before submitting your issue. Thanks!
### Which version of ShardingSphere did you use?
4.1.1
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-JDBC
SQL print parameters before the Read-Write Split are not configured,SQL does not print parameters after the Read-Write Split are configured.
before
ShardingSphere-SQL - Actual SQL: master ::: SELECT xxxxxxxxxxxx oc_order
WHERE is_deleted=0
AND (order_status = ? AND pay_close_time <= ?) ::: [1, 2022-04-07 18:35:30]
-----------------------------------------------------------------------------------------------------------------------------
after
ShardingSphere-SQL - Actual SQL: slave0 ::: SELECT xxxxxxxxxxxx FROM oc_order
WHERE is_deleted=0
AND (order_status = ? AND pay_close_time <= ?)
`
spring:
shardingsphere:
props:
sql:
show: true`
--
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] zjcnb commented on issue #16640: SQL does not print parameters after the Read-Write Split are configured
Posted by GitBox <gi...@apache.org>.
zjcnb commented on issue #16640:
URL: https://github.com/apache/shardingsphere/issues/16640#issuecomment-1091662735
@lixaviers Hello, 4.1.1 version are too old. Can you try it with 5.1.0 version?
--
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] lixaviers commented on issue #16640: SQL does not print parameters after the Read-Write Split are configured
Posted by GitBox <gi...@apache.org>.
lixaviers commented on issue #16640:
URL: https://github.com/apache/shardingsphere/issues/16640#issuecomment-1095907287
Hello, I tried to upgrade to version 5 and tested it. Found that the main library, every time I try to debug and see `ReadwriteSplittingDataSourceRouter` class, `TransactionHolder.IsTransaction().` All the Transactional operations I've read before used @Transactional(readOnly = true). Now that means getting rid of all @Transactional(readOnly = true) is too expensive
--
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] lixaviers closed issue #16640: SQL does not print parameters after the Read-Write Split are configured
Posted by GitBox <gi...@apache.org>.
lixaviers closed issue #16640: SQL does not print parameters after the Read-Write Split are configured
URL: https://github.com/apache/shardingsphere/issues/16640
--
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