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/06/23 03:20:10 UTC

[GitHub] [shardingsphere] liming0 opened a new issue, #18525: data encryption BUG

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

   yml:
   ![image](https://user-images.githubusercontent.com/50445932/175199677-e048dc84-7f08-46be-b1e6-ed1775829646.png)
    Logic SQL:
   ![image](https://user-images.githubusercontent.com/50445932/175199422-8651b9b8-f5b9-4a12-9f56-e9fb2a05bf47.png)
   Actual SQL:
   ![image](https://user-images.githubusercontent.com/50445932/175199858-17422097-3401-49d6-8dbb-21cbf67bb650.png)
   
   databaseType: PostgreSQL


-- 
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] liming0 commented on issue #18525: data encryption BUG

Posted by GitBox <gi...@apache.org>.
liming0 commented on issue #18525:
URL: https://github.com/apache/shardingsphere/issues/18525#issuecomment-1165252644

   > Try downloading a demo from this link that will allow you to reproduce this encryption bug https://gitee.com/liming3/sharding-demo/tree/demo-5.1.2/
   
   使用这个接口  /api/v1/person  进行数据插入,即可复现这个问题,
   param:
   `{
     "gender": 0,
     "personName": "嘿嘿"
   }`


-- 
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 #18525: data encryption BUG

Posted by GitBox <gi...@apache.org>.
cheese8 commented on issue #18525:
URL: https://github.com/apache/shardingsphere/issues/18525#issuecomment-1165218238

   I did not reproduce it, can you provide your simplified demo?
   ```
   Logic SQL: insert into public.user(username, id_no, mobile) values(?, ?, ?)
   ```
   
   ```
   Actual SQL: public ::: insert into public.user(username, id_no_cipher, id_no_assist, id_no, mobile_cipher, mobile_assist, mobile) values(?, ?, ?, ?, ?, ?, ?) ::: [张三, ZB1ff6408dfdc33b69351105093a7e0744d, ZB2ae81ba5b49560ea5242e558e7ed2d2f75b2d2d33b15b1607294efc3d3e1ffda9, 123456, ZB199d4fe6dda08590d1ce1b45398226450, ZB2af125e9b346d670e04bb8ac8bb22caf981ab272bff8b53a23634623c10badd25, 1234567890]
   ```


-- 
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] liming0 commented on issue #18525: data encryption BUG

Posted by GitBox <gi...@apache.org>.
liming0 commented on issue #18525:
URL: https://github.com/apache/shardingsphere/issues/18525#issuecomment-1165249720

   Try downloading a demo from this link that will allow you to reproduce this encryption bug
   https://gitee.com/liming3/sharding-demo/tree/demo-5.1.2/


-- 
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] terrymanu commented on issue #18525: data encryption BUG

Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #18525:
URL: https://github.com/apache/shardingsphere/issues/18525#issuecomment-1164389563

   What is the version of ShardingSphere?


-- 
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] liming0 commented on issue #18525: data encryption BUG

Posted by GitBox <gi...@apache.org>.
liming0 commented on issue #18525:
URL: https://github.com/apache/shardingsphere/issues/18525#issuecomment-1165111342

   > What is the version of ShardingSphere?
   This problem is in 5.1.2
   Version 5.1.1 does not have this problem. However, there is another problem in 5.1.1. The schema in LogicSQL is removed from actualsql;This problem is in 5.1.2
   


-- 
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] terrymanu closed issue #18525: data encryption BUG

Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #18525: data encryption BUG
URL: https://github.com/apache/shardingsphere/issues/18525


-- 
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 #18525: data encryption BUG

Posted by GitBox <gi...@apache.org>.
cheese8 commented on issue #18525:
URL: https://github.com/apache/shardingsphere/issues/18525#issuecomment-1165303945

   thanks, i will try.


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