Fix

• 修复insert时的非空列审核逻辑(忽略自增列) (#113)
• 修复alter table rename语句的回滚SQL生成错误问题
• 修复在开启real_row_count选项时,DML转select count时未处理limit的问题 (#119)

New Features

• 添加新参数 hex_blob ,以支持回滚时解析二进制类型 (#118)

Fix

• Fix the problem of minimizing the panic generation of rollback statements when there are text, json and other []byte type fields in the table (#105,#107)
• Fix the problem that the decimal type becomes scientific notation during reverse analysis (#106,#108)
• Fix a bug that caused thread safety issues when parsing call parameters during multi-threaded high-concurrency testing (#103)

New Features

• Add the audit option check_implicit_type_conversion to audit the implicit type conversion in the where condition (#101)

Update

• Added TiDB database judgment (tidb backup is not supported)
• Add field ambiguity review when table prefix is not specified

Fix

• Fix the problem that the thread number cannot be backed up when the thread number exceeds the uint32 range

New Features

• Add the setting parameter enable_minimal_rollback to enable the minimized rollback SQL setting (#90)
• Add the setting parameter wait_timeout to set the remote database waiting timeout time, the default is 0, that is to keep the database settings
• Add mysql secure connection parameter setting --ssl, etc., configurable SSL or CA certificate verification (#92)

Fix

• Fix the problem of explain error in TiDB database (#86)
• Fix the problem that the column number verification of insert select syntax may be inaccurate when there are deleted columns

New Features

• Add the review option explain_rule to set how explain gets the number of affected rows

Update

• Improve the audit rules of spatial index
• Adjustments to update syntax are all logically reviewed
• Added ON clause review of join syntax
• Optimize the delete audit rules, skip the explain audit when there are new tables
• When the remote database cannot be connected, optimize the return result and add sql content to return

Fix

• Fix the problem that the add column operation misses the detection of merge_alter_table (#79)

New Features

• Add spatial type syntax analysis, add spatial index support
• Add a new call option --db to set the default connection database, the default value is mysql

Update

• Support operations such as creating tables at the same time when building a database (#77)
• Optimize the details of DDL rollback, adjust the rollback SQL for multiple clauses of alter table to reverse (#76)
• Add database read-only status judgment before execution
• Optimize the total length of the index audit, now based on the target library innodb_large_prefix parameter judgment
• Review the asterisk column in the select syntax
• Optimize the multi-statement splitting and parsing logic, and optimize the SQL parsing at the end of the semicolon but not the end
• Improve the index check in the column definition

Fix

• Fix the problem that the insert values ​​clause does not support the default syntax

New Features

• Add the parameter default_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)
• Add the pt-osc parameter osc_check_unique_key_change, set whether pt-osc checks the unique index, the default is true

Update

• Optimize the rollback function, add binlog_row_image setting check, and automatically modify the session level to full when it is minimal

New Features

• Add syntax support for set names (#69)

Update

• Optimize the primary key index audit information (#67)
• Improve update set multi-field audit rules, add warnings for set multi-column and syntax
• Optimize gh-ost socket file name generation rules to avoid creation failure due to length overflow
• Improve foreign key review rules (#68,#70)

Fix

• [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)

New Features

• Add parameter enable_change_column to set whether to support change column syntax
• Add calling option real_row_count to set whether to get the number of really affected rows through count(*). The default value is false

Update

• Add pt-osc to perform change column audit, prohibit multiple change column operations to avoid data loss (pt-osc bug)

Fix

• Fix the bug that the alter table command can pass normally without other options (#59)
• Fix the problem that backup records may be written wrongly in the backup library during cross-database operations

New Features

• Add parameter max_ddl_affect_rows to set the maximum number of affected rows allowed by DDL, the default is 0, which means no limit
• Add parameter check_float_double, when it is true, warn that float/double will be converted to decimal data type. Default is false (#62)
• Add parameter check_identifier_upper to restrict table names, column names, index names, etc. must be uppercase, the default is false (#63)

Update

• Optimize the implementation of custom audit level, remove the parameter enable_level, now the custom audit level and audit switch settings are merged (#52)
• Upgrade parser grammar analysis package, optimize column sorting rules and partition table grammar support (#50)
• Optimize the automatic change of gh-ost's server_id setting to avoid duplication of the same instance

Fix

• Fix the case compatibility problem of must_have_columns parameter column type

New Features

• Added alter table rename index syntax support
• Add the parameter enable_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)
• Add the parameter enable_timestamp_type to set whether to allow the timestamp type field (#57)
• Add mysql 5.5 version audit support (#54)

Update

• Optimize the logical storage of modify column information
• Optimize the key definition logic preservation of column attributes