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

U0400028: GaussDB does not support ZEROFILL 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) V2.0-8.0 and GaussDB (M-compatible mode) V2.0-8.100

Syntax Example

This error is reported because UGO does not convert ZEROFILL integers by default.

ZEROFILL is a MySQL attribute that pads the displayed value of numeric columns with zeros. It is mainly used for columns of the INTEGER data type and is usually used with UNSIGNED because negative numbers are not filled with zeros. The following example is not supported in GaussDB:

CREATE TABLE test_table (
    id INT NOT NULL PRIMARY KEY,
    number TINYINT UNSIGNED ZEROFILL
);

Suggestion

Modify Support for ZEROFILL Keyword. It controls the ZEROFILL keyword in the TINYINT, SMALLINT, MEDIUMINT, INTEGER, and BIGINT data types. For other data types, modify Support for UNSIGNED Float And Decimal and Support for FLOAT.

During migration to GaussDB (B-compatible mode) of versions earlier than V2.0-8.0, ZEROFILL is not controlled by a separate configuration item. The related conversion configuration items include Support for TINYINT, Support for UNSIGNED INTEGER, Support for FLOAT, and Support for DOUBLE.