[jira] [Created] (CALCITE-2999) Can't get the right column value in LogicalSort

[yuqi (JIRA)]

yuqi created CALCITE-2999:
-----------------------------

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


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



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)