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