shardingjdbc5.2.1分库分表策略不生效

[Domibtinc]

spring:
shardingsphere:
datasource:
names: m1,m2
m1:
type: com.alibaba.druid.pool.DruidDataSource
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://localhost:3306/task_manage_system_1?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai
username: root
password: asd638375
m2:
type: com.alibaba.druid.pool.DruidDataSource
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://localhost:3306/task_manage_system_2?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai
username: root
password: asd638375
rules:
sharding:
tables:
task:
actual-data-nodes: m$->{1..2}.task_$->{0..1}
key-generator:
column: id
type: snowflake
props:
worker:
id: 10
table-strategy:
inline:
sharding-column: user_id
algorithm-expression: task_$->{user_id%2}
database-strategy:
inline:
algorithm-expression: m$->{system_id}
sharding-column: system_id
props:
sql-show: true

Does this configuration have problem? why didnt valid?

[strongduanmu]

Hi @Domibtinc, please submit issue accordint to issue template. Besides, we should write issue in English, other language will not accept.