hanchuanchuan / goInception

一个集审核、执行、备份及生成回滚语句于一身的MySQL运维工具
https://hanchuanchuan.github.io/goInception/
GNU General Public License v3.0
1.6k stars 545 forks source link

er_index_use_alter_table 不起作用 #577

Open xqzt opened 1 year ago

xqzt commented 1 year ago

描述 er_index_use_alter_table =2 的情况下 , create index idx_c_mode on sbtest1(c_mode4) 语句依然可以通过审核

> inception show levels whereNamelike '%er_index_use_alter_table%'; +--------------------------+-------+-----------------------------------------------------------------------------------+ | Name | Value | Desc | +--------------------------+-------+-----------------------------------------------------------------------------------+ | er_index_use_alter_table | 2 | Create/drop index and rename is not allowed, please replace with alter statement. | +--------------------------+-------+-----------------------------------------------------------------------------------+ 1 row in set (0.00 sec)

['order_id', 'stage', 'error_level', 'stage_status', 'error_message', 'sql', 'affected_rows', 'sequence', 'backup_dbname', 'execute_time', 'sqlsha1', 'backup_time'] 1 | CHECKED | 0 | Audit Completed | None | usetestmesscode| 0 | 0_0_00000000 | None | 0 | None 2 | CHECKED | 0 | Audit Completed | None | update sbtest1 set k=2496411 where id=1 | 1 | 0_0_00000001 | None | 0 | None 3 | CHECKED | 0 | Audit Completed | None | create index idx_c_mode on sbtest1(c_mode4) | 4930170 | 0_0_00000002 | None | 0 | None

stale[bot] commented 1 year ago

由于此问题没有最近的活动,因此已被自动标记为陈旧。如果没有进一步的活动,会作为不活跃issue关闭。感谢你对本项目的贡献。 This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

hanchuanchuan commented 1 year ago

相关校验未使用, 后续待修复.