[GitHub] [shardingsphere] as882301 commented on issue #9986: 2Unknown exception: [Can not route tables for `[role_relation, ssmember]`, please make sure the tables are in same schema.]

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

as882301 commented on issue #9986:
URL: https://github.com/apache/shardingsphere/issues/9986#issuecomment-815418867


   > 您好@ as882301 @ wangjing112
   > 您能否提供分片配置以及逻辑SQL和实际SQL？
   schemaName: sharding_db
   #
   dataSourceCommon:
   #  username: root
   #  password:
    connectionTimeoutMilliseconds: 30000
    idleTimeoutMilliseconds: 60000
    maxLifetimeMilliseconds: 1800000
    maxPoolSize: 50
    minPoolSize: 1
    maintenanceIntervalMilliseconds: 30000
   #
   dataSources:
    ds_1:
      url: jdbc:mysql://127.0.0.1:3306/shop?serverTimezone=UTC&useSSL=false
      username: shop
      password: Zjw228478
    ds_2:
      url: jdbc:mysql://127.0.0.1:3306/hotel?serverTimezone=UTC&useSSL=false
      username: hotel
      password: 228478
   #
   rules:
   - !SHARDING
    tables:
      test:
        actualDataNodes: ds_${1}.test${1}
        tableStrategy:
          standard:
            shardingColumn: id
            shardingAlgorithmName: test_inline
        keyGenerateStrategy:
          column: id
          keyGeneratorName: snowflake
    
   
   
   SQL  SELECT M.role,M.member_id,M.member_name,M.member_avatar,M.member_mobile FROM role_relation R LEFT JOIN ssmember M ON M.member_id=R.member_id WHERE ( R.bind_id=7 );
   
   
   ssmember  table in shop database
   role_relation table in hotel database
   


-- 
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:
users@infra.apache.org