Bug #72280 Crash adding FULLTEXT KEY to InnoDB table where DB name starts with a number
Submitted: 8 Apr 2014 23:30 Modified: 9 Apr 2014 5:19
Reporter: David Tibbs Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: FULLTEXT search Severity:S2 (Serious)
Version:5.6.13 OS:Other (Amazon RDS (Linux))
Assigned to: CPU Architecture:Any
Tags: fts, fulltext

[8 Apr 2014 23:30] David Tibbs
Description:
When trying to create a FULLTEXT index on an InnoDB table where the database name starts with a number, mysqld crashes.

This is on Amazon RDS, so I have limited access to filesystem and logs etc but it appears from the fact that MySQL fully crashes that this is a MySQL bug and not an issue with Amazon RDS.  If this is not the case please accept my apologies.

I am able to add a FULLTEXT index on an InnoDB in the following ways with a database name that doesn't start with a number (e.g. "testdave"):

1)  Loading in an existing MyISAM table from a mysqldump with a FULLTEXT index and ALTERing the engine to be InnoDB
2)  Loading in an existing InnoDB table from a mysqldump (edited the dump to change the engine from MyISAM to InnoDB) without a FULLTEXT index and adding the index once the table has created with an ALTER
3)  Loading in an existing InnoDB table from a mysqldump (edited the dump to change the engine from MyISAM to InnoDB) with a FULLTEXT index.

However, all the above methods fail if the database name starts with a number (e.g. 123test) - I get an error "ERROR 2013 (HY000) at line 2851: Lost connection to MySQL server during query" in the MySQL client as the mysql process crashes.  I will attach error logs.

How to repeat:
Add a FULLTEXT index to an InnoDB table on a database that starts with a letter, should complete fine.  However, if the database name starts with a number, mysqld crashes.
[8 Apr 2014 23:30] David Tibbs
Error log when mysqld crashes

Attachment: mysql-error-log (application/octet-stream, text), 6.75 KiB.

[8 Apr 2014 23:33] David Tibbs
Here's the ALTER that was causing mysqld to crash:

ALTER TABLE customers ADD FULLTEXT KEY `Andy_080828_Fulltext` (`customers_ft`);
[9 Apr 2014 5:19] MySQL Verification Team
Hello David,

Thank you for the bug report.
Duplicate of Bug #69741

Noted in 5.6.14, 5.7.2 change logs - http://dev.mysql.com/doc/relnotes/mysql/5.6/en/news-5-6-14.html

InnoDB full-text searches failed in databases whose names began with
a digit

Please try latest GA version and report us back if you are still having this issue.

Thanks,
Umesh