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:41:28 UTC
[GitHub] [shardingsphere] VeejaLiu opened a new issue, #17073: During scaling, the index in the statement generating the table exceeds the length limit.
VeejaLiu opened a new issue, #17073:
URL: https://github.com/apache/shardingsphere/issues/17073
## Bug Report
<img width="2551" alt="image" src="https://user-images.githubusercontent.com/22064617/164973772-8089c928-3147-4b54-a0d4-5d2ff5571151.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
Re: [I] During scaling, the index in the statement generating the table exceeds the length limit. [shardingsphere]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #17073:
URL: https://github.com/apache/shardingsphere/issues/17073#issuecomment-2026020572
There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.
--
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] VeejaLiu commented on issue #17073: During scaling, the index in the statement generating the table exceeds the length limit.
Posted by GitBox <gi...@apache.org>.
VeejaLiu commented on issue #17073:
URL: https://github.com/apache/shardingsphere/issues/17073#issuecomment-1108110989
@sandynz I think we should deal with such corner cases, I think this is a bug.
--
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 #17073: During scaling, the index in the statement generating the table exceeds the length limit.
Posted by GitBox <gi...@apache.org>.
github-actions[bot] closed issue #17073: During scaling, the index in the statement generating the table exceeds the length limit.
URL: https://github.com/apache/shardingsphere/issues/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] sandynz commented on issue #17073: During scaling, the index in the statement generating the table exceeds the length limit.
Posted by GitBox <gi...@apache.org>.
sandynz commented on issue #17073:
URL: https://github.com/apache/shardingsphere/issues/17073#issuecomment-1108045398
The create table SQL is generated and rewritten by kernel.
--
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 #17073: During scaling, the index in the statement generating the table exceeds the length limit.
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #17073:
URL: https://github.com/apache/shardingsphere/issues/17073#issuecomment-1110394276
@sandynz Thank you for your remind. @VeejaLiu This is not a bug, the logical index will add the actual table suffix in ShardingSphere. I think you should adjust the length of the logic logical index to avoid the actual index being too long.
--
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] VeejaLiu commented on issue #17073: During scaling, the index in the statement generating the table exceeds the length limit.
Posted by GitBox <gi...@apache.org>.
VeejaLiu commented on issue #17073:
URL: https://github.com/apache/shardingsphere/issues/17073#issuecomment-1165744902
@terrymanu I didn't solve the problem. I just shorten the length of the index to suit you.
Your side... I don't know.
--
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
Re: [I] During scaling, the index in the statement generating the table exceeds the length limit. [shardingsphere]
Posted by "ayundi123 (via GitHub)" <gi...@apache.org>.
ayundi123 commented on issue #17073:
URL: https://github.com/apache/shardingsphere/issues/17073#issuecomment-1958972187
mysql索引超长的问题可以通过修改这行代码解决。
--
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] VeejaLiu commented on issue #17073: During scaling, the index in the statement generating the table exceeds the length limit.
Posted by GitBox <gi...@apache.org>.
VeejaLiu commented on issue #17073:
URL: https://github.com/apache/shardingsphere/issues/17073#issuecomment-1110505406
@strongduanmu
Thank you!
It explains the matter
I've only used MySQL and haven't thought about other databases.
This is really a thorny problem.
Thank you for your reply.
--
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
Re: [I] During scaling, the index in the statement generating the table exceeds the length limit. [shardingsphere]
Posted by "VeejaLiu (via GitHub)" <gi...@apache.org>.
VeejaLiu commented on issue #17073:
URL: https://github.com/apache/shardingsphere/issues/17073#issuecomment-1956357410
hhhh, still in status: volunteer wanted
--
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] sandynz commented on issue #17073: During scaling, the index in the statement generating the table exceeds the length limit.
Posted by GitBox <gi...@apache.org>.
sandynz commented on issue #17073:
URL: https://github.com/apache/shardingsphere/issues/17073#issuecomment-1109780275
Hi @strongduanmu , could you help to have a look at this issue?
--
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] VeejaLiu commented on issue #17073: During scaling, the index in the statement generating the table exceeds the length limit.
Posted by GitBox <gi...@apache.org>.
VeejaLiu commented on issue #17073:
URL: https://github.com/apache/shardingsphere/issues/17073#issuecomment-1110487424
@strongduanmu
Thank you for your reply.
But I don't agree with you. In the production environment, it's normal to have a long table name or index name.
Even because of some historical factors, this bad design may already exist in the user's system. But we can't blame our users for this. I think as middleware developers, we should achieve maximum compatibility and non-invasive. We should predict this situation in advance and take corresponding actions, rather than let users modify their design (even bad design).
Finally, thank you for your reply.
--
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] commented on issue #17073: During scaling, the index in the statement generating the table exceeds the length limit.
Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #17073:
URL: https://github.com/apache/shardingsphere/issues/17073#issuecomment-1272349932
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] VeejaLiu closed issue #17073: During scaling, the index in the statement generating the table exceeds the length limit.
Posted by GitBox <gi...@apache.org>.
VeejaLiu closed issue #17073: During scaling, the index in the statement generating the table exceeds the length limit.
URL: https://github.com/apache/shardingsphere/issues/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] strongduanmu commented on issue #17073: During scaling, the index in the statement generating the table exceeds the length limit.
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #17073:
URL: https://github.com/apache/shardingsphere/issues/17073#issuecomment-1110496415
@VeejaLiu Of course, I agree that ShardingSphere should be as compatible with native databases as possible, but ShardingSphere needs to consider different databases, and indexes with the same name are not allowed in PostgreSQL databases, which is the reason for index rewriting.
If you are interested, you can try to sort out the index requirements of different databases, and then optimize the logic of existing index rewriting.
--
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] terrymanu commented on issue #17073: During scaling, the index in the statement generating the table exceeds the length limit.
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #17073:
URL: https://github.com/apache/shardingsphere/issues/17073#issuecomment-1165722203
Is the problem resolved?
--
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
Re: [I] During scaling, the index in the statement generating the table exceeds the length limit. [shardingsphere]
Posted by "ayundi123 (via GitHub)" <gi...@apache.org>.
ayundi123 commented on issue #17073:
URL: https://github.com/apache/shardingsphere/issues/17073#issuecomment-1956224741
最终这个问题不解决了吗？
--
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