Rename table statement

[BohuTANG]

Summary

RENAME TABLE old_table TO new_table;

https://dev.mysql.com/doc/refman/8.0/en/rename-table.html

[chenyukang]

/assign

[kevinw66]

Is alter_table function needed in MetaApi ?

[BohuTANG]

Is alter_table function needed in MetaApi ?

Yes, looks like we need.
But it seems we only update the database/table name with the db_id/table_id, @drmingdrmer and @dantengsky may help here

[junnplus]

Is alter_table function needed in MetaApi ?

@kevinw66 @chenyukang
The last hurdle has been cleared at #4288 , sorry to finish so late. :(

[kevinw66]

/assign

[kevinw66]

@BohuTANG @junnplus The multiple table rename should support in meta api or I have to call api multiple times?

[junnplus]

@kevinw66 I guess they can be non-atomic.

refer to https://clickhouse.com/docs/en/sql-reference/statements/rename/#misc_operations-rename_table

If you rename multiple tables in one query, the operation is not atomic. It may be partially executed, and queries in other sessions may get Table ... does not exist ... error.