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/12/18 06:15:13 UTC
[jira] [Updated] (TAJO-1232) Implicit groupby queries with LIMIT
lead to wrong results.
[ https://issues.apache.org/jira/browse/TAJO-1232?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jihoon Son updated TAJO-1232:
-----------------------------
Attachment: TAJO-1232.patch
I have simply pushed the GroupbyNode down below the LimitNode.
> Implicit groupby queries with LIMIT lead to wrong results.
> ----------------------------------------------------------
>
> Key: TAJO-1232
> URL: https://issues.apache.org/jira/browse/TAJO-1232
> Project: Tajo
> Issue Type: Bug
> Components: planner/optimizer
> Reporter: Hyunsik Choi
> Assignee: Jihoon Son
> Fix For: 0.10
>
> Attachments: TAJO-1232.patch
>
>
> See the title. The following query will reproduce the problem.
> {code}
> SELECT sum(x) FROM T1 LIMIT 1;
> > 0
> {code}
> Regardless of the actual summation result, the query result always is 0.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)