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/15 08:28:03 UTC
[GitHub] [shardingsphere] gzgzapp opened a new issue, #19232: Lose the )for SQL rewriting in shadow database mode
gzgzapp opened a new issue, #19232:
URL: https://github.com/apache/shardingsphere/issues/19232
### Which version of ShardingSphere did you use?
shardingsphere 4.1.1
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-JDBC
### Expected behavior
sharding config:
shardingsphere:
shadow:
column: shadow
shadow-mappings:
ds0: ds2
my sql: select msg_content from test where (submit_id = ?) and shadow = ?
after sharding-jdbc rewrite
sql: select msg_content from test where (submit_id = ?
lost the last )
the log
2022-07-15 16:25:31.106 INFO 10160 --- [ main] o.a.s.s.j.c.s.ShadowPreparedStatement : Rule Type: shadow
2022-07-15 16:25:31.106 INFO 10160 --- [ main] o.a.s.s.j.c.s.ShadowPreparedStatement : SQL: select msg_content from test where (submit_id = ? ::: IsShadowSQL: true
java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
--
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] terrymanu commented on issue #19232: Lose the )for SQL rewriting in shadow database mode
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #19232:
URL: https://github.com/apache/shardingsphere/issues/19232#issuecomment-1185710751
The version 4.x is too old and out of service, please try version 5.x
--
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 closed issue #19232: Lose the )for SQL rewriting in shadow database mode
Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #19232: Lose the )for SQL rewriting in shadow database mode
URL: https://github.com/apache/shardingsphere/issues/19232
--
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