Help Center/
Database and Application Migration UGO/
User Guide/
Syntax Conversion/
Conversion Error Codes/
Error Codes Generated During Conversion from MySQL to GaussDB/
U0400053: GaussDB (M-compatible mode) does not support this data type in CAST or CONVERT
Updated on 2025-06-07 GMT+08:00
U0400053: GaussDB (M-compatible mode) does not support this data type in CAST or CONVERT
Description
GaussDB (M-compatible mode) does not support the YEAR, ARRAY, and REAL data types in the CAST or CONVERT system function.
Database Type and Version
- Source database type and version: MySQL 8.0
- Target database type and version: GaussDB (M-compatible mode)
Syntax Example
SELECT CAST(CUSTINFO -> '$.ZIPCODE' AS UNSIGNED ARRAY) FROM CUSTOMERS1;
Suggestion
No solution is available. You are advised to refactor application code.
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.
The system is busy. Please try again later.
For any further questions, feel free to contact us through the chatbot.
Chatbot