MySQL INSTANT DDL breaks EXCHANGE PARTITION

Using ALGORITHM=INSTANT in MySQL can lead to ERROR 1731, “Non matching attribute INSTANT COLUMN(s),” when running EXCHANGE PARTITION. The technical account provides reasoning and fixtures for reproducing the issue.

1 source Published Updated

Coverage 1 publisher

  1. Planet MySQL

    MySQL INSTANT DDL breaks EXCHANGE PARTITION

Articles stay on their publishers’ sites; each link opens the original.