Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error when creating a materialized view with TUMBLE and offset #15198

Closed
maxjoh opened this issue Feb 22, 2024 · 0 comments · Fixed by #15199
Closed

Error when creating a materialized view with TUMBLE and offset #15198

maxjoh opened this issue Feb 22, 2024 · 0 comments · Fixed by #15199
Assignees
Labels
component/optimizer Query optimization. type/bug Something isn't working
Milestone

Comments

@maxjoh
Copy link

maxjoh commented Feb 22, 2024

Describe the bug

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
component/optimizer Query optimization. type/bug Something isn't working
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants