You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2022/05/28 02:13:44 UTC

[GitHub] [shardingsphere] azexcy opened a new issue, #18021: Proxy not support ALTER TABLE xxx RENAME statement of sharding tables

azexcy opened a new issue, #18021:
URL: https://github.com/apache/shardingsphere/issues/18021

   ## Bug Report
   
   Proxy not support`ALTER TABLE xxx RENAME`  statement of MySQL.
   will support it in the future?
   
   ### Which version of ShardingSphere did you use?
   
   master
   
   ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
   
   Proxy
   
   ### Expected behavior
   
   rename all sharding tables name
   
   ### Actual behavior
   
   ```
   mysql> CREATE TABLE t_order (order_id bigint NOT NULL, user_id int NOT NULL, status varchar(50) DEFAULT NULL, t_numeric numeric(10,2) DEFAULT NULL, PRIMARY KEY (order_id));
   Query OK, 0 rows affected (0.21 sec)
   
   mysql> ALTER TABLE t_order RENAME TO t_order_temp;
   ERROR 1997 (C1997): Runtime exception: [ALTER TABLE ... RENAME TO ... statement can not support sharding tables and broadcast tables.]
   ```
   
   ### Reason analyze (If you can)
   
   <img width="1096" alt="image" src="https://user-images.githubusercontent.com/101622833/170805676-92ddcdf3-1391-467e-b44b-8831fb58c71f.png">
   


-- 
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.apache.org

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

[GitHub] [shardingsphere] terrymanu closed issue #18021: Proxy not support ALTER TABLE xxx RENAME statement of sharding tables

Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #18021: Proxy not support ALTER TABLE xxx RENAME statement of sharding tables
URL: https://github.com/apache/shardingsphere/issues/18021


-- 
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

[GitHub] [shardingsphere] terrymanu commented on issue #18021: Proxy not support ALTER TABLE xxx RENAME statement of sharding tables

Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #18021:
URL: https://github.com/apache/shardingsphere/issues/18021#issuecomment-1159480433

   No plan to support it


-- 
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