Bug #11002 create multiple index with the same name when importing multiple column

• Submitted: 31 May 2005 21:47
• Modified: 31 May 2005 22:29
• Reporter: Thierry Scalais
• Status: Can't repeat
• Category: MySQL Migration Toolkit
• Severity: S2 (Serious)
• Version: 1.0.6
• CPU Architecture: Any

[31 May 2005 21:47] Thierry Scalais

Description:
When migrating an MSAccess database 
Consider a table with a multiple columns index. For example an index named 'myindex' on columns c1 and c2.

The migration toolkit generates something like 
CREATE TABLE ...
..
INDEX `myindex` (`C1`)
INDEX `myindex` (`C2`)
...

instead of 

CREATE TABLE ...
..
INDEX `myindex` (`C1`,`C2`)
...

How to repeat:
Create a multiple column index in a MSAccess DB
Migrate the database
The table in not created in the mysql DB due to errors in the SQL command

[31 May 2005 22:29] MySQL Verification Team

I tested against version 1.0.7 and it worked fine. Below the tool's
report and the show create table using the mysql client:

--------------------------------------------------------------------------------
-- MySQL Migration Toolkit Report                                             --
--                                                                            --
-- Title:   Summary Of The Migration Process                                  --
-- Date:    2005-05-31 19:24                                                  --
--------------------------------------------------------------------------------

1. Schema Migration
-------------------

  Number of migrated schemata: 1

  Schema Name:            bug1102
    Tables:               1
    Views:                0
    Procedures:           0
    Triggers:             0
    Structured Types:     0

  Details:

    Tables
      `bug1102`.`accesstbl`
    Views
    Procedures
    Triggers
    Structured Types

2. Data Bulk Transfer
---------------------

  Completed.

--------------------------------------------------------------------------------

mysql> show create table accesstbl\G
*************************** 1. row ***************************
       Table: accesstbl
Create Table: CREATE TABLE `accesstbl` (
  `col1` varchar(50) default NULL,
  `col2` varchar(50) default NULL,
  `col3` varchar(50) default NULL,
  KEY `myindex` (`col1`,`col2`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
1 row in set (0.00 sec)

mysql>

[6 Jul 2005 21:12] Thierry Scalais

Effectively closed with version 1.0.9