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.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot