Bug #33650 mysql_alter_table() unnecessarily does full table copy
Submitted: 3 Jan 2008 13:38 Modified: 4 Jan 2008 17:23
Reporter: Marko Mäkelä
Status: Verified
Category:Server: DDL Severity:S5 (Performance)
Version:5.1.23-bk OS:Any
Assigned to: Davi Arnaut Target Version:
Triage: Triaged: D3 (Medium) / R3 (Medium) / E3 (Medium)

File: Maximum allowed size is 500KB.
Description:
Privacy:

If the data you need to attach is more than 500KB, you should create a compressed archive of the data and a README file that describes the data with a filename that includes the bug number (example: bug-data-33650.zip), and use FTP to upload the archive to ftp://ftp.mysql.com/pub/mysql/upload/. Once you have uploaded the file, add a comment to this bug to notify us about it. Note: This directory is unlistable, which means that once you have uploaded your file, you will not be able to see it.

All entries become the exclusive editorial property of Sun Microsystems, Inc.

[25 Feb 2008 11:36] Vasil Dimov 
Patch that fixes this bug by calling create_length_to_internal_length() just before the
is_equal() check

Attachment: bug33650.diff (application/octet-stream, text), 420 bytes.