[MySQL] DOUBLE UNSIGNED and FLOAT UNSIGNED datatypes are not supported

[shubham-yb]

If the schema has a table with a DOUBLE UNSIGNED or FLOAT UNSIGNED column, those are not converted by Voyager to YB relevant syntax and thus get errored out during import. These datatypes are deprecated as of MySQL 8.0.17

Workaround: Manually change the exported schema to the closest YB supported syntax.

Example:

MySQL source:

create table test(
                  id int, 
                  n double unsigned, 
                  f float unsigned
);

Exported Schema:

CREATE TABLE test (
        id bigint,
        n DOUBLE UNSIGNED,
        f FLOAT UNSIGNED
);

Suggested Changes:

Change to YB compatible syntax closest to the respective datatypes.

CREATE TABLE test (
        id bigint,
        n DOUBLE PRECISION CHECK (n >= 0),
        f REAL CHECK (f >= 0)
);