ppourali commented 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: [email protected] With regards, Apache Git Services
