Fix the problem caused by splicing empty strings in MogDB/openGauss/MySQL, compatible with mariadb
v3.1.0 (2022-10-10)
Improvements
License version upgrade to v31, older license file does not supported
Bugfixs
Fix the problem caused by splicing empty strings in MogDB/openGauss when comparing primary key tables
v3.0.1 (2022-09-23)
Features
Add "--upgrade" option to support command self-upgrade
Support comparison for PostgreSQL
Support remap for schema and table name in single table mode (with "-T" option used)
Support remap and filter for columns in single table mode (with "-T" option used)
Improvements
Query optimization for Oracle table without primary key
Data query sorting rules adjustment (with primary key sorted by primary key, without primary key sorted by MD5 value)
Bugfixs
Repair the query error caused by multi-byte characters in Oracle fields under some scenarios
v3.0.0 (2022-06-09)
Features
Add options: "-L", "--license", "--apply-licnese", used for apply and verify license
Add option: "--column-list", support partial column comparion
Improvements
Use "--debug-md5" option can output primary key in source and target database
When comparing with statistics method, filter columns before query
Adjust the display of empty characters in object names (use double quotes to wrap them)
Support for MySQL with object names without space compared to other databases with space in name
Add debug information for openGauss SQL executions
Bugfixs
Fix "NULL" (None in python) value returns when comparision with primary key
Remove "public" schema out of system schema list in openGauss
v2.4.8 (2022-04-22)
Feature
When comparing objects, MogDB adds Package objects (2.1 and later versions) and SYNONYM objects comparison
Add recognition of OS local variables (TMPDIR, TMP) for storing temporary data during program runtime when comparing Oracle/DB2 databases
Add -Z option to manually specify the time zone used for data comparison in different databases at runtime
Function Optimization
Fine-tuned final results presentation for better readability
Optimize the output of the --debug-md5 option during data comparison to provide a more detailed view of the bilateral data comparison process
Optimize -T mode to support -r specified Schema mapping even in single table comparison mode
Bugfix
Fix the issue of abnormal comparison results caused by different sorting rules of primary key tables in openGauss/MogDB when querying
Fix the issue of program error caused by the failure of primary key identification in the comparison of non-primary key table.
Fix the issue of inconsistent sorting data due to mixed case of primary key field names in different databases ("TID").
Fix the issue of inconsistent data in the unilateral database which cannot be correctly identified.
Fix the issue that the comparison result of primary key table is incorrect due to the space at the end of the primary key field.
Fix the issue that the query field appears several times in Oracle/DB2 (primary key table), which leads to the query error.
Fix the issue of incorrect data comparison caused by trailing space of char type in MySQL database.
v2.4.0 (2021-12-20)
Feature
Add the category option (-C/--catagory): supports object structure comparison only and data comparison only.
Add the debug option (--debug-md5): outputs the original value of the Python MD5 computing result during data comparison.
Add the schema remapping option (--remap-schema): supports data comparison even if the name of a schema in a source or target database is changed.
Function Optimization
Optimize the data comparison logic: For tables with primary keys, comparison is implemented by primary key. Additionally, the values of the primary keys and the MD5 computing results of the source and target databases will be output in the result.
Optimize the output result: The display of the object structure comparison result and data comparison result is rewritten, thereby facilitating reading and understanding.
Optimize the DB2 connection mode: During DB2 database connection, more authentication methods can be used (SERVER_ENCRYPT, SERVER, CLIENT, and default).
Bugfix
Fix the data comparison failure caused by invisible characters chr(0), and add the -z/--zero-char option for specifying the conversion character of chr(0) during migration.
Fix the issue that the numeral modulo operator is unavailable in some versions during restoration of the DB2 database.
v2.3.2 (2021-11-08)
Bugfix
Resolve the table constraint comparison error in MySQL earlier than 8.0. Therefore, MySQL 5.5, 5.7, and 8.0 are supported.
Resolve the problem that the data types of return values in the Python driver for the fields in MySQL of different versions are different.
v2.3.1
Bugfix
Resolve the error that the program is abnormal because the return value of the driver is str/byte for the MySQL query field type in some versions.
Resolve the error that the return value of the lsb_release -a command is incorrect when the MySQL driver is to obtain the OS version in SUSUE.
v2.3.0
Feature
Support the sha256 authentication method for openGauss/MogDB in Linux.