Repository navigation
Group by rollup/cube/etc.. fails with new type_coercion #25890
Description
Describe the bug
#23232 introduced some changes that broke some query shapes inadvertently.
To Reproduce
Using datafusion cli:
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
Activity
fix: preserve grouping set member names during type coercion
fix: preserve grouping set member names during type coercion
fix: preserve grouping set member names during type coercion
fix: preserve grouping set member names during type coercion (apache#…