Help Center/ Database and Application Migration UGO/ User Guide/ Syntax Conversion/ Conversion Error Codes/ Error Codes Generated During Conversion from MariaDB to GaussDB/ U1100002: GaussDB (A-compatible mode) does not support BIGINT UNSIGNED
Updated on 2025-10-22 GMT+08:00
View PDF
Share

U1100002: GaussDB (A-compatible mode) does not support BIGINT UNSIGNED

Description

Database Type and Version

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

Syntax Example

The value of the BIGINT UNSIGNED data type in MariaDB ranges from 0 to 18446744073709551615.

GaussDB (A-compatible mode) does not support unsigned numeric types. The value of BIGINT ranges from –9,223,372,036,854,775,808 to +9,223,372,036,854,775,807 and is smaller than that of BIGINT UNSIGNED in MariaDB.

MariaDB syntax: 
CREATE TABLE test_bigint_unsigned (
    C1 BIGINT UNSIGNED
);

Suggestion

Determine whether workloads are affected.