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

[Hongze Zhang (JIRA)]

    [ 
https://issues.apache.org/jira/browse/CALCITE-2999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16817993#comment-16817993
 ] 

Hongze Zhang commented on CALCITE-2999:
---------------------------------------

{quote}RelRoot output Type is correct and the output value of LogicalSort is 
wrong
{quote}
I am not sure if it is really wrong. LogicalSort is supposed to not to change 
child's row type, which means, in this case it should emit 3 columns as well as 
its child (the LogicalProject).

Hi [~danny0405], it seems your opinion is that there is a bug. Would you mind 
sharing your thoughts a bit?

> 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
>            Assignee: Danny Chan
>            Priority: Critical
>         Attachments: picture2.png, picture4.png, problem.png, 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)