Bug #36232 Online add column fails for temporary tables
Submitted: 21 Apr 2008 19:13 Modified: 22 May 2008 2:02
Reporter: Jim Starkey Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: DDL Severity:S2 (Serious)
Version:6.0 OS:Any
Assigned to: Assigned Account CPU Architecture:Any

[21 Apr 2008 19:13] Jim Starkey
Description:
The following sequence fails with the message "ERROR 1146 (42S02): Table 'foo.t' doesn't exist".

    use foo;
    create temporary table t (a int);
    alter table t add b int;

The code fails in "reopen_table" called from "mysql_fast_or_online_table" following call to "handler::alter_table_phase2" (Falcon "StorageInterface::alter_table_phase2").

How to repeat:
use foo;
create temporary table t (a int);
alter table t add b int;
[22 May 2008 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".