[GitHub] [shardingsphere] cheese8 commented on issue #17196: encrypt config queryWithCipherColumn is support column levels？

[GitBox <gi...@apache.org>]

cheese8 commented on issue #17196:
URL: https://github.com/apache/shardingsphere/issues/17196#issuecomment-1119225344

   > > Hi @zhaoguhong what is your business scenario, and you need to switch between encryption and decryption at the column level?
   > 
   > My table, contains historical data
   > 
   > ```sql
   > create table t_encrypt
   > (
   >     id           bigint unsigned auto_increment primary key,
   >     phone        varchar(100) null,
   >     address       varchar(100) null
   > );
   > ```
   > 
   > After encryption the phone column
   > 
   > now `queryWithCipherColumn` is true
   > 
   > but my boss say address also need to encrypt，What should I do?
   
   As now `queryWithCipherColumn `  effected on global and table level, maybe you can rollback the `phone` column, when the whole table finished encryption, then commit the whole table. @zhaoguhong


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