Multi-table query left join lookup table

[wangjianxin323]

this is my config: dataSources: ds0: driverClassName: com.mysql.jdbc.Driver jdbcUrl: jdbc:mysql://127.0.0.1:3306/sdbilling2?useSSL=true&allowPublicKeyRetrieval=true&socketTimeout=60000&connectTimeout=60000&useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai&rewriteBatchedStatements=true&autoReconnect=true username: root password: '123123FFFfff' dataSourceClassName: com.zaxxer.hikari.HikariDataSource connectionTimeout: 60000 props: sql-show: show rules:

• !SHARDING shardingAlgorithms: table-5: type: HASH_MOD props: sharding-count: 5 table-10: type: HASH_MOD props: sharding-count: 10 table-20: type: HASH_MOD props: sharding-count: 20 defaultTableStrategy: none: autoTables: iotcard_proxy_card: actualDataSources: ds0 shardingStrategy: standard: shardingAlgorithmName: table-10 shardingColumn: user_id iotcard_user_rate: actualDataSources : ds0 shardingStrategy: standard: shardingAlgorithmName: table-10 shardingColumn: user_id iotcard_user_order: actualDataSources : ds0 shardingStrategy: standard: shardingAlgorithmName: table-10 shardingColumn: user_id iotcard_customer_consume: actualDataSources : ds0 shardingStrategy: standard: shardingAlgorithmName: table-10 shardingColumn: member_id iotcard_card_balance_log: actualDataSources : ds0 shardingStrategy: standard: shardingAlgorithmName: table-10 shardingColumn: card_id iotcard_flow_order_log: actualDataSources : ds0 shardingStrategy: standard: shardingAlgorithmName: table-10 shardingColumn: order_id iotcard_fund_change: actualDataSources : ds0 shardingStrategy: standard: shardingAlgorithmName: table-10 shardingColumn: agent_id iotcard_card_relation_user: actualDataSources : ds0 shardingStrategy: standard: shardingAlgorithmName: table-10 shardingColumn: present_user_id iotcard_card_flow: actualDataSources : ds0 shardingStrategy: standard: shardingAlgorithmName: table-20 shardingColumn: card_id iotcard_day_flow: actualDataSources : ds0 shardingStrategy: standard: shardingAlgorithmName: table-20 shardingColumn: card_id

and this is my sql: SELECT COUNT(*) AS total FROM iotcard_user_rate a JOIN iotcard_package b ON a.package_id = b.id JOIN iotcard_package_group c ON b.pack_group_id = c.id WHERE 1 = 1 AND a.user_id = ? AND c.id = ? AND a.up_user_id = ?

Among them iotcard_user_rate I set the sharding，iotcard_package is a single table.

the error is Cause: org.apache.shardingsphere.infra.exception.kernel.metadata.TableNotFoundException: Table or view 'iotcard_package' does not exist. But this table exists in my database.

Can you help me find out what's causing it? My version is 5.5.0

[terrymanu]

Is iotcard_package a single table?

[github-actions[bot]]

There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.