Updated on 2025-06-07 GMT+08:00

U0400024: GaussDB does not support the ENUM data type

Description

Database Type and Version

  • Source database type and version: MySQL 5.5, 5.6, 5.7, and 8.0
  • Target database type and version: all GaussDB versions

Syntax Example

This error is reported because UGO converts the ENUM data type by default.

GaussDB does not support the ENUM data type, for example:

CREATE TABLE enum_test (
    id int NOT NULL PRIMARY KEY,
enum_test enum ('Male', 'Female') DEFAULT NULL
);

Suggestion

Modify enum datatype conversion. You can convert the ENUM data type to VARCHAR and add a trigger to verify data. If no trigger is added, service data integrity must be guaranteed. If a trigger is added, the performance may be affected and the database system may be difficult to maintain. Therefore, you need to fully evaluate the impact on services.