Updated on 2025-06-07 GMT+08:00

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.