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 2021/09/29 12:20:50 UTC
[GitHub] [shardingsphere] cheese8 opened a new issue #12825: Support subQuery on encrypt rewrite
cheese8 opened a new issue #12825:
URL: https://github.com/apache/shardingsphere/issues/12825
@tristaZero @strongduanmu
Support subQuery on encrypt rewrite, the following is under the plan to support, others are welcome to leave a message.
LogicSQL:
INSERT INTO `user` (username, id_no, mobile) SELECT username, id_no, mobile FROM `user_bak` WHERE mobile= #{mobile}
ActualSQL:
INSERT INTO `user` (username, id_no_cipher, id_no_hash, id_no, mobile_cipher, mobile_hash, mobile) SELECT username, id_no_cipher, id_no_hash, id_no, mobile_cipher, mobile_hash, mobile FROM `user_bak` WHERE mobile_hash= #{mobile}
LogicSQL:
update `user` set username=?, id_no=?, mobile=? where mobile in (select mobile from `user_bak`)
ActualSQL:
update `user` set username=?, id_no_cipher=?, id_no_hash=?, id_no=?, mobile_cipher=?, mobile_hash=?, mobile=? where mobile_hash in (select mobile_hash from `user_bak`)
LogicSQL:
delete from `user` where mobile in (select mobile from `user_bak`)
ActualSQL:
delete from `user` where mobile_hash in (select mobile_hash from `user_bak`)
LogicSQL:
SELECT username, id_no, mobile FROM user WHERE mobile in (select mobile from `user_bak`)
ActualSQL:
SELECT username, id_no_cipher, id_no_hash, id_no, mobile_cipher, mobile_hash, mobile FROM `user` WHERE mobile_hash in (select mobile_hash from `user_bak`)
--
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 #12825: Support subQuery on encrypt rewrite
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #12825:
URL: https://github.com/apache/shardingsphere/issues/12825#issuecomment-930316978
Which version did you use?
--
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] cheese8 commented on issue #12825: Support not nest subquery on encrypt rewrite
Posted by GitBox <gi...@apache.org>.
cheese8 commented on issue #12825:
URL: https://github.com/apache/shardingsphere/issues/12825#issuecomment-961137135
Plans to split into below sub-PRs to submit:
- [ ] Support not nested subquery (from Projections, TableSegment and Expression) on SelectStatement
- [ ] Support not nested subquery (from Projections, TableSegment and Expression) on UpdateStatement
- [ ] Support not nested subquery (from Projections, TableSegment and Expression) on DeleteStatement
--
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] strongduanmu closed issue #12825: Support not nest subquery on encrypt rewrite
Posted by GitBox <gi...@apache.org>.
strongduanmu closed issue #12825:
URL: https://github.com/apache/shardingsphere/issues/12825
--
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 #12825: Support subQuery on encrypt rewrite
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #12825:
URL: https://github.com/apache/shardingsphere/issues/12825#issuecomment-930316978
Which version did you use?
--
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 edited a comment on issue #12825: Support subQuery on encrypt rewrite
Posted by GitBox <gi...@apache.org>.
terrymanu edited a comment on issue #12825:
URL: https://github.com/apache/shardingsphere/issues/12825#issuecomment-930316978
Which the version did you use?
--
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 edited a comment on issue #12825: Support subQuery on encrypt rewrite
Posted by GitBox <gi...@apache.org>.
terrymanu edited a comment on issue #12825:
URL: https://github.com/apache/shardingsphere/issues/12825#issuecomment-930316978
Which the version did you use?
--
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] cheese8 commented on issue #12825: Support subQuery on encrypt rewrite
Posted by GitBox <gi...@apache.org>.
cheese8 commented on issue #12825:
URL: https://github.com/apache/shardingsphere/issues/12825#issuecomment-939845611
- [ ] subquery from Projections
- [ ] subquery from TableSegment
- [ ] subquery from Expression
--
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] cheese8 commented on issue #12825: Support subQuery on encrypt rewrite
Posted by GitBox <gi...@apache.org>.
cheese8 commented on issue #12825:
URL: https://github.com/apache/shardingsphere/issues/12825#issuecomment-931322587
I would try to fix and pr it, please assign it to me, thanks. @strongduanmu
--
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] strongduanmu commented on issue #12825: Support subQuery on encrypt rewrite
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #12825:
URL: https://github.com/apache/shardingsphere/issues/12825#issuecomment-931806778
@cheese8 Thank you for your feedback, I have assigned this issue to you.
--
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] cheese8 edited a comment on issue #12825: Support not nest subquery on encrypt rewrite
Posted by GitBox <gi...@apache.org>.
cheese8 edited a comment on issue #12825:
URL: https://github.com/apache/shardingsphere/issues/12825#issuecomment-939845611
- [√] not nested subquery from Projections
- [√] not nested subquery from TableSegment
- [√] not nested subquery from Expression
- [x] in test
--
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