lucy3399 opened a new issue #2204: select a.id ,c.id order by a.id, the result can not sort by designated column URL: https://github.com/apache/incubator-shardingsphere/issues/2204 ## Bug Report ### Which version of ShardingSphere did you use? <modelVersion>4.0.0</modelVersion> <groupId>io.shardingsphere</groupId> <artifactId>sharding-sphere</artifactId> <version>3.1.0</version> <packaging>pom</packaging> ### Which project did you use? Sharding-JDBC or Sharding-Proxy? Sharding-JDBC ### Expected behavior correct sort by designated column,or when find final columnLabelIndexMap's v-index not increase one throw exception inform user ？ ### Actual behavior multi-result can not correct sort by designated column ### Reason analyze (If you can) i see the encapsulate select columns is map and map's key from columnLabel,so the same column will be overwrite ,when find orderby column index will be error index ,so that result sort is wrong .this reason may be the same with group by column, i use alias with different table same column name and order by ,group by their alias can get a right result ，but is fit mysql only，oracle select sentence cannot group by column use alias . ### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc. SELECT i.user_id ,o.user_id FROM t_order o, t_order_item i WHERE o.order_id = i.order_id order by i.user_id ### Example codes for reproduce this issue (such as a github link).
---------------------------------------------------------------- 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: [email protected] With regards, Apache Git Services
