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

[GitBox]

tristaZero commented 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 = 
? and t_order_item_calcite_sharding.item_id = ?
   
   // Second one,
   select t_order_calcite.*, t_order_item_calcite_sharding.* from 
t_order_calcite o , t_order_item_calcite_sharding i where 
t_order_calcite.order_id = ? and t_order_item_calcite_sharding.item_id = ?
   ```
   
   Let us figure out whether `Calcite` does not support table alias. I will try 
to get the answer in Calcite community synchronously.
   
   


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