Bug #74795 Field name not included in warning when converting to fixed

• Submitted: 11 Nov 2014 15:03
• Modified: 13 Nov 2014 14:50
• Reporter: Magnus Blåudd
• Status: Closed
• Category: MySQL Cluster: Cluster (NDB) storage engine
• Severity: S3 (Non-critical)
• Version: 7.1.34
• OS: Any
• CPU Architecture: Any

[11 Nov 2014 15:03] Magnus Blåudd

Description:
The SQL warning printed when ha_ndbcluster detect that "If the user has not specified the field format make it dynamic to enable on-line add attribute" conversion has been performed does not contain the name of the filed which was auto converted.

How to repeat:
This was detected by compiler warning when push_warning_printf() got a "format check attribute".

Suggested fix:
Include the field name in the warning.

Update .result files, the difference looks like:

-Warning	1478	Converted FIXED field to DYNAMIC to enable on-line ADD COLUMN
+Warning	1478	Converted FIXED field c to DYNAMIC to enable on-line ADD COLUMN

[13 Nov 2014 14:50] Jon Stephens

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.

Documented fix as follows in the NDB 7.4.3 changelog:

    The warning shown when an ALTER TABLE ALGORITHM=INPLACE [table]
    ADD COLUMN [column] statement automatically changes a column's
    COLUMN_FORMAT from FIXED to DYNAMIC now includes the name of the
    column whose format was changed.

Closed.

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