Bug #79962 mysqldump wrap index comments in /*!50503 */ version comments.

• Submitted: 13 Jan 2016 19:29
• Modified: 14 Jan 2016 19:03
• Reporter: Michael Sole
• Status: Verified
• Category: MySQL Server: mysqldump Command-line Client
• Severity: S3 (Non-critical)
• Version: 5.5,5.1
• OS: Any
• CPU Architecture: Any
• Tags: mysqldump

[13 Jan 2016 19:29] Michael Sole

Description:
If dumping a db with a table with comments on indexes it throws a syntax error when importing into an earlier version of MySQL

How to repeat:
Create a table in a version of mysql that supports comments on indexes, add an index and a comment. (I used 5.5)

Dump the db

Import into an earlier version of mysql that does not support this (I used 5.1)

Suggested fix:
mysqldump wrap index comments in /*!50503 */ version comments.

[14 Jan 2016 6:18] MySQL Verification Team

Hello Michael Sole,

Thank you for the report.

Thanks,
Umesh

[14 Jan 2016 19:03] Michael Sole

You're welcome. Is this a bug you think will be fixed?