v1.3.0 Latest

Latest

Compare

Choose a tag to compare

v1.2.5

Compare

Choose a tag to compare

Fix

• Fix the problem that the ghost_initially_drop_socket_file parameter of gh-ost does not take effect (#382)
• Fix the inconsistency of index prefix between Chinese and English (#380)
• Fix the problem that the number of affected rows may overflow (#375)
• Fix the problem that the default value of bit type is set to NULL and it cannot be approved (#346)
• Fix the problem that pt-osc fails to execute when connecting to a port other than 3306 (#335)
• Fix the bug that dml of tidb v4.0 version cannot be audited
• Fix the problem that the calculated column is not ignored in the dml rollback statement (#324)
• Fix the problem that the rename table syntax does not take effect logically when multiple table names are modified at one time (#327)

New Features

• Added the check_identifier_lower parameter to enable lowercase requirements for table names, column names, and index names (#389)
• Add masking function-syntax tree parsing function upgrade, return objects involved in select (library, table, column) (#355)
• Added ghost_bin_dir parameter setting from switching gh-ost mode, independent gh-ost module, using binary method to call to optimize the possible bugs when ddl high concurrency and kill gh-ost process (#334)
• Add option max_execution_time to set the maximum execution time of session-level DML statements (#319)
• Added enable_any_statement option to support all syntaxes to be executable (#301)

Update

• Optimize the keyword review logic of alter table modification column clauses (#392)
• Optimize group by clause review logic (#385)
• Add datetime decimal second check (#369)
• Add view support for union
• Fine-tune the insert column value check logic in strict mode
• Optimize the character type length audit logic
• Optimize the handling of database connection timeout (#306)
• Improve character set and collation review logic, add utf8mb4_0900_ai_ci collation support

v1.2.4

Compare

Choose a tag to compare

Fix

• Fixed the problem that dml may not be backed up successfully in MariaDB
• Fix the issue of audit errors when updating the specified table alias (#249)
• Fix the problem that the child query in the select column may not find the parent table column and the having clause may not find the column (#266)
• Fix the problem of falsely reporting error when not calling in the correct format
• Fix the problem that the float type parameter specified in the inception set syntax will report an error (#279)
• Fix the status indicator when the backup statement is not parsed correctly (#286)

New Features

• Add lock_wait_timeout to control the lock wait timeout time during normal SQL execution (#224)
• Increase the sleep parameter of pt-osc to optimize the load situation when the low configuration db executes ddl changes (#260)
• Add view support (#238,#262)
• Add the parameter ignore_osc_alter_stmt to configure the syntax to force the osc check to be ignored (#258,#263)
• Added CREATE TABLE AS SELECT syntax support (#246,#264)
• Add auto_random support for tidb column attributes (#270)
• Add sql_mode option when inc is executed (#267)
• Add illegal date review when inserting (#277)

Update

• Optimize index visibility audit support for multi-version databases (#247)
• Optimize the binlog analysis of the backup function (#250)
• Improve MySQL8.0 keyword list (#210)
• Optimize the configuration of the default database, the use operation can be omitted after specifying the --db option
• Optimize the osc process processing logic and add concurrent lock processing
• Improve alter table partition syntax (#281)
• Optimize the processing of the backup function when ssl is turned on (#287)

v1.2.3

Compare

Choose a tag to compare

Fix

• fix: Fix the problem that pt-osc cannot be killed when getting the table lock stuck (#213, #222)

New Features

• Add the parameter ignore_sighup, the terminal connection disconnection signal is ignored by default (#195)
• Add osc_lock_wait_timeout parameter to control pt-osc wait for meta lock time, default 60s (#214, #215)
• Support multiple custom index prefixes (#204)

Update

• Improve MySQL5.7 keyword list (#210)

v1.2.2

Compare

Choose a tag to compare

Fix

• Fix the problem of erroneous review when max_char_length is not specified
• Fix the problem of inaccurate index column length limit (#176)
• Fix the problem that the inception set command returns an error, and fix the problem that the lang setting may not take effect
• Fix the problem that errors may occur during mixed execution of DDL and DML when opening a transaction (#182)

New Features

• Add session-level variable settings (#157, #166, #167)
• Add the osc parameter osc_max_flow_ctl so that the PXC cluster can enable the pt-osc function (#170, #172)
• Add audit item columns_must_have_index, index must be added to the specified column (#174, #175)

Update

• Optimize column character set and collation review logic (#173)
• Add review of value expressions in where conditions to avoid incorrect updates of invalid expressions (#178)
• Optimize the printing of internal SQL that must be executed with privileges when authentication fails, so that the problem can be quickly located

v1.2.1

Compare

Choose a tag to compare

Fix

• Optimize the problem that the comments before and after the ALTER statement when using the pt tool may cause its parsing failure

New Features

• Add version number information to system variables show variables like'version' (#164)

Update

• When opening the parameter for obtaining the actual number of affected rows, ignore the sql fingerprint function (accuracy first)
• Automatically remove the special spaces at the beginning and end of each SQL line (ASCII code 160)
• Optimized bit type default value audit, now supports audit like b'1'
• Optimize the error message when the data source is not configured correctly to make it more friendly
• Cache the setting of the unique key when creating a table
• Improve the display width review of numeric types (#162)

v1.2.0

Compare

Choose a tag to compare

Fix

• Fix the bug that the change column was not properly reviewed when the column name was modified and the old column name was quoted immediately (#150)
• Fixed the problem of incorrect review when using the wrong length of the year type
• Fix the problem that the audit logic of ON clause of join grammar is incorrect

New Features

• Table name and index name prefix customization (#149)
  • Table name prefix table_prefix, the default is empty, that is, unlimited
  • Index prefix index_prefix, the default is idx_, which is consistent with the previous version and can be customized
  • Unique index prefix uniq_index_prefix, the default is uniq_, which is consistent with the previous version and can be customized

Update

• Optimize the alter clause parsing when using the pt tool
• Optimize the log output of gh-ost and backup functions and adjust to a unified format
• Optimize the parameter settings of the default database, adjust the default mysql library to be empty by default to avoid affecting the master-slave synchronization under special circumstances

v1.1.6

Compare

Choose a tag to compare

Fix

• Fix the issue of incorrect audit of timestamp type switch
• Fix the bug that the DML operation is not submitted correctly when the instance is not turned on autocommit (#146)

New Features

• Add user authentication module to realize user management and secure connection function (#132)
• Add transaction support(batch execution) (#135)

Update

• Optimize column type change review (#121)
• Implement rollback support when update set with multiple tables (#112,#136)
• Optimize audit rules when case-sensitive (#123)
• Optimize the alter clause split logic when using the pt-osc tool (#142)