Bug #21852 INSERT statement causing table corruption on v5 but not on v4
Submitted: 27 Aug 2006 14:36 Modified: 23 Jun 2008 11:54
Reporter: Frederic Steinfels Email Updates:
Status: Can't repeat Impact on me:
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.22 OS:Any (*)
Assigned to: CPU Architecture:Any

[27 Aug 2006 14:36] Frederic Steinfels
The title says it all. Due to license agreement and copyright, I can not post either the SQL statement nor the table data but I will give that information to the developer taking care of this case.

How to repeat:
uncompress the three tables from the archive
run the statement

mysql 4 will run through ok.
mysql 5 will report
060827  9:41:12 [ERROR] /usr/libexec/mysqld: Incorrect key file for table '/tmp/#sql_2ca0_0.MYI'; try to repair it
in mysqld.log
and mysql client says: ERROR 1105 (HY000): Unknown error
[28 Aug 2006 14:52] Sveta Smirnova
Thank you for th report.

Could you please try using current 5.0.24 version?
[28 Sep 2006 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[23 Jun 2008 10:33] Frederic Steinfels
sorry for not coming back on this. this must have been fixed indeed.
[23 Jun 2008 11:54] Sveta Smirnova
Thank you for the feedback.

Closed as "Can't repeat" because last comment.