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:
[email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
