kimmking commented on issue #7877: URL: https://github.com/apache/shardingsphere/issues/7877#issuecomment-714322384
I test it works well.  ``` schemaName: testproxy dataSources: test0: url: jdbc:mysql://127.0.0.1:3306/test0?serverTimezone=UTC&useSSL=false username: root password: connectionTimeoutMilliseconds: 30000 idleTimeoutMilliseconds: 60000 maxLifetimeMilliseconds: 1800000 maxPoolSize: 50 test1: url: jdbc:mysql://127.0.0.1:3306/test1?serverTimezone=UTC&useSSL=false username: root password: connectionTimeoutMilliseconds: 30000 idleTimeoutMilliseconds: 60000 maxLifetimeMilliseconds: 1800000 maxPoolSize: 50 # insert into test(id,name,created) values(1,'KK01',now()); # insert into test(id,name,created) values(2,'KK02',now()); # insert into test(id,name,created) values(3,'KK03',now()); # insert into test(id,name,created) values(4,'KK04',now()); # insert into test(id,name,created) values(5,'KK05',now()); # insert into test(id,name,created) values(6,'KK06',now()); # insert into test(id,name,created) values(7,'KK07',now()); # insert into test(id,name,created) values(8,'KK08',now()); rules: - !SHARDING tables: test: actualDataNodes: test${0..1}.test0${0..2} tableStrategy: standard: shardingColumn: id shardingAlgorithmName: test_inline keyGenerateStrategy: column: id keyGeneratorName: snowflake defaultDatabaseStrategy: standard: shardingColumn: id shardingAlgorithmName: database_inline defaultTableStrategy: none: shardingAlgorithms: database_inline: type: INLINE props: algorithm-expression: test${id % 2} allow-range-query-with-inline-sharding: true test_inline: type: INLINE props: algorithm-expression: test0${id % 3} allow-range-query-with-inline-sharding: true keyGenerators: snowflake: type: SNOWFLAKE props: worker-id: 123 ``` ---------------------------------------------------------------- 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. For queries about this service, please contact Infrastructure at: [email protected]
