Bug #32829 Crash during conversion of InnoDB table to Falcon (case-insensitivity)
Submitted: 28 Nov 2007 22:50 Modified: 3 Dec 2007 14:24
Reporter: Jeffrey Pugh Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Falcon storage engine Severity:S2 (Serious)
Version:6.0.3 OS:Linux
Assigned to: Kevin Lewis CPU Architecture:Any

[28 Nov 2007 22:50] Jeffrey Pugh
Description:
(Split out from 22166 because of behavior)
Crash during conversion of InnoDB table to Falcon (case-insensitivity)

How to repeat:
mysql> create table t (s1 int) engine=falcon;
Query OK, 0 rows affected (0.03 sec)

mysql> create table T (s1 int) engine=innodb;
Query OK, 0 rows affected (0.00 sec)

mysql> alter table T engine=falcon;
ERROR 1025 (HY000): Error on rename of './d7/#sql-4f7c_1' to './d7/T' (errno: -2)
mysql> alter table t engine=innodb;
ERROR 2013 (HY000): Lost connection to MySQL server during query
[29 Nov 2007 0:45] Miguel Solorzano
Thank you for the bug report.

create table t (s1 int) engine=falcon;
create table T (s1 int) engine=innodb;
alter table T engine=falcon;
alter table t engine=innodb;

[miguel@skybr 6.0]$ bin/mysql -uroot test
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 6.0.4-alpha-debug Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create table t (s1 int) engine=falcon;
Query OK, 0 rows affected (0.75 sec)

mysql> create table T (s1 int) engine=innodb;
Query OK, 0 rows affected (0.00 sec)

mysql> alter table T engine=falcon;
ERROR 1025 (HY000): Error on rename of './test/#sql-986_1' to './test/T' (errno: -2)
mysql> alter table t engine=innodb;
ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql>
[29 Nov 2007 15:05] Jim Starkey
Works fine on current code base.
[29 Nov 2007 19:20] Jeffrey Pugh
Reverified with latest 6.0-bk, and no longer crashes. Instead get:
ERROR 1025 (HY000): Error on rename of './test/#sql-4d25_2' to './test/t' (errno: 121)

for whichever alter you try to do that would clash with Falcon name. Closing.
[30 Nov 2007 4:49] Kevin Lewis
This bug really did exist in the mysql-6.0 tree.  It has been fixed in mysql-6.0-falcon.  So let's mark this patch pending and let it go through the normal bug life cycle
[3 Dec 2007 14:24] MC Brown
A note has been added to the 6.0.4 changelog: 

Converting a table from InnoDB to Falcon, where the Falcon table with the same name (but different case) would cause a server crash.