Migration snapshot tool creates duplicated index code for UNIQUE indexes

Goal : create a migration from an existing database (MySQL)

• Database where migration is being created from : mysqlnd 5.0.12-dev - 20150407 using phpMyAdmin. PHP version: 7.1.9

Indexes looks like this in phpMyAdmin's table view :

Notice how the index user_id is Unique

When following the Official CakePHP's migrations cookbook, doing the command bin/cake bake migration_snapshot Initial works correctly, but then I had problems creating an SQLite database as the error General error 1 : user_id_index already exists in [...] (it was similar to this, I'm writing this from memory) and I banged my head on why was that.

I took a look at the code generated by the snapshot command and I saw this :

// [...]
->addIndex(
    [
        'user_id',
    ],
    ['unique' => true]
)
->addIndex(
    [
        'user_id',
    ]
)
// [...]

Removing the second ->addIndex() solves the problem when creating the SQLite database using the migration(s).

To recap

• Trying to go from MySQL to SQLite using migrations
• Command bin/cake bake migration_snapshot Initial generates files without errors
• then trying the command bin/cake migrations migrate create the SQLite database with errors :
  • General error 1 : user_id_index already exists in [...] in command line
  • only one table exists in SQLite database : phinxlog, which has no rows.
• Removing duplicated code fixes the problem.

I feel like that duplicated code shouldn't have been generated and I'd consider that a bug.

I haven't done much testing, so I dunno about reproductability.

Riproduci il problema eseguendo bin/cake bake migration_snapshot Initial sul database MySQL descritto, quindi applica la migration generata a SQLite con bin/cake migrations migrate. Ispeziona le chiamate a addIndex() nella migration generata per verificare l’indice UNIQUE user_id; il lavoro è completato quando il codice dell’indice duplicato è assente e la migration SQLite termina senza l’errore user_id_index already exists.