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

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.