haj8888888 commented on issue #2391: After using the sharding-proxy sub-table to sub-table, use the PageHelper plug-in to query one-to-many data, and the number of returned records is incorrect. URL: https://github.com/apache/incubator-shardingsphere/issues/2391#issuecomment-492930599 > 1. Also please show me the **desc table** to all your actual tables. > 2. The result of select * from all your actual tables. > 3. Open **server.yaml** in conf directory of sharding-proxy and set **sql.show: true**, this will log actual SQLs to actual databases. `schemaName: sharding_db dataSources: ds_0: url: jdbc:mysql://127.0.0.1:3306/ds_0?serverTimezone=UTC&useSSL=false username: root password: Mec123.. connectionTimeoutMilliseconds: 30000 idleTimeoutMilliseconds: 60000 maxLifetimeMilliseconds: 1800000 maxPoolSize: 50 ds_1: url: jdbc:mysql://127.0.0.1:3306/ds_1?serverTimezone=UTC&useSSL=false username: root password: Mec123.. connectionTimeoutMilliseconds: 30000 idleTimeoutMilliseconds: 60000 maxLifetimeMilliseconds: 1800000 maxPoolSize: 50 shardingRule: tables: t_order: actualDataNodes: ds_${0..1}.t_order_${0..1} tableStrategy: inline: shardingColumn: order_id algorithmExpression: t_order_${order_id % 2} keyGenerator: type: SNOWFLAKE column: order_id t_order_item: actualDataNodes: ds_${0..1}.t_order_item_${0..1} tableStrategy: inline: shardingColumn: order_id algorithmExpression: t_order_item_${order_id % 2} keyGenerator: type: SNOWFLAKE column: order_item_id t_order_union: actualDataNodes: ds_${0..1}.t_order_union${0..1} tableStrategy: inline: shardingColumn: order_id algorithmExpression: t_order_union${order_id % 2} keyGenerator: type: SNOWFLAKE column: order_id bindingTables: - t_order,t_order_union,t_order_item defaultDatabaseStrategy: inline: shardingColumn: user_id algorithmExpression: ds_${user_id % 2} defaultTableStrategy: none: ` -
---------------------------------------------------------------- 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: us...@infra.apache.org With regards, Apache Git Services
