Bug #42762 Migrate INTEGER to wrong data types

• Submitted: 11 Feb 2009 13:54
• Modified: 19 Jun 2018 7:11
• Reporter: Susanne Ebrecht
• Status: Won't fix
• Category: MySQL Workbench
• Severity: S1 (Critical)
• OS: Any
• CPU Architecture: Any

[11 Feb 2009 13:54] Susanne Ebrecht

Description:
Setup a PostgreSQL table:

CREATE TABLE t(i integer, n integer);

Fill with some rows:

INSERT INTO t VALUES (generate_series(1,100), random()*100);

ALTER TABLE t ADD PRIMARY KEY(i);

Now use migration tool and generic JDBC to migrate this table to MySQL.

All works fine but the integers were migrated to TINYINT.

SHOW CREATE TABLE t;

You will see that both columns are tinyint here. 

How to repeat:
See above

Suggested fix:
Let INTEGER as INTEGER

[19 Jun 2018 7:11] Milosz Bodzek

Migration tool is not supported anymore, use MySQL Workbench migration wizard instead.