From mboxrd@z Thu Jan  1 00:00:00 1970
Return-Path: <ua2fgb@gmail.com>
X-Spam-Checker-Version: SpamAssassin 3.2.3 (2007-08-08) on sa.int.altlinux.org
X-Spam-Level: 
X-Spam-Status: No, score=-1.7 required=5.0 tests=AWL,BAYES_00 autolearn=ham
	version=3.2.3
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:disposition-notification-to:date:from:user-agent:mime-version:to:subject:references:in-reply-to:content-type:content-transfer-encoding;
	bh=T34RpCAZe/E5Ympf3+B1AzPI5OQ11NzSzgmz4xF7b9k=;
	b=LlQRn8Ik4849NGe92s5HUBuERFh2F/eVzyor5/hhG4PN820cpAJtcIEq8JKkAenvx0DB9qXNH1PXty4fxwcniV7HW8oPwYqwfqRlDGvEHkxtqRRAu2y5LqAVv0Urgv3fPIAU6PbVGzfM1N67vYYhBsoC125vyrhuoR0nQA+ugpY=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:disposition-notification-to:date:from:user-agent:mime-version:to:subject:references:in-reply-to:content-type:content-transfer-encoding;
	b=ZXVEI9ggjQCMAxvuW4+Ozc8hcS1+IefpEpMzhcj/umpqna8jVmhUT4xwp7wrve36P+Twg0iiTP/b3bd8HR4QL8x/RTDm66Nno68B7vBzQOJ7qY00QbB6dkXa9fRrA/JlOgEUdspG1g5oTMxIyg1vGnblp4IaE6dciW71TCH9IxM=
Message-ID: <47D7D346.9080507@gmail.com>
Date: Wed, 12 Mar 2008 14:57:42 +0200
From: "ua2fgb@gmail.com" <ua2fgb@gmail.com>
User-Agent: Thunderbird 2.0.0.12 (X11/20080213)
MIME-Version: 1.0
To: ALT Linux Community general discussions <community@lists.altlinux.org>
References: <47D77CC8.1070808@yandex.ru>
In-Reply-To: <47D77CC8.1070808@yandex.ru>
Content-Type: text/plain; charset=KOI8-R; format=flowed
Content-Transfer-Encoding: 8bit
Subject: Re: [Comm] MySQL "max key length is 1000 bytes" bug?
X-BeenThere: community@lists.altlinux.org
X-Mailman-Version: 2.1.10b3
Precedence: list
Reply-To: ALT Linux Community general discussions
	<community@lists.altlinux.org>
List-Id: ALT Linux Community general discussions <community.lists.altlinux.org>
List-Unsubscribe: <https://lists.altlinux.org/mailman/listinfo/community>,
	<mailto:community-request@lists.altlinux.org?subject=unsubscribe>
List-Archive: <http://lists.altlinux.org/pipermail/community>
List-Post: <mailto:community@lists.altlinux.org>
List-Help: <mailto:community-request@lists.altlinux.org?subject=help>
List-Subscribe: <https://lists.altlinux.org/mailman/listinfo/community>,
	<mailto:community-request@lists.altlinux.org?subject=subscribe>
X-List-Received-Date: Wed, 12 Mar 2008 12:57:47 -0000
Archived-At: <http://lore.altlinux.org/community/47D7D346.9080507@gmail.com/>
List-Archive: <http://lore.altlinux.org/community/>
List-Post: <mailto:mandrake-russian@linuxteam.iplabs.ru>

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. Если не поможет -- попробуй создать 
таблицу без ключей.