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
It's not possible to create a materialized view using TUMBLE() with an offset, as shown below.
Error message/log
SQL Error [XX000]: ERROR: Panicked when handling the request: assertion `left == right` failed
left: 3
right: 2
This is a bug. We would appreciate a bug report at:
https://github.com/risingwavelabs/risingwave/issues/new?labels=type%2Fbug&template=bug_report.yml
Error position:
To Reproduce
create materialized view if not exists "tumble_with_offset"
as (
with
input as (
select 1 as id, TO_TIMESTAMP('2024-01-01 01:30:02', 'YYYY-MM-DD HH24:MI:SS') as timestamps
)
select *
from tumble(input, timestamps, interval '1 DAY', '+6 HOURS') -- if you omit the '+6 HOURS' offset, it works
)
Expected behavior
A materialized view should be created
How did you deploy RisingWave?
RisingWave Cloud
The version of RisingWave
dev=> select version();
version
----------------------------------------------------------------------------
PostgreSQL 9.5-RisingWave-1.5.1 (aa67e4728fdae80f31970ee96307683cd4ccf4c9)
(1 row)
Additional context
No response
The text was updated successfully, but these errors were encountered:
Describe the bug
It's not possible to create a materialized view using TUMBLE() with an offset, as shown below.
Error message/log
To Reproduce
Expected behavior
A materialized view should be created
How did you deploy RisingWave?
RisingWave Cloud
The version of RisingWave
Additional context
No response
The text was updated successfully, but these errors were encountered: