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.

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

智能扫描补充端点信息 (需要升级方案) #2616

Closed
2 tasks done
Tracked by #2572
taolx0 opened this issue Sep 19, 2024 · 1 comment
Closed
2 tasks done
Tracked by #2572

智能扫描补充端点信息 (需要升级方案) #2616

taolx0 opened this issue Sep 19, 2024 · 1 comment
Assignees
Labels
bug Something isn't working not_compatible not compatible old version publish-pre3 verified the issue all pr is verified
Milestone

Comments

@taolx0
Copy link
Collaborator

taolx0 commented Sep 19, 2024

描述

SQL管控列表的endpoint字段应该用数组类型,而不是字符串,因为它包含多个值。

方案

  • 重构原有数据库Endpoint字段由字符串转为字符串数组
  • 支持Endpoint字段数组返回

升级方案

移除 sql_manage_queues 和 sql_manage_records 表的endpoint字段

USE sqle;

ALTER TABLE sql_manage_queues
    DROP COLUMN end_point;

ALTER TABLE sql_manage_records
    DROP COLUMN end_point;

影响面

endpoint字段由字符串类型重构为字符串数组类型

@taolx0
Copy link
Collaborator Author

taolx0 commented Nov 5, 2024

end1
end2

@taolx0 taolx0 added the verified the issue all pr is verified label Nov 5, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working not_compatible not compatible old version publish-pre3 verified the issue all pr is verified
Projects
None yet
Development

No branches or pull requests

2 participants