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 -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]