From mboxrd@z Thu Jan  1 00:00:00 1970
Return-Path: <pppd@yandex.ru>
X-Spam-Checker-Version: SpamAssassin 3.2.3 (2007-08-08) on sa.int.altlinux.org
X-Spam-Level: 
X-Spam-Status: No, score=-2.3 required=5.0 tests=BAYES_00 autolearn=ham
	version=3.2.3
Message-ID: <47D91920.1000807@yandex.ru>
Date: Thu, 13 Mar 2008 16:08:00 +0400
From: Karavaev Pavel <pppd@yandex.ru>
User-Agent: Thunderbird 2.0.0.6 (X11/20070804)
MIME-Version: 1.0
To: ALT Linux Community general discussions <community@lists.altlinux.org>
References: <47D77CC8.1070808@yandex.ru> <47D7D346.9080507@gmail.com>
In-Reply-To: <47D7D346.9080507@gmail.com>
Content-Type: text/plain; charset=KOI8-R; format=flowed
Content-Transfer-Encoding: 8bit
X-AV-Checked: ClamAV using ClamSMTP
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: Thu, 13 Mar 2008 12:08:04 -0000
Archived-At: <http://lore.altlinux.org/community/47D91920.1000807@yandex.ru/>
List-Archive: <http://lore.altlinux.org/community/>
List-Post: <mailto:mandrake-russian@linuxteam.iplabs.ru>

ua2fgb@gmail.com пишет
> 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. Если не поможет -- попробуй создать 
> таблицу без ключей.
>
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,
    ->   INDEX `connect_idx` (`src`,`sender_domain`,`sender_name`),
    ->   INDEX `connect_fseen` (`first_seen`)
    -> ) TYPE=MyISAM;
ERROR 1071 (42000): Specified key was too long; max key length is 1000 bytes
mysql> select version();
+------------+
| version()  |
+------------+
| 5.0.51-log |
+------------+
1 row in set (0.00 sec)
mysql>
Создать таблицу без ключей, конечно, можно. Может быть, даже и 
заработает. Но разве это выход? sqlgrey - не единственный, кто может 
захотеть ключи по полям. varchar.