[debian-mysql] Bug#490094: mysql-server-5.0: CREATE INDEX falsely reports "BLOB/TEXT column 'fn' used in key specification without a key length"

[Dennis Boone]

Subject: mysql-server-5.0: CREATE INDEX falsely reports "BLOB/TEXT column 'fn' used in key specification without a key length"
Package: mysql-server-5.0
Version: 5.0.45-1
Severity: normal

*** Please type your report below this line ***

CREATE INDEX with a key length is falsely reported to lack the key
length, and to refer to a field other than the specified one.  For
example:

dev1 94 # mysql reviews
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1387
Server version: 5.0.45-Debian_1-log Debian etch distribution

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

mysql> show create table people;
+--------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table  | Create Table
|
+--------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| people | CREATE TABLE `people` (
  `id` int(11) NOT NULL auto_increment,
  `email` tinytext NOT NULL,
  `password` tinytext NOT NULL,
  `groups` enum('Admin','Copy Editor','Review Editor','Reviewer')
default NULL,
  `fn` tinytext NOT NULL,
  `mi` tinytext NOT NULL,
  `ln` tinytext NOT NULL,
  `adr1` tinytext NOT NULL,
  `adr2` tinytext NOT NULL,
  `adr3` tinytext NOT NULL,
  `city` tinytext NOT NULL,
  `state` tinytext NOT NULL,
  `country` tinytext NOT NULL,
  `postcode` tinytext NOT NULL,
  `license` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20320 DEFAULT CHARSET=utf8 | 
+--------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> CREATE INDEX `fnix` ON people (`fn`(255));
Query OK, 20319 rows affected (2.49 sec)
Records: 20319  Duplicates: 0  Warnings: 0

mysql> CREATE INDEX `miix` ON people (`mi`(255));
ERROR 1170 (42000): BLOB/TEXT column 'fn' used in key specification
without a key length
mysql> CREATE INDEX `lnix` ON people (`ln`(255));
ERROR 1170 (42000): BLOB/TEXT column 'fn' used in key specification
without a key length
mysql> Bye

-- System Information:
Debian Release: lenny/sid
  APT prefers unstable
  APT policy: (500, 'unstable')
Architecture: i386 (i686)

Kernel: Linux 2.6.24.2 (SMP w/1 CPU core)
Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968)
Shell: /bin/sh linked to /bin/bash

Versions of packages mysql-server-5.0 depends on:
ii  adduser                 3.105            add and remove users and groups
ii  debconf [debconf-2.0]   1.5.14           Debian configuration management sy
ii  libc6                   2.7-6            GNU C Library: Shared libraries
ii  libdbi-perl             1.59-1           Perl5 database interface by Tim Bu
ii  libgcc1                 1:4.2.1-5        GCC support library
ii  libmysqlclient15off     5.0.45-1         MySQL database client library
ii  libncurses5             5.6+20080203-1   Shared libraries for terminal hand
ii  libreadline5            5.2-3            GNU readline and history libraries
ii  libstdc++6              4.2.1-5          The GNU Standard C++ Library v3
ii  libwrap0                7.6.dbs-14       Wietse Venema's TCP wrappers libra
ii  lsb-base                3.1-24           Linux Standard Base 3.1 init scrip
ii  mysql-client-5.0        5.0.45-1         MySQL database client binaries
ii  mysql-common            5.0.45-1         MySQL database common files
ii  passwd                  1:4.0.18.1-11    change and administer password and
ii  perl                    5.8.8-12         Larry Wall's Practical Extraction 
ii  psmisc                  22.5-1           Utilities that use the proc filesy
ii  zlib1g                  1:1.2.3.3.dfsg-6 compression library - runtime

Versions of packages mysql-server-5.0 recommends:
ii  bsd-mailx [mailx]  8.1.2-0.20071201cvs-2 A simple mail user agent
ii  mailx              1:20071201-2          Transitional package for mailx ren

-- debconf information:
  mysql-server/root_password: (password omitted)
  mysql-server-5.0/really_downgrade: false
  mysql-server-5.0/start_on_boot: true
* mysql-server-5.0/nis_warning:
  mysql-server-5.0/postrm_remove_databases: false
* mysql-server-5.0/no_upgrade_with_isam_tables:
* mysql-server-5.0/mysql_install_db_notes:
* mysql-server-5.0/need_sarge_compat: true
  mysql-server/error_setting_password:
  mysql-server-5.0/need_sarge_compat_done: true