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/02/03 10:49:28 UTC
[GitHub] [shardingsphere] liuchaoheliang opened a new issue #9298: select ...left join ... ,the select cloumn not be rewrite except the frist table encrypt cloumns .
liuchaoheliang opened a new issue #9298:
URL: https://github.com/apache/shardingsphere/issues/9298
version: 5.0.0-alpha
my config
spring.shardingsphere.props.query-with-cipher-column=true
spring.shardingsphere.rules.encrypt.tables.user_info.columns.name.cipherColumn=name_enc
spring.shardingsphere.rules.encrypt.tables.user_info.columns.name.encryptorName=name_encryptor
spring.shardingsphere.rules.encrypt.tables.user_info.columns.mobile.cipherColumn=mobile_enc
spring.shardingsphere.rules.encrypt.tables.user_info.columns.mobile.encryptorName=mobile_encryptor
spring.shardingsphere.rules.encrypt.tables.user_info.columns.ident.cipherColumn=ident_enc
spring.shardingsphere.rules.encrypt.tables.user_info.columns.ident.encryptorName=idcard_encryptor
spring.shardingsphere.rules.encrypt.tables.test_name.columns.phone.cipherColumn=phone_enc
spring.shardingsphere.rules.encrypt.tables.test_name.columns.phone.encryptorName=name_encryptor
spring.shardingsphere.rules.encrypt.tables.users.columns.test_value.cipherColumn=test_value_enc
spring.shardingsphere.rules.encrypt.tables.users.columns.test_value.encryptorName=name_encryptor
Logic SQL: select ui.name,ui.mobile,u.test_value,tn.phone from user_info ui left join users u on u.id = ui.id left join test_name tn on tn.id = u.id where ui.name ='test' group by ui.name
Actual SQL: ds0 ::: select ui.name_enc AS name,ui.mobile_enc AS mobile,**u.test_value,tn.phone** from user_info_0 ui left join users u on u.id = ui.id left join test_name tn on tn.id = u.id where ui.name_enc ='*nGdJAcXN2T+XkR1YXQ+lbYw==' group by **ui.name** ORDER BY ui.name ASC
there u.test_value , tn.phone should be rewrite u.test_value_enc as test_value, tn.phone_enc as phone
and group by ui.name also should be rewrite ui.name_enc , right ?
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] tristaZero commented on issue #9298: select ...left join ... ,the select cloumn not be rewrite except the frist table encrypt cloumns .
Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #9298:
URL: https://github.com/apache/shardingsphere/issues/9298#issuecomment-773005632
@JiekerTime
Please give this SQL with encryption feature a try. It is very likely a point to improve.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] terrymanu closed issue #9298: select ...left join ... ,the select cloumn not be rewrite except the frist table encrypt cloumns .
Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #9298:
URL: https://github.com/apache/shardingsphere/issues/9298
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] terrymanu commented on issue #9298: select ...left join ... ,the select cloumn not be rewrite except the frist table encrypt cloumns .
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #9298:
URL: https://github.com/apache/shardingsphere/issues/9298#issuecomment-773910628
Duplicate with #9334
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] terrymanu closed issue #9298: select ...left join ... ,the select cloumn not be rewrite except the frist table encrypt cloumns .
Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #9298:
URL: https://github.com/apache/shardingsphere/issues/9298
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] terrymanu commented on issue #9298: select ...left join ... ,the select cloumn not be rewrite except the frist table encrypt cloumns .
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #9298:
URL: https://github.com/apache/shardingsphere/issues/9298#issuecomment-773910628
Duplicate with #9334
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org