You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "StackRui (via GitHub)" <gi...@apache.org> on 2023/06/20 12:46:00 UTC
[GitHub] [shardingsphere] StackRui opened a new issue, #26464: When shardingsphere proxy rewrites SQL, native characters similar to toString that have not been rewritten appear in the SQL body
StackRui opened a new issue, #26464:
URL: https://github.com/apache/shardingsphere/issues/26464
## Question
When I executed a batch insert statement in shardingsphere proxy 5.1.2, the Actual SQL was rewritten as ` Insert INTO life_ cycle_tag_static (tag_id, tag_key, tenant_id, tag_value, 'add', loss, total, base_time) VALUES org.apache.shardingsphere.sharding.rewrite.token.pojo.ShardingInsertValuesToken@5d853edc ON DUPLICATE KEY UPDATE ` total `=values (` total `)` please note the `org.apache.shardingsphere.sharding.rewrite.token.pojo.ShardingInsertValuesToken@5d853edc` Why is this happening? Such SQL will definitely report an error. But after restarting shardingsphere-proxy, the abnormality disappeared and everything was normal. I don't know how to reproduce this problem because I don't even know how it happened? I am looking forward to any possible feedback on the reasons.
Here are some logs:
`[INFO ] 2023-06-19 15:01:38.631 [ShardingSphere-Command-46829] ShardingSphere-SQL - Logic SQL: INSERT INTO life_cycle_tag_statistic(tag_id, tag_key, tenant_id, tag_value, `add`, loss, total, base_time) VALUES (0, 'tag_0', 1, 'tag_0', 0, 0, 0, 1687158098487) ,(1, 'tag_1', 1, 'tag_1', 1, 1, 1, 1687158098487) ,(2, 'tag_2', 1, 'tag_2', 2, 2, 2, 1687158098487) ON DUPLICATE KEY UPDATE `total`= values(`total`)
[INFO ] 2023-06-19 15:01:38.631 [ShardingSphere-Command-46829] ShardingSphere-SQL - SQLStatement: MySQLInsertStatement(setAssignment=Optional.empty, onDuplicateKeyColumns=Optional[org.apache.shardingsphere.sql.parser.sql.common.segment.dml.column.OnDuplicateKeyColumnsSegment@63b26b46])
[INFO ] 2023-06-19 15:01:38.631 [ShardingSphere-Command-46829] ShardingSphere-SQL - Actual SQL: ds ::: INSERT INTO life_cycle_tag_statistic(tag_id, tag_key, tenant_id, tag_value, `add`, loss, total, base_time) VALUES org.apache.shardingsphere.sharding.rewrite.token.pojo.ShardingInsertValuesToken@5d853edc ON DUPLICATE KEY UPDATE `total`= values(`total`)`
--
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] StackRui commented on issue #26464: When shardingsphere proxy rewrites SQL, native characters similar to toString that have not been rewritten appear in the SQL body
Posted by "StackRui (via GitHub)" <gi...@apache.org>.
StackRui commented on issue #26464:
URL: https://github.com/apache/shardingsphere/issues/26464#issuecomment-1599953761
I reproduced the problem, but felt that it was impossible, but it did happen, and I was very confused
--
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] TeslaCN closed issue #26464: When shardingsphere proxy rewrites SQL, native characters similar to toString that have not been rewritten appear in the SQL body
Posted by "TeslaCN (via GitHub)" <gi...@apache.org>.
TeslaCN closed issue #26464: When shardingsphere proxy rewrites SQL, native characters similar to toString that have not been rewritten appear in the SQL body
URL: https://github.com/apache/shardingsphere/issues/26464
--
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] TeslaCN commented on issue #26464: When shardingsphere proxy rewrites SQL, native characters similar to toString that have not been rewritten appear in the SQL body
Posted by "TeslaCN (via GitHub)" <gi...@apache.org>.
TeslaCN commented on issue #26464:
URL: https://github.com/apache/shardingsphere/issues/26464#issuecomment-1605912628
Duplicate with https://github.com/apache/shardingsphere/issues/18456
--
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