qiannan5566 commented on issue #15975:
URL:
https://github.com/apache/shardingsphere/issues/15975#issuecomment-1074784538
试试把配置的规则中表名配置为大写，
`S_USER$->{Math.abs(loan_no.hashCode())` % 2}
`ds0.S_USER$->{0..1}`
像这样，oracle中会有这个问题
rules:
sharding:
key-generators:
snowflake:
type: snowflake
props:
worker-id: 123
binding-tables:
- s_user
sharding-algorithms:
sharding-user-by-loan-no:
props:
algorithm-expression:
S_USER$->{Math.abs(loan_no.hashCode()) % 2}
type: inline
tables:
s_user:
key-generate-strategy:
column: user_code
key-generator-name: snowflake
actual-data-nodes: ds0.S_USER$->{0..1}
table-strategy:
standard:
sharding-column: loan_no
sharding-algorithm-name:
sharding-user-by-loan-no
--
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-unsubscr...@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
