[GitHub] [incubator-shardingsphere] ppourali edited a comment on issue #4507: "Select * From table" returns both plain and cipher columns in the resultset in Sharding-Proxy

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

ppourali edited a comment on issue #4507: "Select * From table" returns both plain and cipher columns in the resultset in Sharding-Proxy
URL: https://github.com/apache/incubator-shardingsphere/issues/4507#issuecomment-592536060
 
 
   Hi @dongzl ,
   
   Thanks for the reply. 
   **Here is my config-encrypt.yaml:**
   
   schemaName: anonymized_db
   dataSource:
     url: jdbc:postgresql://127.0.0.1:5432/database?serverTimezone=UTC&useSSL=false
     username: dbuser
     password: database
     connectionTimeoutMilliseconds: 30000
     idleTimeoutMilliseconds: 60000
     maxLifetimeMilliseconds: 1800000
     maxPoolSize: 50
   
   encryptRule:
     encryptors:
       encryptor_aes:
         type: aes
         props:
           aes.key.value: 123456abc
       encryptor_md5:
         type: md5
     tables:
       test:
         columns:
           data:
             plainColumn: data
             cipherColumn: data_anonymized
             encryptor: encryptor_md5
   
   **Here is the create script for my test table:**
   ` create table public.test (
    id INTEGER not null,
    name character varying (20),
    data text,
    data_anonymized text
   )`
   The data column is what we want to be encrypted. When we run "SELECT * FROM test", it returns both the data and the data_anonymized column. But we expect to only return the data_anonymized column. We use psql shell to run the queries and connect to port 3307.
   
   Please advise.
   
   Thanks,
   Parsa
   

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


With regards,
Apache Git Services