[I] Group by rollup/cube/etc.. fails with new type_coercion [datafusion]

["cetra3 (via GitHub)" <gi...@apache.org>]

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

   ### Describe the bug
   
   https://github.com/apache/datafusion/pull/23232 introduced some changes that broke some query shapes inadvertently.
   
   ### To Reproduce
   
   Using datafusion cli:
   
   ```sql
   CREATE TABLE t (ts TIMESTAMP, calls BIGINT) AS VALUES
    ('1970-01-01T00:00:00'::timestamp, 1),
    ('1970-01-01T00:01:00'::timestamp, 2),
    ('1970-01-01T00:05:00'::timestamp, 4);
   
   SELECT date_bin('5 minutes', ts) AS bucket, SUM(calls)
   FROM t GROUP BY ROLLUP(bucket) ORDER BY bucket NULLS FIRST;
   ```
   
   You will get the error:
   
   ```
   No field named "date_bin(Utf8(""5 minutes""),t.ts)". Did you mean '"ROLLUP (date_bin(Utf8(""5 minutes""),t.ts))"'
   ```
   
   ### Expected behavior
   
   This query runs and returns appropriately
   
   ### 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-unsubscribe@datafusion.apache.org.apache.org

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


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

Re: [I] Group by rollup/cube/etc.. fails with new type_coercion [datafusion]

["adriangb (via GitHub)" <gi...@apache.org>]

adriangb closed issue #25890: Group by rollup/cube/etc.. fails with new type_coercion
URL: https://github.com/apache/datafusion/issues/25890


-- 
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-unsubscribe@datafusion.apache.org

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


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