https://bugzilla.wikimedia.org/show_bug.cgi?id=26517
--- Comment #1 from Reedy <[email protected]> 2010-12-31 05:32:25 UTC --- mysql> CREATE TABLE `thread` ( -> thread_id int(8) unsigned NOT NULL auto_increment, -> thread_root int(8) unsigned UNIQUE NOT NULL, -> thread_ancestor int(8) unsigned NOT NULL, -> thread_parent int(8) unsigned NULL, -> thread_summary_page int(8) unsigned NULL, -> thread_subject varchar(255) NULL, -> thread_author_id int unsigned NULL, -> thread_author_name varchar(255) NULL, -> thread_modified char(14) binary NOT NULL default '', -> thread_created char(14) binary NOT NULL default '', -> thread_editedness int(1) NOT NULL default 0, -> thread_article_namespace int NOT NULL, -> thread_article_title varchar(255) binary NOT NULL, -> thread_article_id int(8) unsigned NOT NULL, -> thread_type int(4) unsigned NOT NULL default 0, -> thread_sortkey varchar(255) NOT NULL default '', -> thread_replies int(8) DEFAULT -1, -> thread_signature TINYBLOB NULL, -> PRIMARY KEY thread_id (thread_id), -> UNIQUE INDEX thread_root_page (thread_root), -> INDEX thread_ancestor (thread_ancestor, thread_parent), -> INDEX thread_article_title (thread_article_namespace, thread_article_title, -> thread_sortkey), -> INDEX thread_article (thread_article_id, thread_sortkey), -> INDEX thread_modified (thread_modified), -> INDEX thread_created (thread_created), -> INDEX thread_summary_page (thread_summary_page), -> INDEX (thread_author_id,thread_author_name), -> INDEX (thread_sortkey) -> ) ENGINE=InnoDB, DEFAULT CHARSET=utf8; Query OK, 0 rows affected (0.14 sec) mysql> ^CCtrl-C -- exit! Aborted re...@ubuntu64-esxi:~$ mysql --version mysql Ver 14.14 Distrib 5.1.49, for debian-linux-gnu (x86_64) using readline 6.1 re...@ubuntu64-esxi:~$ WFM... Seemingly, an "error" with that collation - As per the error... It's as that collation uses multiple bytes per character mysql> SHOW VARIABLES LIKE '%collation%'; +----------------------+-------------------+ | Variable_name | Value | +----------------------+-------------------+ | collation_connection | latin1_swedish_ci | | collation_database | latin1_swedish_ci | | collation_server | latin1_swedish_ci | +----------------------+-------------------+ is mine (and the toolserver), and that's fine -> INDEX thread_article_title (thread_article_namespace, thread_article_title, -> thread_sortkey), 2 fields are 255 chars.. I'm guessing that they're to blame... -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
