MySQL Bugs: #6333: Data Transferred from MyISAM table to InnoDB table is Corrupt

Bug #6333	Data Transferred from MyISAM table to InnoDB table is Corrupt
Submitted:	29 Oct 2004 22:20	Modified:	13 Nov 2004 15:06
Reporter:	Miguel Solorzano	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: InnoDB storage engine	Severity:	S1 (Critical)
Version:	4.1.7	OS:	Windows (Windows/Linux)
Assigned to:	Sergei Golubchik	CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Transferring data from a MyISAM table to an identically defined InnoDB using

INSERT into <InnoDB_table> SELECT * from <MyIsamTable>
results in different values for 2 columns in some of the inserted rows.

How to repeat:
Run test case attached to the issue.

Suggested fix:
--

Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Additional info:

check column order in those "identical" tables
:)