yanwencheng commented on issue #32830:
URL:
https://github.com/apache/shardingsphere/issues/32830#issuecomment-2342720699
> You can search `shardingsphere-jdnc
When using a 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 typically happens because encryption/decryption functions or procedures
might be designed to work directly on the data fields before they are evaluated
within the CASE expression.
```
SELECT
*,
CASE
WHEN user_name IS NOT NULL THEN user_name
WHEN phone IS NOT NULL THEN phone
END AS companyName
FROM
xxxx
```
--
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]
