Show Materialized View should honor fully qualified name of database ie.., catalog_name.database_name

[amoghmargoor]

Steps to reproduce the behavior (Required)

mysql>
mysql> show materialized views from default_catalog.test;
ERROR 5501 (3F000): Getting analyzing error. Detail message: Unknown database 'default_catalog.test'.
mysql>
mysql>
mysql> use default_catalog.test;
Database changed
mysql> show materialized views;
+-------+---------------+-------+--------------+-----------+-----------------+----------------+---------+-----------+-------------------------+----------------------------+-----------------------+--------------------+----------------------------+------------------------------+----------------------------+--------------------------------------+------------------------------------+-------------------------+----------------------------+------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+------------+
| id    | database_name | name  | refresh_type | is_active | inactive_reason | partition_type | task_id | task_name | last_refresh_start_time | last_refresh_finished_time | last_refresh_duration | last_refresh_state | last_refresh_force_refresh | last_refresh_start_partition | last_refresh_end_partition | last_refresh_base_refresh_partitions | last_refresh_mv_refresh_partitions | last_refresh_error_code | last_refresh_error_message | rows | text

Expected behavior (Required)

Should work like last command above.

Real behavior (Required)

Throws error: ERROR 5501 (3F000): Getting analyzing error. Detail message: Unknown database 'default_catalog.test'.

StarRocks version (Required)

• 3.3.7

[amoghmargoor]

Raised a PR: #56174