liuchaoheliang opened a new issue #8643:
URL: https://github.com/apache/shardingsphere/issues/8643
my config
spring.shardingsphere.props.query-with-cipher-column=true
spring.shardingsphere.rules.encrypt.encryptors.name_encryptor.type=cName
spring.shardingsphere.rules.encrypt.tables.user_info.columns.name.plainColumn=name
spring.shardingsphere.rules.encrypt.tables.user_info.columns.name.cipherColumn=name_enc
spring.shardingsphere.rules.encrypt.tables.user_info.columns.name.encryptorName=name_encryptor
2020-12-16 14:46:21.938 INFO 2740 --- [ main] ShardingSphere-SQL
: Logic SQL: select t.id as id from (select * from
user_info where name = ? or reg_device_info is not null ) as t where t.name is
not null
2020-12-16 14:46:21.940 INFO 2740 --- [ main] ShardingSphere-SQL
: SQLStatement: MySQLSelectStatement(limit=Optional.empty,
lock=Optional.empty)
2020-12-16 14:46:21.940 INFO 2740 --- [ main] ShardingSphere-SQL
: Actual SQL: ds0 ::: select t.id as id from (select *
from user_info where name = ? or reg_device_info is not null ) as t where
t.name_enc is not null ::: [萨达阿]
why the subquery name column not be rewrite ?
----------------------------------------------------------------
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:
[email protected]
