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 2020/07/15 12:32:15 UTC

[GitHub] [shardingsphere] zhf122728281 opened a new issue #6358: Update Case When mode does not support encryption?

zhf122728281 opened a new issue #6358:
URL: https://github.com/apache/shardingsphere/issues/6358


   
   
   ### Which version of ShardingSphere did you use?
       compile 'org.apache.shardingsphere:sharding-jdbc-spring-namespace:4.1.1'
       compile 'org.apache.shardingsphere:sharding-jdbc-core:4.1.1'
   
   ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
           ShardingSphere-JDBC
   
   ### Expected behavior
   
   
   ### Actual behavior
   
   ### Reason analyze (If you can)
   
   ### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
   
   ### Example codes for reproduce this issue (such as a github link).
   


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

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] zhf122728281 commented on issue #6358: Update Case When mode does not support encryption?

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


   @tristaZero Is there any other solution?
   
   


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

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] zhf122728281 edited a comment on issue #6358: Update Case When mode does not support encryption?

Posted by GitBox <gi...@apache.org>.
zhf122728281 edited a comment on issue #6358:
URL: https://github.com/apache/shardingsphere/issues/6358#issuecomment-660603864


   > I think you should be foreach batch in you java code and let here only one update statement in one sql.
   
   
   This puts a lot of pressure on the database and makes execution less efficient.
   
   
   
   Is there any plan to support this later version?


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

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] zhf122728281 commented on issue #6358: Update Case When mode does not support encryption?

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






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

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] zhf122728281 commented on issue #6358: Update Case When mode does not support encryption?

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


   ![image](https://user-images.githubusercontent.com/20379651/87654636-cb17c100-c789-11ea-9b32-4d4363d4d5ff.png)
   
   
   ![image](https://user-images.githubusercontent.com/20379651/87654669-d834b000-c789-11ea-9477-b1f0fee46626.png)
   
   Above, neither of the batch updates can be encrypted.
   
   The field I want to encrypt is this one.   'visitor_phone_num'


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

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] zhf122728281 commented on issue #6358: Update Case When mode does not support encryption?

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


   @tristaZero Is there any plan to support this later version?


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

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] zhf122728281 commented on issue #6358: Update Case When mode does not support encryption?

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


   Is there any other solution?


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

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] tristaZero edited a comment on issue #6358: Update Case When mode does not support encryption?

Posted by GitBox <gi...@apache.org>.
tristaZero edited a comment on issue #6358:
URL: https://github.com/apache/shardingsphere/issues/6358#issuecomment-659291067


   Hi @zhf122728281 Your information is so insufficient. Please provide more, like SQL, log...


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

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] zhf122728281 commented on issue #6358: Update Case When mode does not support encryption?

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


   Multi-line update operation 、 The 'update case when' method doesn't work either.


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

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] tristaZero commented on issue #6358: Update Case When mode does not support encryption?

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


   Hi @zhf122728281 Your information is so insufficient. Please provide more, like SQL, log..


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

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] zhf122728281 commented on issue #6358: Update Case When mode does not support encryption?

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


   > I think you should be foreach batch in you java code and let here only one update statement in one sql.
   
   
   This puts a lot of pressure on the database and makes execution less efficient


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

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] tristaZero commented on issue #6358: Update Case When mode does not support encryption?

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


   @zhf122728281 
   Hi `batch update` you said means the SQL of `update case when`, doesn't it?
   
   Could you set `sql.show` open and provide the `logic SQL` and `actual SQL` in the log?
   
   It will make analysis easier if we could get the SQLs that ShardingJDBC received.
   
   Trista


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

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] zhf122728281 commented on issue #6358: Update Case When mode does not support encryption?

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


   > code
   
   This puts a lot of pressure on the database and makes execution less efficient


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

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] zhf122728281 removed a comment on issue #6358: Update Case When mode does not support encryption?

Posted by GitBox <gi...@apache.org>.
zhf122728281 removed a comment on issue #6358:
URL: https://github.com/apache/shardingsphere/issues/6358#issuecomment-659296372


   Is there any other solution?


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

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] kimmking closed issue #6358: Update Case When mode does not support encryption?

Posted by GitBox <gi...@apache.org>.
kimmking closed issue #6358:
URL: https://github.com/apache/shardingsphere/issues/6358


   


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

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] kimmking commented on issue #6358: Update Case When mode does not support encryption?

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


   I think you should be foreach batch in you java code and let here only one update statement in one sql.


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

For queries about this service, please contact Infrastructure at:
users@infra.apache.org