Help Center/
Database and Application Migration UGO/
User Guide/
Syntax Conversion/
Conversion Error Codes/
Error Codes Generated During Conversion from MySQL to GaussDB
Updated on 2025-06-07 GMT+08:00
Error Codes Generated During Conversion from MySQL to GaussDB
In the following sections mentioning GaussDB (MySQL-compatible mode), if neither centralized nor distributed is specified, the B-compatible mode includes GaussDB Centralized (B-compatible mode) and GaussDB Distributed (MySQL-compatible mode).
- U0400001: The GaussDB table attribute does not support this character set
- U0400002: The GaussDB table attribute does not support this collation
- U0400003: The GaussDB column definition does not support ON UPDATE
- U0400004: The GaussDB view does not support SECURITY
- U0400005: GaussDB does not support a specified definer during object creation
- U0400006: GaussDB does not support SELECT in a stored procedure
- U0400007: EXECUTE cannot be used to execute a dynamic SELECT statement in a GaussDB stored procedure
- U0400008: GaussDB schema name cannot be specified when ALTER TABLE is used to rename a table
- U0400009: GaussDB does not support the xxx system privilege
- U0400010: GaussDB Distributed does not support AUTO_INCREMENT
- U0400011: GaussDB auto_increment column must be the first field of a primary key constraint or unique constraint
- U0400012: GaussDB temporary tables do not support AUTO INCREMENT
- U0400013: GaussDB HASH partition keys cannot be specified in multiple columns
- U0400014: GaussDB does not support the same partition key of child and parent partitions
- U0400017:GaussDB stored procedures do not support CONTINUE HANDLER
- U0400019: Multiple GaussDB tables cannot be updated or deleted
- U0400020: GaussDB does not support INSERT ON DUPLICATE KEY UPDATE for primary or unique keys
- U0400021: GaussDB does not support INSERT ON DUPLICATE KEY UPDATE for tables with GSIs
- U0400022: Some GaussDB time functions do not support input parameters of the TIME or TIMETZ data type
- U0400023: GaussDB does not support BINARY
- U0400024: GaussDB does not support the ENUM data type
- U0400025: GaussDB does not support the SET data type
- U0400026: GaussDB does not support signed integers
- U0400027: GaussDB does not support unsigned integers
- U0400028: GaussDB does not support ZEROFILL integers
- U0400029: GaussDB does not support a specified length of integers
- U0400030: GaussDB does not support the LONGTEXT data type
- U0400031: GaussDB does not support the LONGBLOB data type
- U0400032: GaussDB partially supports the CONVERT function
- U0400033: GaussDB does not support the system function
- U0400035: GaussDB (M-compatible mode) does not support default value 0000-00-00 00:00:00 for TIMESTAMP data type
- U0400036: GaussDB (M-compatible mode) does not support the JSON data type
- U0400037: GaussDB does not support non-aggregation columns that are not in the GROUP BY clause in SELECT by default
- U0400038: GaussDB does not support the SHOW command
- U0400039: The default value definition for STRING data types in GaussDB (M-compatible mode) does not support "\0"(0x00)
- U0400040: GaussDB (M-compatible mode) does not support the TABLE command
- U0400041: GaussDB does not support ALTER DATABASE READ ONLY
- U0400042: GaussDB (M-compatible mode) does not support ALTER TABLE CHECK CONSTRAINT ENFORCED
- U0400043: GaussDB does not support ALTER INDEX VISIBLE
- U0400044: GaussDB (M-compatible mode) does not support WINDOW in SELECT
- U0400045: GaussDB (M-compatible mode) does not support stored procedures
- U0400046: GaussDB (M-compatible mode) does not support storage functions
- U0400047: GaussDB (M-compatible mode) does not support triggers
- U0400048: GaussDB (M-compatible mode) does not support SELECT FOR UPDATE, SELECT FOR SHARE, and LOCK IN SHARE MODE along with UNION, INTERSECT, and EXCEPT
- U0400049: GaussDB (M-compatible mode) does not support SELECT FOR UPDATE, SELECT FOR SHARE, and LOCK IN SHARE MODE along with DISTINCT
- U0400050: GaussDB (M-compatible mode) does not support SELECT FOR UPDATE, SELECT FOR SHARE, and LOCK IN SHARE MODE along with GROUP BY and HAVING
- U0400051: GaussDB (M-compatible mode) does not support SELECT FOR UPDATE, SELECT FOR SHARE, and LOCK IN SHARE MODE along with aggregate and window functions
- U0400052: The reserved keyword is used as an identifier
- U0400053: GaussDB (M-compatible mode) does not support this data type in CAST or CONVERT
- U0400054: GaussDB does not support invisible columns
- U0400055: GaussDB (M-compatible mode) does not support introducers of character set literals
- U0400056: The table name is missing before FROM in DELETE
Parent topic: Conversion Error Codes
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
