You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@tajo.apache.org by "Hyunsik Choi (JIRA)" <ji...@apache.org> on 2013/12/15 17:31:07 UTC
[jira] [Updated] (TAJO-418) sort operator after Inline views
consisting of unions can cause an incorrect distributed plan
[ https://issues.apache.org/jira/browse/TAJO-418?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Hyunsik Choi updated TAJO-418:
------------------------------
Status: Patch Available (was: Open)
> sort operator after Inline views consisting of unions can cause an incorrect distributed plan
> ---------------------------------------------------------------------------------------------
>
> Key: TAJO-418
> URL: https://issues.apache.org/jira/browse/TAJO-418
> Project: Tajo
> Issue Type: Bug
> Components: distributed query plan
> Reporter: Hyunsik Choi
> Assignee: Hyunsik Choi
> Fix For: 0.8-incubating
>
> Attachments: TAJO-418.patch
>
>
> See the title. The following query is an example of this bug.
> {code}
> SELECT
> l_returnflag,
> l_linestatus
> FROM (
> SELECT
> *
> FROM
> lineitem
> WHERE
> l_returnflag = 'O'
> UNION ALL
> SELECT
> *
> FROM
> lineitem
> WHERE
> l_returnflag = 'R'
> ) T
> GROUP BY
> l_returnflag,
> l_linestatus
> ORDER BY
> l_returnflag,
> l_linestatus
> {code}
> This patch adds an unit test to reproduce this case and includes the bug fix.
--
This message was sent by Atlassian JIRA
(v6.1.4#6159)