Bug #42763 Indexe won't be migrated

• Submitted: 11 Feb 2009 13:58
• Modified: 6 Feb 2013 23:07
• Reporter: Susanne Ebrecht
• Status: Can't repeat
• Category: MySQL Workbench
• Severity: S2 (Serious)
• Version: 1.1.17
• OS: Any
• CPU Architecture: Any
• Triage: Triaged: D5 (Feature request) / R3 (Medium) / E3 (Medium)

[11 Feb 2009 13:58] 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);

CREATE INDEX i_n ON t(n);

Now use migration tool for migration to MySQL

SHOW CREATE TABLE t;

You will see that only the primary key got migrated not the other index.

How to repeat:
See above

Suggested fix:
Migrate all indexes as well

[2 Apr 2009 7:43] Valeriy Kravchuk

Latest MT migrates table defined as:

SQL> create table t(i number, n number);

Table created.

SQL> alter table t add primary key(i);

Table altered.

SQL> create index i_n on t(n);

Index created.

in Oracle into MySQL equivalent:

DROP TABLE IF EXISTS `system`.`t`;
CREATE TABLE `system`.`t` (
  `i` DECIMAL(22, 0) NOT NULL,
  `n` DECIMAL(22, 0) NULL,
  PRIMARY KEY (`i`),
  INDEX `i_n` (`n`)
)
ENGINE = INNODB;

So, the bug is PostgreSQL-related.

[2 Apr 2009 9:59] Susanne Ebrecht

Many thanks Valeriy.

Your test means that this is only common JDBC related.

Set back to verified.

[6 Feb 2013 23:07] Alfredo Kojima

No longer applies in WB