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/09/19 06:59:40 UTC

[GitHub] [shardingsphere] Qianyi951015 opened a new issue, #21061: No error exception when Alter unexist sharding binding table rule

Qianyi951015 opened a new issue, #21061:
URL: https://github.com/apache/shardingsphere/issues/21061

## Bug Report

### Which version of ShardingSphere did you use?
master 9c83948cdb49af429851eb2eca9ce10da9dfb7a7
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-Proxy
### Expected behavior
error exception by sharding binding table rule do not exist.
### Actual behavior
Alter sharding binding table rule successful and create a sharding binding table rule

### Screenshot
![181663570696_ pic](https://user-images.githubusercontent.com/57847965/190964507-1cae1c08-b58e-424a-98be-8b11ce15b950.jpg)

### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
1. Create sharding table rules : t_order, t_order_item, t_1, t_2.

2. Show sharding binding table rules to make sure no sharding binding table rules exist .
```
SHOW SHARDING BINDING TABLE RULES;
```
3. Alter sharding binding table rule.
```
ALTER SHARDING BINDING TABLE RULES (t_order,t_order_item),(t_1,t_2);
```
4. Show sharding binding table rules to verify sharding binding table rule had been created.
```
SHOW SHARDING BINDING TABLE RULES;
```

--
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] yx9o commented on issue #21061: No error exception when Alter unexist sharding binding table rule

Posted by GitBox <gi...@apache.org>.

yx9o commented on issue #21061:
URL: https://github.com/apache/shardingsphere/issues/21061#issuecomment-1251818720

   I want to investigate.


-- 
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 #21061: No error exception when Alter unexist sharding binding table rule

Posted by GitBox <gi...@apache.org>.

yx9o commented on issue #21061:
URL: https://github.com/apache/shardingsphere/issues/21061#issuecomment-1251819526

   @Qianyi951015 Can you provide the statement for creating a sharding rule? thanks


-- 
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] Qianyi951015 commented on issue #21061: No error exception when Alter unexist sharding binding table rule

Posted by GitBox <gi...@apache.org>.

Qianyi951015 commented on issue #21061:
URL: https://github.com/apache/shardingsphere/issues/21061#issuecomment-1251823645

   @yx9o May be you also need key generator for creating the sharding table rule
   ```
   CREATE SHARDING KEY GENERATOR snowflake_key_generator(TYPE(NAME="SNOWFLAKE"));
   ```


-- 
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 commented on issue #21061: No error exception when Alter unexist sharding binding table rule

Posted by GitBox <gi...@apache.org>.

RaigorJiang commented on issue #21061:
URL: https://github.com/apache/shardingsphere/issues/21061#issuecomment-1250869898

   Hi @Qianyi951015,Thanks for your feedback!


-- 
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] Qianyi951015 commented on issue #21061: No error exception when Alter unexist sharding binding table rule

Posted by GitBox <gi...@apache.org>.

Qianyi951015 commented on issue #21061:
URL: https://github.com/apache/shardingsphere/issues/21061#issuecomment-1251821857

   @yx9o  Hi here is an example for creating a sharding table rule
   ```
   CREATE SHARDING TABLE RULE t_order_item (
   DATANODES("resource_${0..1}.t_order_item_${0..1}"),
   DATABASE_STRATEGY(TYPE="standard",SHARDING_COLUMN=user_id,SHARDING_ALGORITHM(TYPE(NAME="inline",PROPERTIES("algorithm-expression"="resource_${user_id % 2}")))),
   TABLE_STRATEGY(TYPE="standard",SHARDING_COLUMN=order_id,SHARDING_ALGORITHM=table_inline),
   KEY_GENERATE_STRATEGY(COLUMN=another_id,KEY_GENERATOR=snowflake_key_generator)
   );
   ```


-- 
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 #21061: No error exception when Alter unexist sharding binding table rule

Posted by GitBox <gi...@apache.org>.

RaigorJiang closed issue #21061: No error exception when Alter unexist sharding binding table rule
URL: https://github.com/apache/shardingsphere/issues/21061


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