NewYour coding agent can read the release notes before it upgrades.Set up the MCP server →
Go modules, #1113 by repository stars
Latest stable
v1.3.0
Last release 2 years ago
no release in 18 months
Ships fairly regularly
a new release about every 3 months
Nearly every release is documented
notes for 35 of 35 stable releases
Nothing withdrawn
no release was ever pulled
8 years old
90 releases · first in 2019
Drag across the ruler to compare, or tap a release to open it.
### Update * 优化对象名大小写审核逻辑 * 优化索引长度审核准确性 * 支持update多表更新语法(暂不支持多表回滚) (#112) * 优化sql语法解析失败时的错误信息
Nothing published for this version
Your coding agent can read these notes before it upgrades. Set up the MCP server →
修复alter table rename语句的回滚SQL生成错误问题
real_row_count选项时,DML转select count时未处理limit的问题 (#119)hex_blob ,以支持回滚时解析二进制类型 (#118)real_row_count option is turned on (#119)hex_blob to support parsing binary types when rolling back (#118)修复表内有text,json等[]byte类型字段时最小化生成回滚语句panic的问题 (#105,#107)
decimal类型逆向解析时变为科学计数法形式的问题 (#106,#108)check_implicit_type_conversion ,审核where条件中的隐式类型转换 (#101)decimal type becomes scientific notation during reverse analysis (#106,#108)check_implicit_type_conversion to audit the implicit type conversion in the where condition (#101)添加设置参数 enable_minimal_rollback, 用以开启最小化回滚SQL设置
enable_minimal_rollback, 用以开启最小化回滚SQL设置 (#90)wait_timeout, 用以设置远端数据库等待超时时间,默认为0,即保持数据库设置--ssl等, 可配置SSL或CA证书验证 (#92)enable_minimal_rollback to enable the minimized rollback SQL setting (#90)wait_timeout to set the remote database waiting timeout time, the default is 0, that is to keep the database settings--ssl, etc., configurable SSL or CA certificate verification (#92)修复insert select语法在有删除列时列数校验可能不准确的问题
insert select语法在有删除列时列数校验可能不准确的问题explain_rule ,用以设置explain获取受影响行数方式spatial index审核规则insert select syntax may be inaccurate when there are deleted columnsexplain_rule to set how explain gets the number of affected rowsspatial index修复add column操作未命中merge_alter_table检测的问题
merge_alter_table检测的问题 (#79)--db,用以设置默认连接的数据库,默认值为mysqlinnodb_large_prefix参数判断merge_alter_table (#79)--db to set the default connection database, the default value is mysqlinnodb_large_prefix parameter judgment修复insert values子句不支持default语法的问题
default_charset 用以设置连接数据库的默认字符集,默认值utf8mb4 (解决低版本不支持utf8mb4的问题)osc_check_unique_key_change, 设置pt-osc是否检查唯一索引,默认为truedefault_charset to set the default character set for connecting to the database, the default value is utf8mb4 (to solve the problem that the lower version does not support utf8mb4)osc_check_unique_key_change, set whether pt-osc checks the unique index, the default is true完善update set多字段审核规则,为set多列and语法添加警告
update set多字段审核规则,为set多列and语法添加警告update set multi-field audit rules, add warnings for set multi-column and syntax[gh-ost] 修复gh-ost在异常时没有断开binlog dump连接的问题
[gh-ost] 修复gh-ost在异常时没有断开binlog dump连接的问题[gh-ost] 修复gh-ost当添加datetime列且默认值current_timestamp时,增量数据因时区导致数据错误的问题(timestamp列是正常的)enable_change_column ,设置是否支持change column语法real_row_count,设置是否通过count(*)获取真正受影响行数.默认值falsept-osc bug)[gh-ost] fixed the problem that gh-ost did not disconnect the binlog dump connection when abnormal[gh-ost] Fix the problem that when adding datetime column and default value current_timestamp in gh-ost, incremental data will cause data error due to time zone (timestamp column is normal)enable_change_column to set whether to support change column syntaxreal_row_count to set whether to get the number of really affected rows through count(*). The default value is false修复 alter table 命令没有其他选项时能正常通过的bug
alter table 命令没有其他选项时能正常通过的bug (#59)max_ddl_affect_rows,设置DDL允许的最大受影响行数,默认为0,即不限制check_float_double ,为 true 时,警告将 float/double 转成 decimal 数据类型。 默认为 false (#62)check_identifier_upper ,限制表名、列名、索引名等必须为大写,默认为false (#63)enable_level,现在自定义审核级别和审核开关设置合并 (#52)alter table command can pass normally without other options (#59)max_ddl_affect_rows to set the maximum number of affected rows allowed by DDL, the default is 0, which means no limitcheck_float_double, when it is true, warn that float/double will be converted to decimal data type. Default is false (#62)check_identifier_upper to restrict table names, column names, index names, etc. must be uppercase, the default is false (#63)enable_level, now the custom audit level and audit switch settings are merged (#52)修复 must_have_columns 参数列类型的大小写兼容问题
must_have_columns 参数列类型的大小写兼容问题alter table rename index 语法支持enable_zero_date,设置是否支持时间为0值,关闭时强制报错。默认值为 true (#55)enable_timestamp_type ,设置是否允许 timestamp 类型字段 (#57)mysql 5.5 版本审核支持 (#54)must_have_columns parameter column typealter table rename index syntax supportenable_zero_date to set whether to support the time value of 0, and force an error to be reported when it is closed. The default value is true (#55)enable_timestamp_type to set whether to allow the timestamp type field (#57)mysql 5.5 version audit support (#54)Nothing published for this version
修复gh-ost的initially-drop-old-table和initially-drop-ghost-table参数支持
修复kill DDL操作时,返回执行和备份成功的bug,现在会提示执行结果未知了
优化insert select新表的审核规则,现在select新表时也可以审核了
添加alter table的ALGORITHM,LOCK,FORCE语法支持
重新设计kill操作支持,支持远端数据库kill和goInception kill命令
修复在开启备份时,执行错误时偶尔出现的误标记执行/备份成功bug (重要!!!)
check_column_type_change参数,设置是否审核字段类型变更,默认开启 (#27)添加enable_json_type参数,设置是否允许json类型字段
enable_json_type参数,设置是否允许json类型字段 (#26)优化json类型字段处理逻辑,不再检查其默认值和NOT NULL约束 (#7, #22)
enable_null_index_name参数,允许不指定索引名 (#25)修复mysql 5.6和mariadb无法获取受影响行数的问题
添加max_insert_rows参数,设置insert values允许的最大行数。
max_insert_rows参数,设置insert values允许的最大行数。must_have_columns参数,用以指定建表时必须创建的列。多个列时以逗号分隔(格式: 列名 [列类型,可选])添加不支持的语法警告(create table as和create table select)
添加远端数据库断开重连机制,优化线程号和master status查询速度
inception set enable_fingerprint=1或配置文件开启全局配置--fingerprint=1开启单个配置## [v0.5.3-beta] - 2019-3-25 ### Update * 变更列名时使用逻辑校验,避免explain update失败 * 添加union子句校验 * 添加表名别名重复性校验 ### Fix * 修复update set子句指定表别名时校验问题 * 修复自增列校验问题 *
### Update * 优化主键NULL列审核规则(审核DEFAULT NULL) * 优化索引总长度校验,根据列字符集判断字节数长度 * 优化DDL备份对默认值的处理
DEFAULT NULL)lang 设置返回的异常信息语言,可选值 en-US,zh-CN,默认en-US
en-US,zh-CN,默认en-US添加mariadb的binlog解析支持(测试版本v5.5.60,v10版本由于binlog格式改变,暂无法解析thread_id)
Nothing published for this version
One column per quarter.