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 2022/02/07 07:23:59 UTC

[GitHub] [shardingsphere] lanchengx opened a new issue #15275: [DistSQL] Add a syntax COUNT INSTANCE RULES

lanchengx opened a new issue #15275:
URL: https://github.com/apache/shardingsphere/issues/15275


   Hi community,
   this issue is for a new DistSQL syntax.
   
   **Background**
   > Currently, there is already a `show schema rules` syntax for querying the number of rules in a schema, but it is still troublesome to get the number of rules in an instance when there are multiple schemas.
   
   So we intend to provide a syntax for querying all rules in an instance.
   
   **Aim**
   
   | feature  |type  | count
   | ----     | ---- |---- |
   | single_table |table |  2  |
   | sharding     |sharding_table |  2  |
   | sharding |binding_table |  1  |
   | sharding |broadcast_table |  0  |
   | readwrite_splitting |datasource |  1  |
   | db_discovery |datasource |  0  |
   | encrypt  | table |0  |
   | shadow  | datasource |0  |
   
   The syntax is as follows:
   
   ```mysql
   COUNT INSTANCE RULES;
   ```
   
   _Tip: You can refer to the `count schema rules` syntax_
   


-- 
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 #15275: [DistSQL] Add a syntax `COUNT INSTANCE RULES`

Posted by GitBox <gi...@apache.org>.
RaigorJiang closed issue #15275:
URL: https://github.com/apache/shardingsphere/issues/15275


   


-- 
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] strongduanmu commented on issue #15275: [DistSQL] Add a syntax `COUNT INSTANCE RULES`

Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #15275:
URL: https://github.com/apache/shardingsphere/issues/15275#issuecomment-1033344435


   @TaoTaos068 Welcome.


-- 
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] TaoTaos068 commented on issue #15275: [DistSQL] Add a syntax `COUNT INSTANCE RULES`

Posted by GitBox <gi...@apache.org>.
TaoTaos068 commented on issue #15275:
URL: https://github.com/apache/shardingsphere/issues/15275#issuecomment-1033324167


   I would like to contribute in this issue, please assign it to me


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