search

risingwavelabs / risingwave

Best-in-class stream processing, analytics, and management. Perform continuous analytics, or build event-driven applications, real-time ETL pipelines, and feature stores in minutes. Unified streaming and batch. PostgreSQL compatible.
https://go.risingwave.com/slack
Apache License 2.0
7.06k stars 580 forks source link

disallow using system functions in create materialized view statements #11347

Open neverchanje opened 1 year ago

neverchanje commented 1 year ago

Describe the bug

Some products refer to this type of functions as "non-materializable" functions, meaning that they are disallowed in CREATE MATERIALIZED VIEW statements. We'll also need to take care of such misuse.

dev=> create materialized view mv as select current_user();
CREATE_MATERIALIZED_VIEW

The current_user in the above MV doesn't change when switching the user.

Error message/log

No response

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

xiangjinwu commented 1 year ago

related: #11752 #11522