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