https://bugzilla.wikimedia.org/show_bug.cgi?id=26517

--- Comment #1 from Reedy <s...@reedyboy.net> 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
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to