Skip to content

Bug: when create mv with an index, a stream key is expected but not exist #24851

@chenzl25

Description

@chenzl25

Describe the bug

create materialized view if not exists tca.fill_markout_status as (
SELECT
transacttime::date,
count() as count,
count() - count(mark_price) as nulls -- counts non-null values
FROM tca.fill_markouts
GROUP BY transacttime::date
)

error message:

Panicked when handling the request: a stream key is expected but not exist, plan: StreamExchange { dist: HashShard($expr1) } └─StreamProject { exprs: [AtTimeZone(idx_fill_markouts_transacttime.transacttime, 'UTC':Varchar)::Date as $expr1, idx_fill_markouts_transacttime.mark_price, idx_fill_markouts_transacttime.fill_markouts._row_id] } └─StreamTableScan { table: idx_fill_markouts_transacttime, columns: [transacttime, mark_price, fill_markouts._row_id] } 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 message/log


To Reproduce

No response

Expected behavior

No response

How did you deploy RisingWave?

No response

The version of RisingWave

No response

Additional context

No response

Metadata

Metadata

Assignees

No one assigned

    Labels

    type/bugType: Bug. Only for issues.

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions