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

U1100005: GaussDB (A-compatible mode) does not support DOUBLE and DOUBLE(p,s)

Description

Database Type and Version

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

Syntax Example

In MariaDB, NUMBER without precision and scale is equivalent to DOUBLE. DOUBLE PRECISION[(M,D)], DOUBLE[(M,D)], and REAL[(M,D)] are equivalent.

GaussDB (A-compatible mode) does not support DOUBLE(p,s) where both precision and scale are specified, nor does it support DOUBLE.

MariaDB syntax: 
CREATE TABLE test_double(
    C1 DOUBLE,
    C2 DOUBLE(2,1),
    C3 DOUBLE PRECISION,
    C4 DOUBLE PRECISION(2,1),
    C5 REAL,
    C6 REAL(2,1),
    C7 NUMBER
);

Suggestion

Modify Support for DOUBLE and NUMBER (without precision and scale).