[GitHub] [shardingsphere] LeeGuoPing commented on pull request #11540: Refactor SELECT_SQL_BY_ID_ACROSS_SINGLE_AND_SHARDING_TABLES statement with shardingsphere-integration-test

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

LeeGuoPing commented on pull request #11540:
URL: https://github.com/apache/shardingsphere/pull/11540#issuecomment-889703498


   ok, I will fix these problems. what does bingdint tables meaning? I can not understand it.
   
   
   
   ***@***.***
    
   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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org