ALT Linux Community general discussions
 help / color / mirror / Atom feed
From: Karavaev Pavel <pppd@yandex.ru>
To: ALT Linux Community <community@lists.altlinux.org>
Subject: [Comm] MySQL "max key length is 1000 bytes" bug?
Date: Wed, 12 Mar 2008 10:48:40 +0400
Message-ID: <47D77CC8.1070808@yandex.ru> (raw)

Приветствую сообщество!
При установке greysql столкнулся в тем, что он не может создать свои 
рабочие таблицы по причине:

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>

Вроде бы похоже на старый баг http://bugs.mysql.com/bug.php?id=13835 , 
но пример, приведенный на этой странице выполняется нормально:

mysql> create table fulltext_test(id integer
    -> ,fulltext_string varchar(10000)
    -> ,fulltext index ftx1(fulltext_string)
    -> );
Query OK, 0 rows affected (0.00 sec)
mysql>

Данную ситуацию схватил на MySQL-server-5.0.51-alt1 и на 
MySQL-server-5.0.34-alt1.
Кто виноват и что делать?


             reply	other threads:[~2008-03-12  6:48 UTC|newest]

Thread overview: 3+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2008-03-12  6:48 Karavaev Pavel [this message]
2008-03-12 12:57 ` ua2fgb
2008-03-13 12:08   ` Karavaev Pavel

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=47D77CC8.1070808@yandex.ru \
    --to=pppd@yandex.ru \
    --cc=community@lists.altlinux.org \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link

ALT Linux Community general discussions

This inbox may be cloned and mirrored by anyone:

	git clone --mirror http://lore.altlinux.org/community/0 community/git/0.git

	# If you have public-inbox 1.1+ installed, you may
	# initialize and index your mirror using the following commands:
	public-inbox-init -V2 community community/ http://lore.altlinux.org/community \
		mandrake-russian@linuxteam.iplabs.ru community@lists.altlinux.org community@lists.altlinux.ru community@lists.altlinux.com
	public-inbox-index community

Example config snippet for mirrors.
Newsgroup available over NNTP:
	nntp://lore.altlinux.org/org.altlinux.lists.community


AGPL code for this site: git clone https://public-inbox.org/public-inbox.git