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/10/03 05:41:34 UTC
[GitHub] [shardingsphere] cheese8 opened a new issue #12895: Support INSERT SELECT on encrypt
cheese8 opened a new issue #12895:
URL: https://github.com/apache/shardingsphere/issues/12895
## Feature Request
Support INSERT SELECT on encrypt (test on mysql only)
--
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 removed a comment on issue #12895: Support INSERT SELECT on encrypt
Posted by GitBox <gi...@apache.org>.
cheese8 removed a comment on issue #12895:
URL: https://github.com/apache/shardingsphere/issues/12895#issuecomment-932876445
LogicSQL:
INSERT INTO t_account(account_id, certificate_number, password, amount) SELECT account_id, certificate_number, password, amount from t_account_bak where certificate_number = ?
ActualSQL should be:
INSERT INTO t_account(account_id, cipher_certificate_number, assisted_query_certificate_number, cipher_password, assisted_query_password, cipher_amount) SELECT account_id, cipher_certificate_number, assisted_query_certificate_number, cipher_password, assisted_query_password, cipher_amount from t_account_bak where assisted_query_certificate_number = ?
--
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 #12895: Support INSERT SELECT on encrypt
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #12895:
URL: https://github.com/apache/shardingsphere/issues/12895#issuecomment-937596970
@cheese8 How does InsertPlainColumnAware specifically support insert select statements for different logical columns?
--
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 #12895: Support INSERT SELECT on encrypt
Posted by GitBox <gi...@apache.org>.
strongduanmu closed issue #12895:
URL: https://github.com/apache/shardingsphere/issues/12895
--
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 #12895: Support INSERT SELECT on encrypt
Posted by GitBox <gi...@apache.org>.
cheese8 edited a comment on issue #12895:
URL: https://github.com/apache/shardingsphere/issues/12895#issuecomment-932889312
I know why t_account table has no plain column but t_account_bak table has, I think we should make something (for example InsertPlainColumnAware) like QueryWithCipherColumnAware to control the plain column, but not configured lost or available on rules, and it should effect on one database but not on table.
@tristaZero @strongduanmu What do you think on this?
--
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 #12895: Support INSERT SELECT on encrypt
Posted by GitBox <gi...@apache.org>.
cheese8 commented on issue #12895:
URL: https://github.com/apache/shardingsphere/issues/12895#issuecomment-932889312
@tristaZero @strongduanmu What do you think on this?
--
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 #12895: Support INSERT SELECT on encrypt
Posted by GitBox <gi...@apache.org>.
cheese8 edited a comment on issue #12895:
URL: https://github.com/apache/shardingsphere/issues/12895#issuecomment-932876445
LogicSQL:
INSERT INTO t_account(account_id, certificate_number, password, amount) SELECT account_id, certificate_number, password, amount from t_account_bak where certificate_number = ?
ActualSQL should be:
INSERT INTO t_account(account_id, cipher_certificate_number, assisted_query_certificate_number, cipher_password, assisted_query_password, cipher_amount) SELECT account_id, cipher_certificate_number, assisted_query_certificate_number, cipher_password, assisted_query_password, cipher_amount from t_account_bak where assisted_query_certificate_number = ?
--
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 #12895: Support INSERT SELECT on encrypt
Posted by GitBox <gi...@apache.org>.
cheese8 commented on issue #12895:
URL: https://github.com/apache/shardingsphere/issues/12895#issuecomment-932876445
LogicSQL:
INSERT INTO t_account(account_id, certificate_number, password, amount) SELECT account_id, certificate_number, password, amount from t_account_bak where certificate_number = ?
ActualSQL should be:
INSERT INTO t_account(account_id, cipher_certificate_number, assisted_query_certificate_number, cipher_password, assisted_query_password, cipher_amount) SELECT account_id, cipher_certificate_number, assisted_query_certificate_number, plain_certificate_number, cipher_password, assisted_query_password, plain_password, cipher_amount, plain_amount from t_account_bak where assisted_query_certificate_number = ?
--
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 #12895: Support INSERT SELECT on encrypt
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #12895:
URL: https://github.com/apache/shardingsphere/issues/12895#issuecomment-937596970
@cheese8 How does InsertPlainColumnAware specifically support insert select statements for different logical columns?
--
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 #12895: Support INSERT SELECT on encrypt
Posted by GitBox <gi...@apache.org>.
cheese8 edited a comment on issue #12895:
URL: https://github.com/apache/shardingsphere/issues/12895#issuecomment-932889312
I know why t_account table has no plain column but t_account_bak table has, I think we should make something (for example InsertPlainColumnAware) like QueryWithCipherColumnAware to control the plain column, but not configured lost or available on rules.
@tristaZero @strongduanmu What do you think on this?
--
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