LeeGuoPing commented on pull request #11540:
URL: https://github.com/apache/shardingsphere/pull/11540#issuecomment-893122649
The second problem, I only finished tbl env. In tbl there is no
init-db_0.sql. should I do all env ?
***@***.***
From: Zhengqiang Duan
Date: 2021-07-30 15:43
To: apache/shardingsphere
CC: liguoping; Mention
Subject: Re: [apache/shardingsphere] Refactor
SELECT_SQL_BY_ID_ACROSS_SINGLE_AND_SHARDING_TABLES statement with
shardingsphere-integration-test (#11540)
@strongduanmu commented on this pull request.
In
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/tbl/h2/proxy/conf/config-tbl.yaml:
> bindingTables:
- - t_order,t_order_item,t_order_details
+ - t_order,t_order_item,t_order_details,t_order_item_federate_sharding
@LeeGuoPing Why add t_order_item_federate_sharding to bindingTables?
In
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));
@LeeGuoPing t_order_federate is a single table, please move it to
h2/init-db_0.sql
—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub, or unsubscribe.
--
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]
