jychen7 opened a new issue #215:
URL: https://github.com/apache/arrow-datafusion/issues/215


   **Describe the bug**
   https://github.com/apache/arrow-datafusion/issues/110 suggests we can group 
by alias, however, I modify the existing test case 
`select_simple_aggregate_with_groupby_with_aliases` a bit, then it fails
   
   **To Reproduce**
   ```
   SELECT state AS a, MIN(age) AS b FROM person GROUP BY state
   ```
   shows correct answer
   
   ```
   SELECT state AS a, MIN(age) AS b FROM person GROUP BY a
   ```
   raises error `Plan("Projection references non-aggregate values")`
   
   **Expected behavior**
   ```
   SELECT state AS a, MIN(age) AS b FROM person GROUP BY state
   
   SELECT state AS a, MIN(age) AS b FROM person GROUP BY a
   ```
   returns same answer
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
[email protected]


Reply via email to