Bug #9525 Temporary tables are not truncating properly.
Submitted: 31 Mar 2005 14:29 Modified: 5 May 2005 3:34
Reporter: Rob Taft Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:4.1.10a-nt-max OS:Windows (XP Pro)
Assigned to: CPU Architecture:Any

[31 Mar 2005 14:29] Rob Taft 
Description:
I don't think temporary tables work properly in 4.1.  I have 4.1.10a.  Occasionally when truncating my temporary table, it doesn't perform the operation.

How to repeat:
I use a temporary table to fill with data, and manipulate it.  Once I am done manipulating it, I move it to a permenant table, then truncate the temporary table.  This is done in a single thread in the order specified.  One of the columns is a varchar that holds a timestamp to the nearest millisecond, and is unique.  When moving to the permenent table, a Duplicate Key error occurs.  The timestamp is used throughout the entire thread, and it is not possible to place that timestamp in the database more than once.  If this table is NOT temporary, no errors occur.
[4 Apr 2005 5:34] Heikki Tuuri 
Hi!

Use SHOW CREATE TABLE to determine if your temporary table is an InnoDB table or a MyISAM table.

Please provide a repeatable test case.

Regards,

Heikki
[5 Apr 2005 3:34] MySQL Verification Team 
Could you please provide a test case. I wasn't able for to repeat
the behavior reported.
[5 May 2005 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".