U0400029: GaussDB does not support a specified length of integers
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: GaussDB (B-compatible mode) of versions earlier than V2.0-8.0
Syntax Example
This error is reported because UGO does not convert integer length by default.
In MySQL, the display width of integers (also called field width) refers to the space occupied by displayed integers. This width does not affect the actual data storage mode but is mainly used for formatted output. The following example is not supported in GaussDB:
CREATE TABLE test (id INT(4));
Suggestion
Modify Support for TINYINT, Support for SIGNED INTEGER, and Support for Unsigned INTEGER.
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