Help Center/ Database and Application Migration UGO/ User Guide/ Syntax Conversion/ Conversion Error Codes/ Error Codes Generated During Conversion from MariaDB to GaussDB/ U1100001: GaussDB does not support ZEROFILL for numeric types
Updated on 2025-10-22 GMT+08:00
View PDF
Share

U1100001: GaussDB does not support ZEROFILL for numeric types

Description

Database Type and Version

  • Source database type and version: all MariaDB versions
  • Target database type and version: all GaussDB versions

Syntax Example

If ZEROFILL is specified for a numeric type in MariaDB, the value format will change. When the number of digits in the numeric value is less than the length defined by a column, 0 will be padded from the left, and the UNSIGNED attribute is automatically added to the column. The storage of the numeric value is not affected.

GaussDB does not support the ZEROFILL keyword.

MariaDB syntax: 
CREATE TABLE test_zerofill_keyword(
    C1 TINYINT ZEROFILL,
    C2 SMALLINT ZEROFILL,
    C3 MEDIUMINT ZEROFILL,
    C4 INT ZEROFILL,
    C5 INTEGER ZEROFILL,
    C6 BIGINT ZEROFILL,
    C7 DECIMAL(2,1) ZEROFILL,
    C8 FLOAT ZEROFILL,
    C9 DOUBLE PRECISION ZEROFILL
);

Suggestion

Modify Support for ZEROFILL Keyword in Numeric Data Types.