Bug #12055 NDB temp tables created by ALTER TABLE are usable
Submitted: 20 Jul 2005 15:57 Modified: 29 Jul 2005 20:17
Reporter: Max Mether
Status: Closed
Category:Server Severity:S3 (Non-critical)
Version:4.1,5.0 OS:Linux (Linux)
Assigned to: Tomas Ulin Target Version:

[20 Jul 2005 15: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 16: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 17:33] Tomas Ulin 
pushed fix into 4.1.14 (merged into 5.0.10)
[29 Jul 2005 20: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>