Help Center/ Database and Application Migration UGO/ User Guide/ Syntax Conversion/ Conversion Error Codes/ Error Codes Generated During Conversion from MariaDB to GaussDB/ U1100003: SERIAL in GaussDB and SERIAL in MariaDB are not equivalent
Updated on 2025-10-22 GMT+08:00
View PDF
Share

U1100003: SERIAL in GaussDB and SERIAL in MariaDB are not equivalent

Description

Database Type and Version

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

Syntax Example

SERIAL in MariaDB is equivalent to BIGINT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE and holds 8-byte values.

In GaussDB, SERIAL is signed and holds 4-byte values, BIGSERIAL is signed and holds 8-byte values, and LARGESERIAL is signed and holds 16-byte values by default.

MariaDB syntax: 
CREATE TABLE test_serial(
    C1 SERIAL,
    C2 VARCHAR(10)
);

Suggestion

Modify Support for SERIAL.