You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@tajo.apache.org by "Jihoon Son (JIRA)" <ji...@apache.org> on 2014/02/17 16:04:19 UTC

[jira] [Resolved] (TAJO-597) Join query results are wrong when it contains an asterisk in the select list

     [ https://issues.apache.org/jira/browse/TAJO-597?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jihoon Son resolved TAJO-597.
-----------------------------

    Resolution: Fixed

This issue is fixed in TAJO-554.

> Join query results are wrong when it contains an asterisk in the select list
> ----------------------------------------------------------------------------
>
>                 Key: TAJO-597
>                 URL: https://issues.apache.org/jira/browse/TAJO-597
>             Project: Tajo
>          Issue Type: Bug
>          Components: planner/optimizer
>    Affects Versions: 0.8-incubating
>            Reporter: Jihoon Son
>
> Suppose the following two tables.
> {noformat}
> create table t1 (id_1 int, name_1 text);
> create table t2 (id_2 int, name_2 text);
> {noformat}
> When I run the following join query, columns of only one table are projected as follows.
> {noformat}
> tajo> select * from t1, t2 where t1.id_1 = t2.id_2;
> * Expected results
> id_1    name_1    id_2    name_2
> 1    n1    1    n10
> 2    n2    2    n20
> 3    n3    3    n30
> * Actual results
> id_1    name_1
> 1    n1
> 2    n2
> 3    n3
> {noformat}



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