Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

修改表备注时sqlsha1为空 #624

Open
dbadylan opened this issue Nov 20, 2023 · 4 comments
Open

修改表备注时sqlsha1为空 #624

dbadylan opened this issue Nov 20, 2023 · 4 comments

Comments

@dbadylan
Copy link

dbadylan commented Nov 20, 2023 •
edited
Loading

描述
对一张表的备注进行修改时，如 ALTER TABLE t COMMENT = 'test';，返回的审核结果中，sqlsha1列的值为空

重现
每次必现

环境

  • 数据库：mysql
  • 版本：5.7.29，8.0.25
@dbadylan dbadylan changed the title 修改表备注时SQL啥 修改表备注时sqlsha1为空 Nov 20, 2023
@hanchuanchuan
Copy link
Owner

只有使用pt-osc/gh-ost时才会计算sqlsha1. 不满足表大小条件限制时也会忽略sqlsha1.

@dbadylan
Copy link
Author

只有使用pt-osc/gh-ost时才会计算sqlsha1. 不满足表大小条件限制时也会忽略sqlsha1.

所有的ddl都走的gh-ost，也没限制表的大小。

@hanchuanchuan
Copy link
Owner

修改部分表定义时会自动跳过osc. 包括 charset/collate/comment. 这些操作只修改元数据,是立即完成的.

@hanxiaoxudoubao
Copy link

“修改部分表定义时会自动跳过gh-ost ”,这块具体怎么定义的，规则是什么，求指教，目前大表新增字段有after也不走

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@hanchuanchuan @dbadylan @hanxiaoxudoubao