MySQL INSTANT DDL breaks EXCHANGE PARTITION
Kedar
MySQL ERROR 1731 ‘Non matching attribute INSTANT COLUMN(s)’ breaks EXCHANGE PARTITION after ALGORITHM=INSTANT. This blog offers reasoning and fixtures.
Browsing Tag
ER_PARTITION_EXCHANGE_DIFFERENT_OPTION
1 post
2 responses to “MySQL INSTANT DDL breaks EXCHANGE PARTITION”
I had a blog post in draft on the same subject, so I am glad you published this, as I do not know when I would have gotten around to finishing mine.
You might not have seen the verified documentation bug that I opened on this issue: https://bugs.mysql.com/bug.php?id=120016.
I should have mentioned the documentation bug in Bug #104970 when I originally opened it. I have now updated the bug report to include that reference.
Also note that in the verified Bug #95484 (https://bugs.mysql.com/bug.php?id=95484), I show that it is possible to have different partition formats within the same partitioned table, so I think that, with a little work, EXCHANGE PARTITION could be made to work for tables affected by INSTANT DDL.
Thank for sharing additional information JFG, as always. Those bug reports are good read.
About the bug https://bugs.mysql.com/bug.php?id=95484 for ROW_FORMAT and EXCHANGE PARTITION, AFAIK it failed even after having same row-format is because the logic checks “atleast 1 partition with diff”.
Regards,
Kedar