Uploaded image for project: 'Apache Arrow'
  1. Apache Arrow
  2. ARROW-6567

[Rust] [DataFusion] SQL aggregate query execution assume grouping expressions precede aggregate expressions

    XMLWordPrintableJSON

    Details

      Description

      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:

      SELECT a, SUM(b) FROM test GROUP BY a 
      SELECT SUM(b), a FROM test GROUP BY a

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                andygrove Andy Grove
                Reporter:
                andygrove Andy Grove
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 0.5h
                  0.5h