U0400027: GaussDB does not support unsigned 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 unsigned integers by default.
In MySQL, the UNSIGNED keyword is optional and used to specify a signed column of the INTEGER data type. Only GaussDB (M-compatible mode) and (B-compatible mode) 8.0 and later support UNSIGNED. The following example is not supported in other versions:
CREATE TABLE test_table ( id INT NOT NULL PRIMARY KEY, number TINYINT UNSIGNED );
Suggestion
Modify Support for TINYINT 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