upgrade v2.2303.0 to v2.2304.0 #1486
ColdWaterLW
started this conversation in
Upgrade
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
Uh oh!
There was an error while loading. Please reload this page.
-
版本升级方案
老版本升级到2.2304.0 需要对SQLE的元数据表进行结构变更,变更内容如下:
表
execute_sql_detail和audit_plan_report_sqls_v2的列audit_result弃用,新增列audit_results,新的列相比旧的列变化如下:变更前:
变更后:
[{"rule_name":"ddl_check_column_without_default","level":"error","message":"除了自增列及大字段列之外,每个列都必须添加默认值"},{"rule_name":"ddl_check_table_without_if_not_exists","level":"error","message":"新建表必须加入 if not exists,保证重复执行不报错"}]升级说明
sqle-upgrade-2303-2304升级工具的使用
1. 工具参数如下:
2. 示例:
./sqle-upgrade-2303-2304 \ --mysql-user {your_user} \ --mysql-password {your_pass} \ --mysql-host {your_mysq_host} \ --mysql-port {your_mysql_port} \ --schema sqle版本不兼容的 issue 列表
Beta Was this translation helpful? Give feedback.
All reactions