Editing the Configurations During Migration from MySQL to GaussDB

Symptom	Feature Name	Recommended Setting
GaussDB does not support CHARSET in CREATE TABLE statements.	CHARSET	Comment CHARSET.
GaussDB does not support COLLATE in CREATE TABLE statements.	COLLATE	Comment COLLATE.
GaussDB does not support SECURITY clauses in views.	SECURITY clauses	Migrate SECURITY clauses.
GaussDB does not support CHECK OPTION clauses in views.	CHECK OPTION clauses	Migrate CHECK OPTION clauses.
In GaussDB, there are multiple types of integer variables.	INTEGER data type	Convert the data type to NUMERIC.
GaussDB does not support LONGTEXT data type in CREATE TABLE statements.	LONGTEXT data type	Convert LONGTEXT to TEXT. The script will be migrated and a warning message will be displayed.
GaussDB does not support LONGBLOB data type in CREATE TABLE statements.	LONGBLOB data type	Convert LONGBLOB to TEXT. The script will be migrated and a warning message will be displayed.
GaussDB does not support REAL data type in CREATE TABLE statements.	REAL data type	Convert REAL to DOUBLE PRECISION.
GaussDB does not support ON UPDATE in columns of tables.	ON UPDATE	Comment ON UPDATE.
The distributed GaussDB does not support generated columns.	Generated columns NOTE: This feature is available only in distributed GaussDB.	Comment generated columns.
In GaussDB, multiple columns cannot be used as the partition key in a table.	Multi-column partition keys of partitioned tables	Use the first column of the primary key or unique key as the partition key.
In GaussDB, partition keys cannot be same as sub-partition keys.	Same partition keys and sub-partition keys	Comment SUB partitions.
GaussDB temporary tables do not support AUTO INCREMENT.	AUTO INCREMENT in temporary tables	Comment AUTO INCREMENT.
Distributed GaussDB does not support FOREIGN KEY constraints.	FOREIGN KEY constraints NOTE: This feature is available only in distributed GaussDB.	Comment FOREIGN KEY constraints.
The character set length of GaussDB is different from that of MySQL.	Character set length conversion	Comment or extend character datatype length.
In distributed GaussDB, distribution keys are part of the constraints.	Unique constraints and indexes in a distributed environment NOTE: This feature is available only in distributed GaussDB.	If no distribution key exists in a unique constraint and unique index, add a distribution key.
GaussDB does not support DEFINER in database objects.	Definer	If a user is specified when an object is created, convert it to ALTER OWNER.
GaussDB ignores SQL parsing.	Parsing converted SQL statements	Ignore parsing.
In GaussDB, Ustore tables do not support B-tree indexes.	B-tree index conversion NOTE: This feature is available only in centralized GaussDB.	If enable_default_ustore_table of the target database version is set to OFF, generate common tables during table creation and support B-tree indexes.