[GitHub] [incubator-shardingsphere] sluk3r edited a comment on issue #2920: When association query，table name of join table is changed to lowercase, but the first is not unchanged

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

sluk3r edited a comment on issue #2920: When association query，table name of join table is changed to lowercase, but the first is not unchanged
URL: https://github.com/apache/incubator-shardingsphere/issues/2920#issuecomment-544953084
 
 
   @ustbyjy Hi, I try to reproduce the issue, but failed. So, the my reproduce code, let us discuss the exact way to reproduce the issue, and my reproduce code link is: https://github.com/apache/incubator-shardingsphere-example, branch is ss_issue_2920, the code is based on incubator-shardingsphere-example. 
   
   the sql is "SELECT i.* FROM **T_ORDER** o left join **t_order_item** i on o.order_id = i.order_id", which is in class of OrderItemRepositoryImpl, in package of "org.apache.shardingsphere.example.core.jdbc.repository",  in method of "selectAll"
   
   And when I run the JavaConfigurationExampleMain class, with "sql.show" as true,  I saw the rewrote sql is "SELECT i.* FROM **t_order_0** o left join **t_order_item_0** i on o.order_id = i.order_id", as shown in the log:
   
   ```java
   [ShardingSphere-SQL] Actual SQL: demo_ds ::: SELECT i.* FROM t_order_0 o left join t_order_item_0 i on o.order_id = i.order_id 
   [ShardingSphere-SQL] Actual SQL: demo_ds ::: SELECT i.* FROM t_order_1 o left join t_order_item_1 i on o.order_id = i.order_id 
   
   ```
   
   
   As we see, there is no case-related problems:  both t_order_0 and t_order_item_0 are in lowercase.
   
   So, I want to know more info to reproduce the issue. 
   Tks.
   
   
   
   

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


With regards,
Apache Git Services