sharding-proxy 只分库 不分表

请问sharding-proxy 只分库 不分表的配置如何配啊,如下两个表,test是分库分表的,配置正常,test_year是只分库不分表的,一直报错

schemaName: sharding_db_new

dataSources:
  ds_0:
    url: jdbc:mysql://10.1.50.194:3306/testdatabase_2021?serverTimezone=UTC&useSSL=false
    username: root
    password: 123456
    connectionTimeoutMilliseconds: 30000
    idleTimeoutMilliseconds: 60000
    maxLifetimeMilliseconds: 1800000
    maxPoolSize: 50
  ds_1:
    url: jdbc:mysql://10.1.50.194:3306/testdatabase_2022?serverTimezone=UTC&useSSL=false
    username: root
    password: 123456
    connectionTimeoutMilliseconds: 30000
    idleTimeoutMilliseconds: 60000
    maxLifetimeMilliseconds: 1800000
    maxPoolSize: 50
  ds_2:
    url: jdbc:mysql://10.1.50.194:3306/testdatabase_2023?serverTimezone=UTC&useSSL=false
    username: root
    password: 123456
    connectionTimeoutMilliseconds: 30000
    idleTimeoutMilliseconds: 60000
    maxLifetimeMilliseconds: 1800000
    maxPoolSize: 50
  ds_3:
    url: jdbc:mysql://10.1.50.194:3306/testdatabase_2024?serverTimezone=UTC&useSSL=false
    username: root
    password: 123456
    connectionTimeoutMilliseconds: 30000
    idleTimeoutMilliseconds: 60000
    maxLifetimeMilliseconds: 1800000
    maxPoolSize: 50
 
rules:
- !SHARDING
  tables:
    test:
      actualDataNodes: ds_$->{0..3}.test_$->{1..2}
      tableStrategy:
        standard:
          shardingColumn: id
          shardingAlgorithmName: test_inline
      keyGenerateStrategy:
        column: id
        keyGeneratorName: snowflake
    test_year:
      actualDataNodes: ds_$->{0..3}.test_year
      tableStrategy:
        standard:
          shardingColumn: id
          shardingAlgorithmName: test_year_inline
      keyGenerateStrategy:
        column: id
        keyGeneratorName: snowflake
  bindingTables:
    - test,test_year
  defaultDatabaseStrategy:
    standard:
      shardingColumn: create_date
      shardingAlgorithmName: database_inline
  defaultTableStrategy:
    none:
  shardingAlgorithms:
    database_inline:
      type: INLINE
      props:
        algorithm-expression: ds_$->{create_date % 2021}
    test_inline:
      type: INLINE
      props:
        algorithm-expression: test_$->{id % 3}
    test_year_inline:
      type: INLINE
      props:
        algorithm-expression: test_year
  keyGenerators:
    snowflake:
      type: SNOWFLAKE
      props:
        worker-id: 123

表结构是一样的:

create table test_1
(`id` int(11) DEFAULT NULL
,`name` varchar(20) DEFAULT NULL
,`create_date1` varchar(20) DEFAULT NULL
, `create_date` int(11) DEFAULT NULL);

create table test_year
(`id` int(11) DEFAULT NULL
,`name` varchar(20) DEFAULT NULL
,`create_date1` varchar(20) DEFAULT NULL
, `create_date` int(11) DEFAULT NULL);

test_year 不分表,为什么要配置 tableStrategy 呢?

test_year:
      actualDataNodes: ds_$->{0..3}.test_year
      tableStrategy:
        standard:
          shardingColumn: id
          shardingAlgorithmName: test_year_inline

这个方式使用广播表了吧。

京ICP备2021015875号