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/10/10 06:37:53 UTC

[GitHub] [shardingsphere] nagae-memooff opened a new issue, #18661: table name suffix duplicated in index name after scaling tables

nagae-memooff opened a new issue, #18661:
URL: https://github.com/apache/shardingsphere/issues/18661

   I'm using ShardingSphere-Proxy 5.1.1.
   
   When I create a table with index, I found there is a table name suffix appended to the original index name.
   It's OK, I know it is not a bug but a feature as HERE said: https://github.com/apache/shardingsphere/issues/17073.
   
   
   But when I scale my data to new database instances, I found that the same table name suffix was appended again and exceed the 64 bytes index name limit.
   
   For example:
   my original create table sql:
   
   ```
   CREATE TABLE `message_threads` (
   ...
     PRIMARY KEY (`id`),
     KEY `index_message_threads_on_id` (`id`),
     KEY `index_message_threads_on_starter_id` (`starter_id`)
   )
   ```
   and if I execute show create table on databases, it will be that:
   
   ```
   Create Table: CREATE TABLE `message_threads` (
   ...
     PRIMARY KEY (`id`),
     KEY `index_message_threads_on_id_message_threads` (`id`),
     KEY `index_message_threads_on_starter_id_message_threads` (`starter_id`)
   )
   ```
   
   and If I try to scale the db to new database instances, It' ll raise a failure with this Error: 
   ```
   Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Identifier name 'index_message_threads_on_starter_id_message_threads_message_threads' is too long
   ```
   ![image](https://user-images.githubusercontent.com/4215831/176155730-4b795344-82a8-4987-a5dc-1fa378693fc6.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] github-actions[bot] commented on issue #18661: table name suffix duplicated in index name after scaling tables

Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #18661:
URL: https://github.com/apache/shardingsphere/issues/18661#issuecomment-1272349558

   Hello , this issue has not received a reply for several days.
   This issue is supposed to be closed.


-- 
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] RaigorJiang commented on issue #18661: table name suffix duplicated in index name after scaling tables

Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang commented on issue #18661:
URL: https://github.com/apache/shardingsphere/issues/18661#issuecomment-1407571476

   Duplecated with #17073.


-- 
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] github-actions[bot] closed issue #18661: table name suffix duplicated in index name after scaling tables

Posted by GitBox <gi...@apache.org>.
github-actions[bot] closed issue #18661: table name suffix duplicated in index name after scaling tables
URL: https://github.com/apache/shardingsphere/issues/18661


-- 
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] RaigorJiang closed issue #18661: table name suffix duplicated in index name after scaling tables

Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang closed issue #18661: table name suffix duplicated in index name after scaling tables
URL: https://github.com/apache/shardingsphere/issues/18661


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