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

登记你想要加的SQL审核规则,我们来实现 #929

Open
sjjian opened this issue Oct 11, 2022 · 1 comment
Open

登记你想要加的SQL审核规则,我们来实现 #929

sjjian opened this issue Oct 11, 2022 · 1 comment

Comments

@sjjian
Copy link
Member

sjjian commented Oct 11, 2022

在本issue下回复信息来登记你想要加的SQL审核规则,信息包含数据库类型、规则内容、添加的背景。我们会定期实现。

示例:

  • 数据库类型:MySQL
  • 规则:禁止使用 SELECT *
  • 背景:当表结构变更时,使用*通配符选择所有列将导致查询行为会发生更改,与业务期望不符;同时select * 中的无用字段会带来不必要的磁盘I/O,以及网络开销,且无法覆盖索引进而回表,大幅度降低查询效率
@bdper0
Copy link

bdper0 commented Oct 31, 2022

数据库类型:MySQL
规则:禁止使用 create index 创建索引
背景:禁止使用 create index 创建索引,需要更改为alter table add index来创建。 create index会导致aws dms同步工具异常。

@taolx0 taolx0 unpinned this issue Jan 10, 2023
@sjjian sjjian pinned this issue Jan 30, 2023
@hasa1K hasa1K unpinned this issue Aug 15, 2023
@sjjian sjjian pinned this issue Aug 17, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants