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/10/10 06:31:32 UTC
[GitHub] [shardingsphere] Qianyi951015 opened a new issue, #21055: No error exception when creating a sharding strategy by using a inconsistent type from the sharding algorithm type
Qianyi951015 opened a new issue, #21055:
URL: https://github.com/apache/shardingsphere/issues/21055
## 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 Invalid algorithms.
### Actual behavior
Successful created sharding strategy with no exception.
### Reason analyze (If you can)
The type verification of the type of the sharding strategy and the sharding algorithm may not be perfect.
### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
1. add resource
```
ADD RESOURCE resource_0 (
HOST="127.0.0.1",
PORT=3306,
DB="db0",
USER="root",
PASSWORD="123456"
);
```
2. create sharding algorithm
```
CREATE SHARDING ALGORITHM database_inline
(TYPE(NAME="inline",PROPERTIES("algorithm-expression"="t_order_item_${order_id % 2}")));
```
3. create sharding strategy
```
CREATE DEFAULT SHARDING DATABASE STRATEGY
(TYPE="hint",SHARDING_COLUMN=order_id,SHARDING_ALGORITHM=database_inline);
```
### Comments
In this issue, a sharding strategy of type hint is created using the inline sharding algorithm(the type should be standard). It's just an example . It does not mean that the problem only occurs in the inline algorithm and the hint type, the other two types(standard, complex) also have the same problem.
--
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] Qianyi951015 commented on issue #21055: No error exception when creating a sharding strategy by using a inconsistent type from the sharding algorithm type
Posted by "Qianyi951015 (via GitHub)" <gi...@apache.org>.
Qianyi951015 commented on issue #21055:
URL: https://github.com/apache/shardingsphere/issues/21055#issuecomment-1409728043
> Hi @Qianyi951015 , I think this issue has been fixed by #22926, could you check it?
sure i will check it
--
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 #21055: No error exception when creating a sharding strategy by using a inconsistent type from the sharding algorithm type
Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang commented on issue #21055:
URL: https://github.com/apache/shardingsphere/issues/21055#issuecomment-1409889672
@Qianyi951015 Thank you for your verification, I will continue 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] Qianyi951015 commented on issue #21055: No error exception when creating a sharding strategy by using a inconsistent type from the sharding algorithm type
Posted by "Qianyi951015 (via GitHub)" <gi...@apache.org>.
Qianyi951015 commented on issue #21055:
URL: https://github.com/apache/shardingsphere/issues/21055#issuecomment-1409879037
@RaigorJiang same
--
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] github-actions[bot] closed issue #21055: No error exception when creating a sharding strategy by using a inconsistent type from the sharding algorithm type
Posted by GitBox <gi...@apache.org>.
github-actions[bot] closed issue #21055: No error exception when creating a sharding strategy by using a inconsistent type from the sharding algorithm type
URL: https://github.com/apache/shardingsphere/issues/21055
--
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] github-actions[bot] commented on issue #21055: No error exception when creating a sharding strategy by using a inconsistent type from the sharding algorithm type
Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #21055:
URL: https://github.com/apache/shardingsphere/issues/21055#issuecomment-1272348368
Hello , this issue has not received a reply for several days.
This issue is supposed to be closed.
--
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 #21055: No error exception when creating a sharding strategy by using a inconsistent type from the sharding algorithm type
Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang closed issue #21055: No error exception when creating a sharding strategy by using a inconsistent type from the sharding algorithm type
URL: https://github.com/apache/shardingsphere/issues/21055
--
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 #21055: No error exception when creating a sharding strategy by using a inconsistent type from the sharding algorithm type
Posted by "Qianyi951015 (via GitHub)" <gi...@apache.org>.
Qianyi951015 commented on issue #21055:
URL: https://github.com/apache/shardingsphere/issues/21055#issuecomment-1409827299
Hi @RaigorJiang I dont think this issue was fully fixed, as the figure shows below there is still no error exception when I was creating default sharding strategy by using `inline` algorithm with `hint` type
--
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 #21055: No error exception when creating a sharding strategy by using a inconsistent type from the sharding algorithm type
Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang commented on issue #21055:
URL: https://github.com/apache/shardingsphere/issues/21055#issuecomment-1409861084
@Qianyi951015
Thank you, what about `CREATE SHARDING TABLE RULE`?
--
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 #21055: No error exception when creating a sharding strategy by using a inconsistent type from the sharding algorithm type
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #21055:
URL: https://github.com/apache/shardingsphere/issues/21055#issuecomment-1254482050
Hi @Qianyi951015
I found @sunkai-cai is working on the same issue. Refer to #20777.
--
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 #21055: No error exception when creating a sharding strategy by using a inconsistent type from the sharding algorithm type
Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang commented on issue #21055:
URL: https://github.com/apache/shardingsphere/issues/21055#issuecomment-1409727337
Hi @Qianyi951015 ,
I think this issue has been fixed by #22926, could you check it?
--
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