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

              andygrove Andy Grove
              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