You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2021/05/24 04:01:00 UTC

[GitHub] [shardingsphere] yidazhi opened a new issue #10439: Binding table configuration not effective

yidazhi opened a new issue #10439:
URL: https://github.com/apache/shardingsphere/issues/10439


   I made the following configuration in sharding proxy, but the binding table did not take effect
   
   bindingTables:
       - wt_tran,wt_tran_detail      ##Effective
       - user_account,user_subaccount    ##Effective
       - wt_tran_detail,user_account   ##It didn't work,These two tables will also produce Cartesian product for join query.
   
   version  :  apache-shardingsphere-incubating-4.0.0-sharding-proxy
   
   How do I configure it to take effect?


-- 
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:
users@infra.apache.org



[GitHub] [shardingsphere] tristaZero commented on issue #10439: Binding table configuration not effective

Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #10439:
URL: https://github.com/apache/shardingsphere/issues/10439#issuecomment-846718536


   Looks strange if the first two work well.
   From your configuration, I suppose wt_tran_detail, user_account, user_subaccount and wt_tran share same sharding column and algorithm, don't they? If so, could you configure that in the way below?
   ```yaml
   bindingTables:
   - wt_tran, wt_tran_detail, user_account, user_subaccount 
   ```


-- 
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:
users@infra.apache.org



[GitHub] [shardingsphere] yidazhi commented on issue #10439: Binding table configuration not effective

Posted by GitBox <gi...@apache.org>.
yidazhi commented on issue #10439:
URL: https://github.com/apache/shardingsphere/issues/10439#issuecomment-846769416


   > Looks strange if the first two work well.
   > From your configuration, I suppose wt_tran_detail, user_account, user_subaccount and wt_tran share same sharding column and algorithm, don't they? If so, could you configure that in the way below?
   > 
   > ```yaml
   > bindingTables:
   > - wt_tran, wt_tran_detail, user_account, user_subaccount 
   > ```
   
   According to your suggestion, it is effective and will not produce Cartesian product. Thank you


-- 
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:
users@infra.apache.org



[GitHub] [shardingsphere] yidazhi closed issue #10439: Binding table configuration not effective

Posted by GitBox <gi...@apache.org>.
yidazhi closed issue #10439:
URL: https://github.com/apache/shardingsphere/issues/10439


   


-- 
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:
users@infra.apache.org



[GitHub] [shardingsphere] yidazhi commented on issue #10439: Binding table configuration not effective

Posted by GitBox <gi...@apache.org>.
yidazhi commented on issue #10439:
URL: https://github.com/apache/shardingsphere/issues/10439#issuecomment-846755249


   > Looks strange if the first two work well.
   > From your configuration, I suppose wt_tran_detail, user_account, user_subaccount and wt_tran share same sharding column and algorithm, don't they? If so, could you configure that in the way below?
   > 
   > ```yaml
   > bindingTables:
   > - wt_tran, wt_tran_detail, user_account, user_subaccount 
   > ```
   
   Yes, they share the same slicing and algorithm. Let me test it according to your suggestion


-- 
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:
users@infra.apache.org