Bug #7261 Alter table loses temp table with lower_case_table_names=2

• Submitted: 14 Dec 2004 13:03
• Modified: 27 Jan 2005 0:52
• Reporter: Scott Wilson
• Status: Closed
• Category: Server: MyISAM
• Severity: S3 (Non-critical)
• Version: 4.1.7
• OS: Mac OS X (OS X Server 10.3)
• Assigned to: Ramil Kalimullin

[14 Dec 2004 13: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 13:30] Victoria Reznichenko

I was able to reproduce it on Windows.

[27 Jan 2005 0:52] Paul DuBois

Mentioned in 4.1.10 change notes.