[GitHub] [incubator-shardingsphere] trydofor opened a new issue #2859: jooq sql `select table.column from table where table.id=?` can not sharding

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

trydofor opened a new issue #2859: jooq sql `select table.column from table where table.id=?` can not sharding
URL: https://github.com/apache/incubator-shardingsphere/issues/2859
 
 
   
   
   ### Which version of ShardingSphere did you use?
   4.0.0-RC1
    jOOQ 3.11.11
   ### Which project did you use? Sharding-JDBC or Sharding-Proxy?
   Sharding-JDBC
   ### Expected behavior
   ```
   select dest_regional_fee_1.LOGNO from dest_regional_fee_1 where dest_regional_fee_1.ID = ?
   ```
   ### Actual behavior
   ```
   select dest_regional_fee.LOGNO from dest_regional_fee_1 where dest_regional_fee_1.ID = ?
   ```
   ### Reason analyze (If you can)
   
   ### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
   
   ### Example codes for reproduce this issue (such as a github link).
   ```
   2019-08-12 23:25:12.950  INFO 2833 --- [           main] ShardingSphere-SQL                       : Logic SQL: select dest_regional_fee.LOGNO from dest_regional_fee where dest_regional_fee.ID = ?
   2019-08-12 23:25:12.952  INFO 2833 --- [           main] ShardingSphere-SQL                       : Actual SQL: ds0 ::: select dest_regional_fee.LOGNO from dest_regional_fee_1 where dest_regional_fee_1.ID = ? ::: [100]
   ```

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