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: [email protected]

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


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to