[ https://issues.apache.org/jira/browse/CALCITE-2999?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
yuqi updated CALCITE-2999: -------------------------- Description: Let's consider the sql: {code:sql} // Some comments here select 'hello', tag from b where text = '2' or text = '1' order by cast(text as int) + 1 asc , tag desc limit 1" {code} And the Plan can be seen in the picture below We can't get the right column value of LogicalSort if sort condition is not the select column list Can anyone help to explain this problem if i'm wrong was: Let's consider the sql: {code:sql} // Some comments here select 'hello', tag from b where text = '2' or text = '1' order by cast(text as int) + 1 asc , tag desc limit 1" {code} And the Plan is as follows !image-2019-04-15-16-22-24-105.png! We can't get the right column value of LogicalSort if sort condition is not the select column list > Can't get the right column value in LogicalSort > ----------------------------------------------- > > Key: CALCITE-2999 > URL: https://issues.apache.org/jira/browse/CALCITE-2999 > Project: Calcite > Issue Type: Bug > Components: core > Affects Versions: 1.19.0 > Reporter: yuqi > Priority: Critical > Attachments: problem.png > > > Let's consider the sql: > {code:sql} > // Some comments here > select 'hello', tag from b where text = '2' or text = '1' order by cast(text > as int) + 1 asc , tag desc limit 1" > {code} > And the Plan can be seen in the picture below > We can't get the right column value of LogicalSort if sort condition is not > the select column list > Can anyone help to explain this problem if i'm wrong -- This message was sent by Atlassian JIRA (v7.6.3#76005)