You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "RaigorJiang (via GitHub)" <gi...@apache.org> on 2023/04/12 03:05:06 UTC
[GitHub] [shardingsphere] RaigorJiang opened a new issue, #25128: Algorithm information is missing in the result set of `SHOW SHADOW RULES`
RaigorJiang opened a new issue, #25128:
URL: https://github.com/apache/shardingsphere/issues/25128
- SHOW MASK RULES
```sql
mysql> SHOW MASK RULES;
+---------+----------+------------------+--------------------------------+
| table | column | algorithm_type | algorithm_props |
+---------+----------+------------------+--------------------------------+
| t_mask | phoneNum | MASK_FROM_X_TO_Y | to-y=2,replace-char=*,from-x=1 |
| t_mask | address | MD5 | |
| t_order | order_id | MD5 | |
| t_user | user_id | MASK_FROM_X_TO_Y | to-y=2,replace-char=*,from-x=1 |
+---------+----------+------------------+--------------------------------+
4 rows in set (0.01 sec)
```
- SHOW SHADOW RULES
```sql
mysql> SHOW SHADOW RULES FROM shadow_db;
+-------------+-------------+-------------+----------------------+
| rule_name | source_name | shadow_name | shadow_table |
+-------------+-------------+-------------+----------------------+
| shadow_rule | ds_0 | ds_1 | t_order_item,t_order |
+-------------+-------------+-------------+----------------------+
1 row in set (0.00 sec)
```
From the comparison, we can find that the result of `SHOW SHADOW RULES` lacks algorithm information, which needs to be supplemented.
--
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.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang commented on issue #25128: Algorithm information is missing in the result set of `SHOW SHADOW RULES`
Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang commented on issue #25128:
URL: https://github.com/apache/shardingsphere/issues/25128#issuecomment-1504757819
Hello @yx9o , you are welcome to lend a hand.
--
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
[GitHub] [shardingsphere] RaigorJiang closed issue #25128: Algorithm information is missing in the result set of `SHOW SHADOW RULES`
Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang closed issue #25128: Algorithm information is missing in the result set of `SHOW SHADOW RULES`
URL: https://github.com/apache/shardingsphere/issues/25128
--
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
[GitHub] [shardingsphere] yx9o commented on issue #25128: Algorithm information is missing in the result set of `SHOW SHADOW RULES`
Posted by "yx9o (via GitHub)" <gi...@apache.org>.
yx9o commented on issue #25128:
URL: https://github.com/apache/shardingsphere/issues/25128#issuecomment-1504604299
Hi @RaigorJiang , I want to try.
--
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