Bug #7261 Alter table loses temp table with lower_case_table_names=2
Submitted: 14 Dec 2004 12:03 Modified: 26 Jan 2005 23:52
Reporter: Scott Wilson Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: MyISAM storage engine Severity:S3 (Non-critical)
Version:4.1.7 OS:Mac OS X (OS X Server 10.3)
Assigned to: Ramil Kalimullin

[14 Dec 2004 12:03] Scott Wilson
Description:
Alter table on a mixed case table name with lower_case_table_names=2 causes the table to 
disappear.  Verified that problem is not present for non-temp tables and for 
lower_case_table_names=1.

How to repeat:
use test;
create temporary table caseTest ( `ID` int(11), `TXT` varchar(8) );
insert into caseTest values (1,'abc');
insert into caseTest values (2,'def');
select * from caseTest;
alter table caseTest add index (ID);
select * from caseTest;

(  s/caseTest/casetest/g  and it works fine)
[14 Dec 2004 12:30] Victoria Reznichenko
I was able to reproduce it on Windows.
[26 Jan 2005 23:52] Paul Dubois
Mentioned in 4.1.10 change notes.