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. Кто виноват и что делать?
next 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