Currently, PR #10462 only implements the ALTER TABLE ... RENAME TO ... statement for the single table. The storage problem of the table rule has not been solved after sharding tables and the broadcast tables are renamed. Therefore, sharding tables and the broadcast tables are not supported ALTER TABLE ... RENAME TO ... statement now.

We need to discuss with @tristaZero @menghaoranss to determine the final implementation, and then support sharding tables and broadcast tables.