hhniao opened a new issue #8223:
URL: https://github.com/apache/shardingsphere/issues/8223


   docker-compose.yml
       
       version: '3'
       services:
           mysql:
               image: "mysql:5.7.30"
           proxy:
               // maybe 5.0.0? i dont know.
               image: "apache/sharding-proxy" 
   
   failed sql( with key name):
   
       drop table if exists t_order;
       CREATE TABLE `t_order` (
           `id` bigint unsigned NOT NULL AUTO_INCREMENT,
           `order_id` int NULL COMMENT '订单号',
           PRIMARY KEY (`id`) USING BTREE,
           UNIQUE KEY `order_id_unique` (`order_id`) USING BTREE
       ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
       10002 - 2Unknown exception: 
[org.apache.shardingsphere.sql.parser.sql.common.segment.ddl.index.IndexSegment 
cannot be cast to 
org.apache.shardingsphere.sql.parser.sql.common.value.identifier.IdentifierValue]
   
   successed sql (without key name):
   
   ```
   drop table if exists t_order;
   CREATE TABLE `t_order` (
     `id` bigint unsigned NOT NULL AUTO_INCREMENT,
     `order_id` int NULL COMMENT '订单号',
     PRIMARY KEY (`id`) USING BTREE,
     UNIQUE KEY (`order_id`) USING BTREE
   ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
   ```


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

For queries about this service, please contact Infrastructure at:
[email protected]


Reply via email to