[GitHub] [shardingsphere] CrackerSuperior commented on issue #12611: Why are SQL execution results different?

[GitBox <gi...@apache.org>]

CrackerSuperior commented on issue #12611:
URL: https://github.com/apache/shardingsphere/issues/12611#issuecomment-924542475


   > @CrackerSuperior Can you provide your config?
   
   ``` yaml
   schemaName: test
   
   dataSources:
    ds_0:
      url: jdbc:mysql://172.18.40.194:3306/test?serverTimezone=UTC&useSSL=false
      username: pcloud
      password: pcloud
      connectionTimeoutMilliseconds: 30000
      idleTimeoutMilliseconds: 60000
      maxLifetimeMilliseconds: 1800000
      maxPoolSize: 50
      minPoolSize: 1
      maintenanceIntervalMilliseconds: 30000
    ds_1:
      url: jdbc:mysql://172.18.40.195:3306/test?serverTimezone=UTC&useSSL=false
      username: pcloud
      password: pcloud
      connectionTimeoutMilliseconds: 30000
      idleTimeoutMilliseconds: 60000
      maxLifetimeMilliseconds: 1800000
      maxPoolSize: 50
      minPoolSize: 1
      maintenanceIntervalMilliseconds: 30000
    ds_2:
      url: jdbc:mysql://172.18.40.196:3306/test?serverTimezone=UTC&useSSL=false
      username: pcloud
      password: pcloud
      connectionTimeoutMilliseconds: 30000
      idleTimeoutMilliseconds: 60000
      maxLifetimeMilliseconds: 1800000
      maxPoolSize: 50
      minPoolSize: 1
      maintenanceIntervalMilliseconds: 30000
    ds_3:
      url: jdbc:mysql://172.18.40.198:3306/test?serverTimezone=UTC&useSSL=false
      username: pcloud
      password: pcloud
      connectionTimeoutMilliseconds: 30000
      idleTimeoutMilliseconds: 60000
      maxLifetimeMilliseconds: 1800000
      maxPoolSize: 50
      minPoolSize: 1
      maintenanceIntervalMilliseconds: 30000
   
   rules:
   - !SHARDING
    tables:
      acct_retn_evt_c:
        actualDataNodes: ds_${0..3}.acct_retn_evt_c
        keyGenerateStrategy:
          column: acct_retn_detl_id
          keyGeneratorName: snowflake
      acct_retn_evt_c_b:
        actualDataNodes: ds_${0..3}.acct_retn_evt_c_b
        keyGenerateStrategy:
          column: acct_retn_detl_id
          keyGeneratorName: snowflake
    bindingTables:
      - acct_retn_evt_c,acct_retn_evt_c_b
    defaultDatabaseStrategy:
      standard:
        shardingColumn: acct_retn_detl_id
        shardingAlgorithmName: database_inline
    defaultTableStrategy:
      none:
   
    shardingAlgorithms:
      database_inline:
        type: INLINE
        props:
          algorithm-expression: ds_${acct_retn_detl_id % 4}
    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.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org