[GitHub] [shardingsphere] RaigorJiang commented on issue #9782: Single table not support DDL

[GitBox <gi...@apache.org>]

RaigorJiang commented on issue #9782:
URL: https://github.com/apache/shardingsphere/issues/9782#issuecomment-927275905


   After verification, DDL has been supported, the following is the test record:
   ```sql
   mysql> CREATE TABLE `t_single` (
       ->   `order_id` bigint(20) NOT NULL AUTO_INCREMENT,
       ->   `user_id` int(11) NOT NULL,
       ->   `status` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
       ->   PRIMARY KEY (`order_id`)
       -> ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
   Query OK, 0 rows affected (0.10 sec)
   
   mysql> show tables;
   +-----------------------+
   | Tables_in_sharding_db |
   +-----------------------+
   | t_order_item          |
   | t_order               |
   | t_single              |
   +-----------------------+
   3 rows in set (0.00 sec)
   
   mysql> ALTER TABLE t_single ADD remark varchar(20) DEFAULT NULL;
   Query OK, 0 rows affected (0.13 sec)
   
   mysql> TRUNCATE table t_single;
   Query OK, 0 rows affected (0.04 sec)
   
   mysql> DROP table t_single;
   Query OK, 0 rows affected (0.04 sec)
   
   ```


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