[GitHub] [shardingsphere] JiekerTime opened a new issue #9388: Problems encountered in SQL rewriting of the data encryption part

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

JiekerTime opened a new issue #9388:
URL: https://github.com/apache/shardingsphere/issues/9388


   ### Which version of ShardingSphere did you use?
   5.0.0-RC1-SNAPSHOT
   
   ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
   ShardingSphere-JDBC and ShardingSphere-Proxy
   
   ### Expected behavior
   Get Result
   
   ### Actual behavior
   ERROR: Column 'user_id' in field list is ambiguous
   
   ### Reason analyze (If you can)
   Column name conflicts were not considered in the process of rewriting SQL statements in the encrypted part.
   
   ### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
   About PR https://github.com/apache/shardingsphere/pull/9387 .
   Run the following SQL statement according to the PR environment：
   SELECT * FROM t_user u INNER JOIN t_order_item m ON u.user_id=m.user_id
   （The statement is commented in the PR）
   
   ### Example codes for reproduce this issue (such as a github link).
   https://github.com/apache/shardingsphere/pull/9387


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

[GitHub] [shardingsphere] menghaoranss closed issue #9388: Problems encountered in SQL rewriting of the data encryption part

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

menghaoranss closed issue #9388:
URL: https://github.com/apache/shardingsphere/issues/9388


   


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