You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "zyxy2004 (via GitHub)" <gi...@apache.org> on 2025/06/11 07:12:16 UTC
[I] ShardingSphere如何处理复杂查询场景中的加密字段 [shardingsphere]
zyxy2004 opened a new issue, #35672:
URL: https://github.com/apache/shardingsphere/issues/35672
When using ShardingSphere for data encryption in complex query scenarios involving multi-table joins and subqueries, where query conditions include encrypted fields, how does ShardingSphere ensure the correctness of SQL parsing and routing? For example, in an e-commerce order system, there is a join query between the order table t_order and the user table t_user , with the phone_number field in t_user stored encrypted. To query all orders of a user based on their phone number, the SQL might be SELECT * FROM t_order o JOIN t_user u ON o.user_id = u.user_id WHERE u.phone_number =? . How does ShardingSphere handle such cases to ensure accurate and efficient query results?
--
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.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] ShardingSphere如何处理复杂查询场景中的加密字段 [shardingsphere]
Posted by "strongduanmu (via GitHub)" <gi...@apache.org>.
strongduanmu commented on issue #35672:
URL: https://github.com/apache/shardingsphere/issues/35672#issuecomment-2968822420
For English only, other language will not accept.
--
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
Re: [I] ShardingSphere如何处理复杂查询场景中的加密字段 [shardingsphere]
Posted by "strongduanmu (via GitHub)" <gi...@apache.org>.
strongduanmu closed issue #35672: ShardingSphere如何处理复杂查询场景中的加密字段
URL: https://github.com/apache/shardingsphere/issues/35672
--
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