zt9788 opened a new issue, #25095:
URL: https://github.com/apache/shardingsphere/issues/25095
### Which version of ShardingSphere did you use?
5.3.1
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-JDBC
### Expected behavior
Database DSS1 only has odd tables
Database DSS0 only has even numbered tables
```
demo_table:
# Omitted
actual-data-nodes: dss1.demotable1,demotable3,5 ....,
dss0.demotable0,2,4,....
database-strategy:
standard:
sharding-column: id
sharding-algorithm-name: db-demo_table
table-strategy:
standard:
sharding-column: id
sharding-algorithm-name: table-demo_table
db-demo_table:
type: INLINE
props:
algorithm-expression: demotable_${id % 64}
table-demo_table:
type: INLINE
props:
algorithm-expression: dss${id % 2}
```
When i use the SQL
```
select * from demotable where id in(1,2,3,4)
```
The sharding will throw the exception ,can not find demotable2
I think it's because ShadingJDBC first look for the indicated sub table
route, then execute SQL, and then look for the sub database route
--
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]
