[GitHub] [shardingsphere] tristaZero edited a comment on issue #9117: [SQL federation] Add unit test for single table joining sharding table

Fri, 22 Jan 2021 02:59:44 -0800 


tristaZero edited a comment on issue #9117:
URL: https://github.com/apache/shardingsphere/issues/9117#issuecomment-765250409


   Hi @lmhmhl ,
   
   Thanks for your debugging, which help me learn the context of your test. 👍 
   
   Could you modify your test sql as the following ones?
   ```sql
   // First one,
   select t_order_calcite.*, t_order_item_calcite_sharding.* from 
t_order_calcite, t_order_item_calcite_sharding where t_order_calcite.order_id = 
t_order_item_calcite_sharding.item_id
   
   // Second one,
   select o.*, i.* from t_order_calcite o , t_order_item_calcite_sharding i 
where to.order_id =  i.item_id
   ```
   
   I tried the two of these and no exception here. BTW, I guess your join SQL 
is incorrect, isn't it? (Two table` join`)
   


----------------------------------------------------------------
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

Reply via email to