You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@arrow.apache.org by "Andy Grove (Jira)" <ji...@apache.org> on 2019/09/15 18:18:00 UTC

[jira] [Created] (ARROW-6567) [Rust] [DataFusion] SQL aggregate query execution assume grouping expressions precede aggregate expressions

Andy Grove created ARROW-6567:
---------------------------------

             Summary: [Rust] [DataFusion] SQL aggregate query execution assume grouping expressions precede aggregate expressions
                 Key: ARROW-6567
                 URL: https://issues.apache.org/jira/browse/ARROW-6567
             Project: Apache Arrow
          Issue Type: Bug
          Components: Rust, Rust - DataFusion
    Affects Versions: 0.15.0
            Reporter: Andy Grove
             Fix For: 1.0.0


Aggregate SQL queries produce incorrect results unless the query is written with grouping expressions followed by aggregate expressions.

For example, the following queries return the exact same result set:
{code:java}
SELECT a, SUM(b) FROM test GROUP BY a 
SELECT SUM(b), a FROM test GROUP BY a{code}



--
This message was sent by Atlassian Jira
(v8.3.2#803003)