Bug #43745 Better error message for Index on BLOB/TEXT columns
Submitted: 19 Mar 2009 9:48 Modified: 23 Sep 2011 9:26
Reporter: Amit Saha Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Server: Errors Severity:S3 (Non-critical)
Version:6.0 OS:Any
Assigned to: CPU Architecture:Any

[19 Mar 2009 9:48] Amit Saha 
Description:
Consider the following:

mysql> create table f2 (a int, b BLOB, KEY(b)) Engine = Falcon;
ERROR 1073 (42000): BLOB column 'b' can't be used in key specification
with the used table type
mysql> create table f3 (a int, b TEXT, KEY(b)) Engine = Falcon;
ERROR 1073 (42000): BLOB column 'b' can't be used in key specification
with the used table type

The latter message should say TEXT instead of BLOB. 

How to repeat:
See description.
[19 Mar 2009 10:20] Sveta Smirnova 
Thank you for the report.

Verified as described.

Other storage engines return correct error message: "BLOB/TEXT column 'b' used in key specification without a key length"
[23 Sep 2011 9:26] Jon Olav Hauglid 
This bug is not repeatable using any current storage engines.
Therefore closing the bug as "Won't fix".