Soora33 opened a new issue, #25425:
URL: https://github.com/apache/shardingsphere/issues/25425
Why can't we query by id when using id as the sharding column? Similarly,
when I switch to age as the sharding column, age cannot be used as the query
condition either. Here is my configuration.
`
shardingsphere:
datasource:
names: ds0
ds0:
type: com.alibaba.druid.pool.DruidDataSource
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://127.0.0.1:3306/sora33?serverTimezone=UTC
username: root
password: root
rules:
sharding:
tables:
user:
actual-data-nodes: ds0.sora_user0$->{1..2}
table-strategy:
standard:
sharding-column: id
sharding-algorithm-name: user-inline
sharding-algorithms:
user-inline:
type: INLINE
props:
algorithm-expression: sora_user0${id % 2}
keyGenerators:
snowflake:
type: SNOWFLAKE
props:
sql-show: true`
--
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]
