[Comm] MySQL "max key length is 1000 bytes" bug?

[=?iso-8859-1?q?ua2fgb_=CE=C1_gmail=2Ecom?=]

Karavaev Pavel пишет:
>
> mysql> CREATE TABLE `connect` (
>    ->   `sender_name` varchar(64) NOT NULL default '',
>    ->   `sender_domain` varchar(255) NOT NULL default '',
>    ->   `src` varchar(39) NOT NULL default '',
>    ->   `rcpt` varchar(255) NOT NULL default '',
>    ->   `first_seen` timestamp(19) NOT NULL,
>    ->   KEY `connect_idx` (`src`,`sender_domain`,`sender_name`),
>    ->   KEY `connect_fseen` (`first_seen`)
>    -> ) TYPE=MyISAM;
> ERROR 1071 (42000): Specified key was too long; max key length is 1000 
> bytes
> mysql>
>
5.0.22-log -- не подтверждаю.

цитата из http://dev.mysql.com/doc/refman/5.0/en/create-table.html
KEY is normally a synonym for INDEX. The key attribute PRIMARY KEY can 
also be specified as just KEY when given in a column definition. This 
was implemented for compatibility with other database systems.


Попробуй изменить KEY на INDEX. Если не поможет -- попробуй создать 
таблицу без ключей.