You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2022/11/23 03:42:11 UTC
[GitHub] [shardingsphere] Keanhua opened a new issue, #22349: When I Use Encrypt, How can I solve blank String correctly？
Keanhua opened a new issue, #22349:
URL: https://github.com/apache/shardingsphere/issues/22349
## Question
**For English only**, other languages will not accept.
I config 'A' column need encrypt. When i insert one data ，the 'A' column will be encrypted.
but i config 'A' column default ''. When i insert one data without 'A' column，the 'A' column will be ''.
then when i query with 'A' column, the condition is where 'A'='', i can not query those records with default '' value.
how can i solve it？thanks. i only think i can config default value with the blank encrypted 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: notifications-unsubscribe@shardingsphere.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] tuichenchuxin commented on issue #22349: When I Use Encrypt, How can I solve blank String correctly？
Posted by GitBox <gi...@apache.org>.
tuichenchuxin commented on issue #22349:
URL: https://github.com/apache/shardingsphere/issues/22349#issuecomment-1326042016
There is currently no way to skip the encryption of empty strings.
--
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
[GitHub] [shardingsphere] cheese8 commented on issue #22349: When I Use Encrypt, How can I solve blank String correctly？
Posted by GitBox <gi...@apache.org>.
cheese8 commented on issue #22349:
URL: https://github.com/apache/shardingsphere/issues/22349#issuecomment-1327504077
change default '' into default encrypt('') or make column A in sql explicitly
--
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
[GitHub] [shardingsphere] tuichenchuxin commented on issue #22349: When I Use Encrypt, How can I solve blank String correctly？
Posted by GitBox <gi...@apache.org>.
tuichenchuxin commented on issue #22349:
URL: https://github.com/apache/shardingsphere/issues/22349#issuecomment-1324604819
You can try to change to default null
--
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
[GitHub] [shardingsphere] sandynz closed issue #22349: When I Use Encrypt, How can I solve blank String correctly？
Posted by GitBox <gi...@apache.org>.
sandynz closed issue #22349: When I Use Encrypt, How can I solve blank String correctly？
URL: https://github.com/apache/shardingsphere/issues/22349
--
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
[GitHub] [shardingsphere] Keanhua commented on issue #22349: When I Use Encrypt, How can I solve blank String correctly？
Posted by GitBox <gi...@apache.org>.
Keanhua commented on issue #22349:
URL: https://github.com/apache/shardingsphere/issues/22349#issuecomment-1325992205
> You can try to change to default null
if i change to default null, the column can not create index correctly。
--
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