[CALCITE-2999] Can't get the right column value in LogicalSort

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Not A Bug
• Affects Version/s: 1.19.0
• Component/s: core
• Assignee: Danny Chen
• Reporter: yuqi
• Created: 15/Apr/19 08:23
• Updated: 16/Apr/19 07:33
• Resolved: 16/Apr/19 06:36

Description

Let's consider the 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"

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

Issue Links

• is related to: CALCITE-819 Add a "contract" for the result of a relational expression