Rachelint opened a new issue, #15870:
URL: https://github.com/apache/datafusion/issues/15870

   ### Is your feature request related to a problem or challenge?
   
   I found aggregation fuzzer are still hard to use when I act as an user 
currently.
   Some points I noticed can be improved:
   
   ### 1. Aggregation function generation
   Now it is still hard/possible to generate sql having multiple aggregated 
functions like:
   ```text
   SELECT count(string), sum(number) FROM xxx GROUP BY xxx;
   ```
   
   It is due to `aggregate_function` and `aggregate_arguments` are set 
respectively. if we set `mutiple aggregate_functions`, columns in the respectly 
set `aggregate_arguments` may be not supported in some of the 
`aggregate_functions`.
   For example, 
   ```
   If we set:
   aggregate_arguments: [string, primitive]
   aggregate_function: [sum, count]
   
   Then wrong generated sql possible to be generated:
   SELECT sum(string) FROM t GROUP BY xxx
   ```
   
   ### 2. Group by columns ordering
   WIP
   
   ### Describe the solution you'd like
   
   _No response_
   
   ### Describe alternatives you've considered
   
   _No response_
   
   ### Additional context
   
   _No response_


-- 
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.

To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org
For additional commands, e-mail: github-h...@datafusion.apache.org

Reply via email to