You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "yanwencheng (via GitHub)" <gi...@apache.org> on 2024/09/12 06:03:16 UTC

[I] sql function cipherColumn not performed [shardingsphere]

yanwencheng opened a new issue, #32835:
URL: https://github.com/apache/shardingsphere/issues/32835

   
   shardingsphere-jdbc-core: 5.5.0
   mysql:8.0.24
   
   When I set cipherColumn as name,the select statement contains CONCAT_WS。The decryption method is not performed
   
   the same issue is CASE statement within an SQL SELECT query to conditionally return different encrypted fields such as user_name or phone and aliasing the result, it's possible that the encryption/decryption does not work as expected.


-- 
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] sql function cipherColumn not performed [shardingsphere]

Posted by "thicv (via GitHub)" <gi...@apache.org>.
thicv commented on issue #32835:
URL: https://github.com/apache/shardingsphere/issues/32835#issuecomment-2350870260

   @yanwencheng The encryption feature in ShardingSphere currently only supports simple column encryption and decryption, and does not support functions, expressions, or other complex SQL encryption or decryption. The SphereEx commercial edition has a database UDF (User-Defined Function) feature that can adapt to more complex SQL encryption and decryption based on UDFs. Recommand your have a try : https://www.sphere-ex.cn/


-- 
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] sql function cipherColumn not performed [shardingsphere]

Posted by "terrymanu (via GitHub)" <gi...@apache.org>.
terrymanu closed issue #32835: sql function cipherColumn not performed
URL: https://github.com/apache/shardingsphere/issues/32835


-- 
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] sql function cipherColumn not performed [shardingsphere]

Posted by "taojintianxia (via GitHub)" <gi...@apache.org>.
taojintianxia commented on issue #32835:
URL: https://github.com/apache/shardingsphere/issues/32835#issuecomment-2348756035

   The commercial version can support these complex encrypted SQL queries through UDF, whereas the open-source version does not have this capability and therefore cannot support it.
   
   You could have a try : https://www.sphere-ex.cn/


-- 
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] sql function cipherColumn not performed [shardingsphere]

Posted by "terrymanu (via GitHub)" <gi...@apache.org>.
terrymanu commented on issue #32835:
URL: https://github.com/apache/shardingsphere/issues/32835#issuecomment-2348013236

   Can you provide the SQL for example?


-- 
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] sql function cipherColumn not performed [shardingsphere]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #32835:
URL: https://github.com/apache/shardingsphere/issues/32835#issuecomment-2375150578

   There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.


-- 
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] sql function cipherColumn not performed [shardingsphere]

Posted by "terrymanu (via GitHub)" <gi...@apache.org>.
terrymanu commented on issue #32835:
URL: https://github.com/apache/shardingsphere/issues/32835#issuecomment-2348705806

   Can not support encrypt column in function expression.


-- 
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] sql function cipherColumn not performed [shardingsphere]

Posted by "terrymanu (via GitHub)" <gi...@apache.org>.
terrymanu commented on issue #32835:
URL: https://github.com/apache/shardingsphere/issues/32835#issuecomment-2348703231

   What is concat_ws


-- 
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] sql function cipherColumn not performed [shardingsphere]

Posted by "taojintianxia (via GitHub)" <gi...@apache.org>.
taojintianxia commented on issue #32835:
URL: https://github.com/apache/shardingsphere/issues/32835#issuecomment-2350866259

   @yanwencheng 
   
   The encryption feature in ShardingSphere currently only supports simple column encryption and decryption, and does not support functions, expressions, or other complex SQL encryption or decryption. The SphereEx commercial edition has a database UDF (User-Defined Function) feature that can adapt to more complex SQL encryption and decryption based on UDFs.
   
   Recommand you have a try https://www.sphere-ex.cn/


-- 
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] sql function cipherColumn not performed [shardingsphere]

Posted by "terrymanu (via GitHub)" <gi...@apache.org>.
terrymanu closed issue #32835: sql function cipherColumn not performed
URL: https://github.com/apache/shardingsphere/issues/32835


-- 
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] sql function cipherColumn not performed [shardingsphere]

Posted by "yanwencheng (via GitHub)" <gi...@apache.org>.
yanwencheng commented on issue #32835:
URL: https://github.com/apache/shardingsphere/issues/32835#issuecomment-2348069752

   > Can you provide the SQL for example?
   
   1.the encrypt filed is phone ,user_name
   concat_ws   sql  like  
   ```
   SELECT
   	CONCAT_WS( '-', user_name, phone ) 
   FROM
   	t_sys_user
   ```
   case sql like
   ```
   SELECT
   CASE
   		
   	WHEN
   		user_name THEN
   			user_name ELSE phone 
   			END AS result 
   FROM
   	t_sys_user
   ```


-- 
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