You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
dev=> create materialized view m1 asSELECTtime::timestamptzFROM generate_series(
'2020-01-01 00:00:00',
now(),
interval '1 hour'
) t(time);
ERROR: Failed to run the query
Caused by:
function generate_series(unknown, timestamp with time zone, interval) does not exist
Users have to do casting like '2020-01-01 00:00:00'::timestamptz.
This is not intended, should be fixed.
The text was updated successfully, but these errors were encountered:
Seems we cannot correctly infer streaming
generate_series
withnow()
when thestart
argument is anunknown
, as found by @kwannoel here: https://github.com/risingwavelabs/risingwave-docs/pull/2637#issuecomment-2373942740Users have to do casting like
'2020-01-01 00:00:00'::timestamptz
.This is not intended, should be fixed.
The text was updated successfully, but these errors were encountered: