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

["Hongze Zhang (JIRA)" <ji...@apache.org>]

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

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

Sorry maybe I missed something but I don't quiet get the problem from the Project expression list that you highlighted. Do you mean the RexInputRef {{"$4"}} does not offer a correct field ordinal?

It would be good if you can explain your issue in detail. For example, you can paste the wrong logical plan Calcite produced and the correct plan you expected, that helps you to explain the issue.

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