Bug #12055 NDB temp tables created by ALTER TABLE are usable
Submitted: 20 Jul 2005 13:57 Modified: 29 Jul 2005 18:17
Reporter: Max Mether Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.1,5.0 OS:Linux (Linux)
Assigned to: Tomas Ulin CPU Architecture:Any

[20 Jul 2005 13:57] Max Mether 
Description:
The temporary tables created by an ALTER TABLE on a cluster table are visible from all MySQL servers. Futhermore the temporary tables are usable, you can do selects, inserts and even ALTER TABLES on them. 

Running an ALTER TABLE on a temporary table created by an ALTER TABLE can actually crash the whole cluster. 

How to repeat:
1. Run ALTER TABLE on a big table with a MySQL client
2. Log in with another mysql client session and do SHOW TABLES
3. Run ALTER TABLE ...RENAME on the temporary table (#sql_xxx)
[20 Jul 2005 14:44] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/27379
[20 Jul 2005 15:33] Tomas Ulin 
pushed fix into 4.1.14 (merged into 5.0.10)
[29 Jul 2005 18:17] Mike Hillyer 
Documented in 4.1.14 and 5.0.10 changelogs:

<listitem><para>The temporary tables created by an <literal>ALTER TABLE</literal> on a cluster table were visible
to all MySQL servers. (Bug #12055)</para></listitem>