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