You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@calcite.apache.org by "yuqi (JIRA)" <ji...@apache.org> on 2019/04/15 08:24:00 UTC
[jira] [Created] (CALCITE-2999) Can't get the right column value in
LogicalSort
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)