MySQL Bugs: #28205: MySQL Cluster not upgrade compatible w.r.t Online Add Column

Bug #28205	MySQL Cluster not upgrade compatible w.r.t Online Add Column
Submitted:	2 May 2007 16:46	Modified:	5 May 2007 6:30
Reporter:	Tomas Ulin	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Cluster: Cluster (NDB) storage engine	Severity:	S2 (Serious)
Version:	5.1	OS:	Any
Assigned to:	Tomas Ulin	CPU Architecture:	Any

Description:
MySQL Cluster 5.1 is supposed to be Upgrade Compatible with later versions.

Because of the way Online Add Column is implemented this is not the case.  Online upgrade to later version will not make online add column possible.

The user will have to take down the cluster, restart, and apply backup, to be able to access this feature.

How to repeat:
.

Suggested fix:
Make all ndb tables by default include the needed "varpart reference", such that columns can be added online after upgrade to later version.

pushed into 5.1.18, telco 6.1.7 and telco 6.2.1

Upgrade compatability with previous version w.r.t this, however only tables created with 5.1.18 (telco 6.1.7, telco 6.2.1) or later may utilize upcoming online add column.

Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html

Documented change in 5.1.18, 5.1.16-ndb-6.2.1, and 5.1.15-ndb-6.1.17 changelogs.

Documented recommended upgrade procedures in Upgrades/Downgrades section of 5.1 Manual Cluster chapter.