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/03/07 06:05:05 UTC

[GitHub] [incubator-shardingsphere] terrymanu opened a new issue #4641: Replace query shorthand projections with encrypt

terrymanu opened a new issue #4641: Replace query shorthand projections with encrypt
URL: https://github.com/apache/incubator-shardingsphere/issues/4641
 
 
   The current encrypt feature only can rewrite column projections for encrypt. It does not process shorthand projection.
   To avoid get all sensitive data from database via `*`, we should rewrite SELECT * to SELECT correct encrypt column, just like rewrite column projections do.
   
   ----------------------------------------------------------------
   For unqualified shorthand SQL: 
   
   ```sql
   SELECT * FROM xxx
   ```
   
   should rewrite to:
   
   ```sql
   SELECT regular_col, chiper_col (or plain_col) AS logic_col FROM xxx
   ```
   
   ----------------------------------------------------------------
   
   For qualified shorthand SQL: 
   
   ```sql
   SELECT o.* FROM xxx o
   ```
   
   should rewrite to:
   
   ```sql
   SELECT o.regular_col, o.cipher_col (or o.plain_col) AS logic_col FROM xxx
   ```
   

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

[GitHub] [incubator-shardingsphere] tristaZero closed issue #4641: Replace query shorthand projections with encrypt

Posted by GitBox <gi...@apache.org>.
tristaZero closed issue #4641: Replace query shorthand projections with encrypt
URL: https://github.com/apache/incubator-shardingsphere/issues/4641
 
 
   

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