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:
[email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
