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