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

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.