MySQL Bugs: #39708: Falcon: non-descriptive error message when creating a big key

Bug #39708	Falcon: non-descriptive error message when creating a big key
Submitted:	28 Sep 2008 10:34	Modified:	13 Dec 2008 10:06
Reporter:	Philip Stoev	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Falcon storage engine	Severity:	S3 (Non-critical)
Version:	6.0-falcon-team	OS:	Any
Assigned to:	Sergey Vojtovich	CPU Architecture:	Any
Tags:	F_ERROR HANDLING

Description:
When Falcon is started with --falcon-page-size=2K, maximum key length is 540 bytes, which is not sufficient to index even reasonably-sized utf8 columns.

This is mentioned in the documentation, however the the error message returned to the client is not descriptive.

How to repeat:
$ perl mysql-test-run.pl --start-and-exit --mysqld=--falcon-page-size=2K

mysql> CREATE TABLE t1 ( f1 varchar(140) CHARACTER SET utf8, key (f1) ) ENGINE=falcon;
ERROR 1005 (HY000): Can't create table 'test.t1' (errno: 213)

Suggested fix:
Map the falcon internal error to an appropriate server error code.

I couldn't repeat this issue with mysql-6.0 tree.

Thank you for the bug report.

mysql> CREATE TABLE test.t1 ( f1 varchar(140) CHARACTER SET utf8, key (f1) ) ENGINE=falcon;
No connection. Trying to reconnect...
Connection id:    1
Current database: test

ERROR 1005 (HY000): Can't create table 'test.t1' (errno: 213)
mysql>

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/57304

2887 Sergey Vojtovich	2008-10-29
      BUG#39708 - Falcon: non-descriptive error message when creating a big key
      
      When a table creation fails due to too long key, returned
      error message was very generic and unspecific.
      
      Return descriptive error message when table creation
      fails due to too long key.

Pushed into 6.0.8-alpha  (revid:svoj@mysql.com-20081029114114-9gdkdc6cknckb294) (version source revid:vvaintroub@mysql.com-20081031154948-p0kay8egouts5a89) (pib:5)

A note has been added to the 6.0.8 changelog: 

When creating a table with the FALCON engine where the size of the key in the index was larger than supported (the error message did not signify the severity of the problem. The message and error has been updated.