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 2020/11/19 09:51:37 UTC

[GitHub] [shardingsphere] hhniao opened a new issue #8223: create table key name bug.

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:
users@infra.apache.org



[GitHub] [shardingsphere] terrymanu commented on issue #8223: create table with key name bug.

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


   First analyzation:
   SQL parser visitor cast exception with index segment and IdentifierValue.


----------------------------------------------------------------
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:
users@infra.apache.org



[GitHub] [shardingsphere] kimmking edited a comment on issue #8223: create table with key name bug.

Posted by GitBox <gi...@apache.org>.
kimmking edited a comment on issue #8223:
URL: https://github.com/apache/shardingsphere/issues/8223#issuecomment-731066032


   `docker pull apache/shardingsphere-proxy` for latest version


----------------------------------------------------------------
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:
users@infra.apache.org



[GitHub] [shardingsphere] tristaZero commented on issue #8223: create table with key name bug.

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


   Hi @hhniao 
   Which version of ShardingSphere for this test?


----------------------------------------------------------------
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:
users@infra.apache.org



[GitHub] [shardingsphere] terrymanu closed issue #8223: create table with key name bug.

Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #8223:
URL: https://github.com/apache/shardingsphere/issues/8223


   


----------------------------------------------------------------
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:
users@infra.apache.org



[GitHub] [shardingsphere] hhniao commented on issue #8223: create table with key name bug.

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


   @tristaZero i dont know. it is which version. maybe 5.0.0-beta
   im use this command.
   
       docker pull apache/sharding-proxy


----------------------------------------------------------------
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:
users@infra.apache.org



[GitHub] [shardingsphere] kimmking commented on issue #8223: create table with key name bug.

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


   docker pull apache/shardingsphere-proxy


----------------------------------------------------------------
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:
users@infra.apache.org



[GitHub] [shardingsphere] kimmking edited a comment on issue #8223: create table with key name bug.

Posted by GitBox <gi...@apache.org>.
kimmking edited a comment on issue #8223:
URL: https://github.com/apache/shardingsphere/issues/8223#issuecomment-731066032


   docker pull `apache/shardingsphere-proxy` for latest version


----------------------------------------------------------------
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:
users@infra.apache.org