strongduanmu commented on a change in pull request #11540:
URL: https://github.com/apache/shardingsphere/pull/11540#discussion_r679718418
##########
File path:
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/tbl/h2/proxy/conf/config-tbl.yaml
##########
@@ -52,8 +52,14 @@ rules:
standard:
shardingColumn: order_id
shardingAlgorithmName: standard_test
+ t_order_item_federate_sharding:
+ actualDataNodes: tbl.t_order_item_federate_sharding_${0..1}
+ tableStrategy:
+ standard:
+ shardingColumn: item_id
+ shardingAlgorithmName: standard_test
bindingTables:
- - t_order,t_order_item,t_order_details
+ - t_order,t_order_item,t_order_details,t_order_item_federate_sharding
Review comment:
@LeeGuoPing Why add t_order_item_federate_sharding to bindingTables?
##########
File path:
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/tbl/init-sql/h2/init.sql
##########
@@ -78,6 +83,8 @@ CREATE TABLE t_order_9 (order_id INT NOT NULL, user_id INT
NOT NULL, status VARC
CREATE TABLE t_order_item_9 (item_id INT NOT NULL, order_id INT NOT NULL,
user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE, PRIMARY KEY
(item_id));
CREATE INDEX order_index_t_order_9 ON t_order_9 (order_id);
+CREATE TABLE t_order_federate (order_id INT NOT NULL, user_id INT NOT NULL,
status VARCHAR(45) NULL, PRIMARY KEY (order_id));
Review comment:
@LeeGuoPing t_order_federate is a single table, please move it to
`h2/init-db_0.sql`
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
