[GitHub] [incubator-shardingsphere] KomachiSion opened a new issue #2883: Encrypt replace the table name with the column name.

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

KomachiSion opened a new issue #2883: Encrypt replace the table name with the column name.
URL: https://github.com/apache/incubator-shardingsphere/issues/2883
 
 
   ## Bug Report
   
   ### Which version of ShardingSphere did you use?
   
   4.0.0-RC2-SNAPSHOT
   
   ### Which project did you use? Sharding-JDBC or Sharding-Proxy?
   
   Sharding-JDBC 
   
   ### Expected behavior
   
   encrypt successfully.
   
   ### Actual behavior
   
   Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'status.status' in 'field list'
   
   ### Reason analyze (If you can)
   
   Logic SQL: `select orderentit0_.order_id as order_id1_1_, orderentit0_.status as status2_1_, orderentit0_.user_id as user_id3_1_ from t_order orderentit0_`
   
   actual SQL: `select orderentit0_.order_id as order_id1_1_, status.status as status2_1_, orderentit0_.user_id as user_id3_1_ from t_order orderentit0_`
   
   Replace the table name with column name when rewrite.
   
   ### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
   
   clone example code
   use `local-zookeeper-encrypt` as spring.profiles.active
   run `/Users/yangyi/Documents/java/sharding-sphere-example-sion/sharding-jdbc-example/orchestration-example/orchestration-spring-boot-example/src/main/java/org/apache/shardingsphere/example/orchestration/spring/boot/SpringBootExample`
   
   ### Example codes for reproduce this issue (such as a github link).
   
   https://github.com/apache/incubator-shardingsphere-example
   

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