zhujy5 opened a new issue #13235:
URL: https://github.com/apache/shardingsphere/issues/13235
Logic SQL: select user_id,user_name,password,password_assisted from t_user
where user_name=?
Actual SQL: master ::: select
user_id,user_name,password_encrypt,password_assisted from t_user where
user_name=? ::: [user19]
but the result is :
[
{
"userId": 19,
"userName": "user19",
"password": null,
"passwordEncrypt": null,
"passwordAssisted": null
}
]
my config is
t_user:
columns:
# 逻辑列,就是写SQL里面的列，因为实体类的名字和数据库的加密列一致，所以这里都是name
password:
# 原文列
plainColumn: password
# 密文列，用来存储密文数据
cipherColumn: password_encrypt
# 加密器名字
encryptor: encryptor_aes
# 数据脱敏规则配置---end
props:
# 打印SQL
sql:
show: true
check:
table:
metadata: true
# 是否在启动时检查分表元数据一致性
enabled: true
query:
with:
cipher:
column: true
please confirm what happened fir this result?
"password": null, not get actual value
--
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]
