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)