risingwave icon indicating copy to clipboard operation
risingwave copied to clipboard

sqlsmith bug hunt: supported `sum(interval)`

Open kwannoel opened this issue 2 years ago • 0 comments

Describe the bug

Invalid agg should be caught in frontend.

To Reproduce

create table t (v int);
create materialized view m1 as select sum(INTERVAL '938796') as e from t;

output:

ERROR:  QueryError: internal error: transport error.

compute.log

thread 'tokio-runtime-worker' panicked at 'streaming agg state not implemented: Sum Interval Interval', src/stream/src/executor/aggregation/mod.rs:161:13

Expected behavior

Support sum(interval). It should be similar to sum(decimal) and sum(double).

Additional context Add any other context about the problem here.

kwannoel avatar Aug 08 '22 16:08 kwannoel