[GitHub] [shardingsphere] manxihuanchi opened a new issue, #22649: Table creation did not obtain the primary key, please provide a solution

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

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

   ## Bug Report
   
   CREATE TABLE `t_person` (
   `id` int(32) unsigned NOT NULL COMMENT '配置项使用时标识',
   `thiSection` varchar(32) DEFAULT NULL COMMENT 'StageID白名单区间',
   PRIMARY KEY (`id`)
   )
   
   In the above example, the primary key could not be obtained???
   
   
   **For English only**, other languages will not accept.
   
   Before report a bug, make sure you have:
   
   - Searched open and closed [GitHub issues](https://github.com/apache/shardingsphere/issues).
   - Read documentation: [ShardingSphere Doc](https://shardingsphere.apache.org/document/current/en/overview).
   
   Please pay attention on issues you submitted, because we maybe need more details. 
   If no response anymore and we cannot reproduce it on current information, we will **close it**.
   
   Please answer these questions before submitting your issue. Thanks!
   
   ### Which version of ShardingSphere did you use?
   
   ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
   
   ### Expected behavior
   
   ### Actual behavior
   
   ### Reason analyze (If you can)
   
   ### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
   
   ### Example codes for reproduce this issue (such as a github link).
   


-- 
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] sandynz closed issue #22649: Table creation did not obtain the primary key, please provide a solution

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

sandynz closed issue #22649: Table creation did not obtain the primary key, please provide a solution
URL: https://github.com/apache/shardingsphere/issues/22649


-- 
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] manxihuanchi commented on issue #22649: Table creation did not obtain the primary key, please provide a solution

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

manxihuanchi commented on issue #22649:
URL: https://github.com/apache/shardingsphere/issues/22649#issuecomment-1336648036

   I solved the problem. The reason: I from MySQLCreateTableStatement getColumnDefinitions here take the primary key, but I define the primary key is in the upper, MySQLCreateTableStatement getConstraintDefinitions is a primary key, sorry.


-- 
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] strongduanmu commented on issue #22649: Table creation did not obtain the primary key, please provide a solution

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

strongduanmu commented on issue #22649:
URL: https://github.com/apache/shardingsphere/issues/22649#issuecomment-1336573656

   What is your exception?


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