Alter Name of schema doesn't change the MV/SINK definition under the schema.

[KeXiangWang]

Describe the bug

As titled.

Error message/log

No response

To Reproduce

CREATE SCHEMA foo;

CREATE MATERIALIZED VIEW foo.bar AS SELECT t0 FROM UNNEST('{a,b,c}'::CHARACTER VARYING[]) t0;

CREATE MATERIALIZED VIEW foo.bar_upcase AS SELECT UPPER(t0) AS t0 FROM foo.bar;

SELECT rw_relations.id, rw_schemas.name AS schema_name, rw_relations.name AS view_name, rw_relations.definition FROM rw_relations JOIN rw_schemas ON rw_schemas.id = rw_relations.schema_id WHERE rw_schemas.name NOT IN ('rw_catalog', 'pg_catalog', 'information_schema');

ALTER SCHEMA foo RENAME TO fizz;

-- should update `definition`, but does not
SELECT rw_relations.id, rw_schemas.name AS schema_name, rw_relations.name AS view_name, rw_relations.definition FROM rw_relations JOIN rw_schemas ON rw_schemas.id = rw_relations.schema_id WHERE rw_schemas.name NOT IN ('rw_catalog', 'pg_catalog', 'information_schema');

Expected behavior

CREATE MATERIALIZED VIEW fizz.bar_upcase AS SELECT UPPER(t0) AS t0 FROM fizz.bar

But actually it's still

CREATE MATERIALIZED VIEW foo.bar_upcase AS SELECT UPPER(t0) AS t0 FROM foo.bar

How did you deploy RisingWave?

No response

The version of RisingWave

No response

Additional context

No response