Release 2.9 Notes

mtk command line tool
mtkd mtk background service process. used for specific scenarios

v2.9.7

2024-03-08

MTK

MTKD

Bug Fixes

DM: query index partition issue and mig to mogdb partition issue
DM: Issues with migrating partitioned tables to MogDB
DM: Migrate view issue
DM: Migrate of virtual columns problem
MogDB: Problem in migrating Bool type data in B mode
MogDB: Migrate Hash partition sorting problem
MogDB: The problem of missing semicolons in migrating MySQL stored procedures
MogDB: Migrate MySQL stored procedure parameter annotation issue
MogDB: Migrate MySQL non-auto-increment column/auto-increment list and lose the primary key problem
MogDB: Generate Package statement and leave out the initialization part
MogDB: Add keyword COMPLETION
MogDB: The query sequence encountered an empty problem
MogDB: Replace 0x00 with abnormal position problem
MySQL: Migrate MogDB timestamp with time zone problem
MySQL: Missing primary key syntax when creating table
Oracle: Migrate MogDB timestamp without time zone data time zone problem
Oracle: Migrate sequence is a negative number problem
PostgreSQL: Query partition sorting problem
PostgreSQL: Query list/range partition default partition problem
PostgreSQL: Migrate SQLServer to PostgreSQL column default value issue
PostgreSQL: Query index sorting method null value problem
PostgreSQL: Migrate Gist index issue
PostgreSQL: Problem with migrating array columns
MogDB: Migrate of PostgreSQL/MogDB/openGauss columns will no longer be overwritten by default
SQLServer: Supports sysname/SmallDateTime column type

Features

MTKD: Supports mvd local_md5 parameter
MTKD: Supports customFilter parameter
PostgreSQL: Supports displaying materialized view SQL
PostgreSQL: Supports index include column
SqlServer: Supports custom type migration

v2.9.6

2024-01-03

MTK

MTKD

Bug Fixes

MogDB: Rewrite Oracle trunc(date) problem
MogDB: In some scenarios, DB2 indexes and constraints are migrated without renaming.
MogDB: Migrate varchar data does not replace 0x00 with an empty string
MogDB: Migrate MySQL bit(1) to bool type
MySQL: Migrate 8.0.27 invisible column constraint issue
PostgreSQL: Parse column type varchar2(10)/number(10) issue
openGauss: The database compatibility type is lowercase.

Features

MVD: Adapt to some new features of MVD
MogDB: Migrate MySQL collate to MogDB Dolphin collate
MogDB: Add some Dolphin keywords
MogDB: supports MySQL index column execution length
MogDB: supports MySQL auto-increment column to MogDB Dolphin auto-increment column

v2.9.5

2023-11-01

MTK

MTKD

Bug Fixes

DB2: query partition seqno issue
Informix: When the type is L, the column defaults null
MTKD: optimized code diff and fix array issue
MTKD: source.parameter columnNameData/columnTypeData issue
MTKD: The error message is too long and affects the SQL statement
MogDB: Query column default/extra issue
MogDB: Rewrite Oracle exp mod number issue
MogDB: create procedure not ignore already exists
MogDB: Rewrite sysdate@! to sysdate
MogDB: Rewrite update return into for more column issue
PLSQL: Rewrite insert into/* comment */ table alias select issue
openGauss: alter table set PARALLEL_WORKERS issue

Features

MTK: object table support partiotion name
MTKD: change mediumblob to longblob
MogDB: support db2 varchar for bit data
MogDB: support Oracle date list partition
MogDB: add parameter enableEncodeValid
MogDB: For the target is MogBD, it automatically converts its own data according to the column type of the target database.

v2.9.4

2023-09-18

MTK

MTKD

Bug Fixes

MTKD: Optimize interface SQL comparison
MogDB: Incorrect number of error records
MogDB: Column type timetz data problem
MogDB: Add parameter compatibleIlLegaLChars to support MogDB/openGaus Copy option COMPATIBLE_ILLEGAL_CHARS
MogDB: Rewrite comments /* xxx\n -- xx */ Problem
MySQL: MySQL List/List COLUMN partition problem
Oracle: tableSplitAuto nil causes program crash problem

Features

MTK: Command line reference Oracle expdp adds exclude option to exclude type
MTK: Add support database description

v2.9.3

2023-09-11

MTK

MTKD

Bug Fixes

DB2: query index column issue
DB2: Migrating to DB2 DECIMAL decimals lost
MTK: Add parameter enableAutoAddParenthesesForFunc
MTKD: Create project splitTabMethod parameter issue
MogDB: Failed to insert a record. There is no record of the number of failed rows.
MogDB: Semicolon is missing in the create type body statement
MogDB: Query MogDB function and stored procedure issue
MogDB: When rewriting Oracle type, object is not removed if function members exist
MogDB: generate function SQL / issue
MogDB: Rewrite decode syntax issue
MogDB: TID keyword issue in compatibility B mode
MogDB: Rewrite Type subtype keyword issue
MogDB: Rewrite Oracle PLSQL without considering the enableOgBlobClob issue
MogDB: There is no code problem when rewriting the Oracle package body
MogDB: Override MySQL function returns int(10)
PLSQL: Extraction of functions in Oracle packages

Features

DB2: Add authentication method for connection
MTK: Add disableSequence parameter
MTK: Add customColMap parameter
MVD: Add table structure comparison information
MogDB: Add MogDB 5.0 keyword definition
MogDB: If copy fails, add copy from file statement and write xxx_import.sql
MogDB: Remove and rewrite Oracle plsql xx.extend syntax rules
MogDB: Remove and rewrite select into to select into STRICT syntax rules
MySQL: Add query character_set_server parameter and set character_set_server as the character set
MySQL: supports migrating the auto-increment column of the specified table into a sequence

v2.9.2

2023-07-17

MTK

MTKD

Bug Fixes

MogDB: Migration trigger issues

Features

MogDB: Support MySQL double(6,2) unsigned zerofill

v2.9.1

2023-07-14

MTK

MTKD

Bug Fixes

DM: database query and column type LongVarchar issue
MTKD: The config was not updated after the task run finish
MTKD: Connect no close issue
MogDB: Rewrite Oracle type as object comment issue
MogDB: Rewrite Oracle function no bracket with comment and mod function.
MogDB: Rewrite MySQL function hang issue
MogDB: Rewrite function return before comment issue
MogDB: record error data file duplicate data issues
MogDB: Write SQL/CSV Escape issue
MogDB: when parameter replaceZeroDate is empty, it will not be overwritten
MogDB: openGauss 5.0 dolphin ext modifies the timestamp default with time zone
MogDB: Rewrite Oracle escape single quotes issue
MogDB: Rewrite Oracle package end; -- comment
MySQL: add Unsigned BigInt define
MySQL: dsn wait_timeout issue
MySQL: varchar(0) issue
MySQL: The number of failed rows is not recorded when a commit fails
MySQL: Mig MySQL to MySQL bit issue
Oracle: The number of constraints is greater than 10W query issue
Oracle: signal SIGSEGV: segmentation violation
Oracle: When dataOnly mode query virtual column issue
Oracle: Cons using index partial column
Oracle: col default with comment issue
PLSQL: Extract Oracle Unpair block comment issue
PLSQL: Rewrite declare comment pos issue
PostgreSQL: The select statement is not logged
openGauss: pg_get_userbyid(c.relowner) as tableowner null issue

Features

MTK: create table ignore create sequence exists issue
MTK: convert-plsql sql support parse create view
MTK: Add parameter enableConvEmptyStringToSpace
MogDB: support dolphin sql_mode no_zero_date for 5.0.0
MogDB: Rewrite Oracle rollback work to rollback
MogDB: When migrating to MogDB 5.0, the function parameter nocopy attribute is not removed
MogDB: Rewrite Function return with comment
MySQL: connect url add net_write_timeout/net_read_timeout
WEB: add Japanese Lanaguge

v2.9.0

2023-06-01

MTK

MTKD

Bug Fixes

MTKD: download error data file problem
MogDB: Rewrite the Oracle package End comment issue
MySQL: Foreign key constraints and unique key constraints have the same name issue
MySQL: bit column default b'0' issue
MySQL: MySQL Driver Read Timeout issue
MySQL: column default curdate()
PLSQL: rewrite Oracle new type syntax issue
PostgreSQL: query constraint index problem
PostgreSQL: column type Jsonb problem
openGauss: openGauss 5.0.0 charset keyword issue

Features

MTK: Add parameter largeSequence to control whether to enable Large Sequence feature. Default enabled
MTK: parameter tableOptions/indexOptions supports regular matching
MTK: add usql support
MTKD: Add graphical configuration database connection
MySQL: supports MySQL 8.0 check constraints
PLSQL: convert-plsql supports partial table creation statements
SQLServer: Support SqlServer 2016