Re: ejabberd + MySQL Cluster ERROR HASH ON PREFIX

[Stewart Smith]

just remove the prefix from the CREATE INDEX statement

i.e. use:

CREATE UNIQUE INDEX i_rosteru_user_jid USING HASH ON rosterusers(username, jid);

instead of;

CREATE UNIQUE INDEX i_rosteru_user_jid USING HASH ON rosterusers(username(75), jid(75));

Stewart Smith, Software Engineer - MySQL Cluster
MySQL AB, www.mysql.com

Jumpstart your cluster:
http://www.mysql.com/consulting/packaged/cluster.html