View cannot find column while materialized view can

[lmatz]

Describe the bug

dev=> create table t1 (s struct<v1 int, v2 VARCHAR>);
CREATE_TABLE
dev=> create materialized view mv2 as select (s).v1, (s).v2 from t1;
CREATE_MATERIALIZED_VIEW
dev=> select count(*) from mv2;
 ?column? 
----------
        0
(1 row)

dev=> create view v2 as select (s).v1, (s).v2 from t1;
CREATE_VIEW
dev=> select count(*) from v2;
ERROR:  QueryError: Bind error: failed to bind view v2, sql: SELECT s.v1, s.v2 FROM t1
error: Item not found: Invalid column: v1

To Reproduce

No response

Expected behavior

No response

Additional context

No response

[BugenZhao]

I guess this is caused by the incorrect "unparse" in sql parser. Maybe directly storing the original SQL input by the user will be a solution?

risingwave/src/frontend/src/handler/create_view.rs

Line 91 in 9b59c71

sql: format!("{}", query),

[BowenXiao1999]

This will be a blocker for #6849. Cuz here we assuming the original sql str is just one statement, however it may not be true. Have to do some if-else hack to support #6849.

Seems like #6940 can fix problem