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
• Status: Closed
• Category: MySQL Server: MyISAM storage engine
• Severity: S3 (Non-critical)
• Version: 4.1.7
• OS: MacOS (OS X Server 10.3)
• Assigned to: Ramil Kalimullin
• CPU Architecture: Any

[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] MySQL Verification Team

I was able to reproduce it on Windows.

[26 Jan 2005 23:52] Paul DuBois

Mentioned in 4.1.10 change notes.