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/10/10 06:37:38 UTC
[GitHub] [shardingsphere] oulexue opened a new issue, #19409: delete sql question
oulexue opened a new issue, #19409:
URL: https://github.com/apache/shardingsphere/issues/19409
### Which version of ShardingSphere did you use?
sharding jdbc 5.1.2
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-JDBC
### Expected behavior
when execute delete sql with
An error occurred during the delete SQL execution
### Actual behavior
Cannot support Multiple-Table for '[tb_finance_auxiliary_type, tb_finance_voucher_auxiliary]'.### Reason analyze (If you can)
### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
DELETE FROM tb_finance_voucher_auxiliary where auxiliary_type in (SELECT id from tb_finance_auxiliary_type where sob_id=#{id});
### Example codes for reproduce this issue (such as a github link).
--
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] TeslaCN closed issue #19409: delete sql question
Posted by GitBox <gi...@apache.org>.
TeslaCN closed issue #19409: delete sql question
URL: https://github.com/apache/shardingsphere/issues/19409
--
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] github-actions[bot] closed issue #19409: delete sql question
Posted by GitBox <gi...@apache.org>.
github-actions[bot] closed issue #19409: delete sql question
URL: https://github.com/apache/shardingsphere/issues/19409
--
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 commented on issue #19409: delete sql question
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #19409:
URL: https://github.com/apache/shardingsphere/issues/19409#issuecomment-1193575064
Please split the SQL to 2 SQLs for each to be delete table.
--
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] github-actions[bot] commented on issue #19409: delete sql question
Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #19409:
URL: https://github.com/apache/shardingsphere/issues/19409#issuecomment-1272349284
Hello , this issue has not received a reply for several days.
This issue is supposed to be closed.
--
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