You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@tajo.apache.org by "Hyunsik Choi (JIRA)" <ji...@apache.org> on 2014/01/29 05:28:11 UTC

[jira] [Created] (TAJO-567) Expression projection bugs

Hyunsik Choi created TAJO-567:
---------------------------------

             Summary: Expression projection bugs
                 Key: TAJO-567
                 URL: https://issues.apache.org/jira/browse/TAJO-567
             Project: Tajo
          Issue Type: Bug
          Components: planner/optimizer
            Reporter: Hyunsik Choi
            Assignee: Hyunsik Choi
             Fix For: 0.8-incubating


This patch fixes two cases of expression projection bugs. Please take a look at two example cases:

The point of this case is outer join and constant expression.
{code}
select c_custkey, o.o_orderkey, 'val' as val from customer left outer join (select * from orders) o on c_custkey = o.o_orderkey
{code}

The point of this case is non-column grouping keys.
{code}
select upper(lower(l_orderkey::text)) as key, count(1) as total from lineitem group by upper(lower(l_orderkey::text)) order by upper(lower(l_orderkey::text)), total;
{code}



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)