You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "kssumin (via GitHub)" <gi...@apache.org> on 2025/10/13 07:55:04 UTC

Re: [I] Support sharding tables and broadcast tables to execute ALTER TABLE ... RENAME TO ... statement [shardingsphere]

kssumin commented on issue #10476:
URL: https://github.com/apache/shardingsphere/issues/10476#issuecomment-3396291578

     Hi @strongduanmu 
   
     I would like to work on this issue. I've already implemented a solution for supporting
     `ALTER TABLE ... RENAME TO` and `RENAME TABLE` statements for sharding and broadcast
     tables.
   
     ### Implementation Summary:
     - Removed restrictions in `ShardingAlterTableSupportedChecker` and
     `ShardingRenameTableSupportedChecker`
     - Added validation to prevent table name conflicts
     - Updated metadata refreshers to handle rename operations
     - Added comprehensive unit tests (8 tests, all passing)
   
     The physical table renaming works for both single and sharding/broadcast tables. For
     sharding/broadcast tables, the rules can be updated manually via DistSQL (consistent with
      existing DROP/CREATE TABLE behavior).
   
     I'm preparing to submit a PR. Any feedback or guidance would be appreciated!
   
     Thanks!


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org