[rt-users] Full text index with MySQL 5.6

[Daksh Chauhan]

Hello all,
We have recently upgraded to 4.0.8 (running on SuSE Linux11 SP2; MySQL 5.5)
After upgrade, we learned that Content based search is missing.

Found this article:
http://blog.bestpractical.com/2011/06/index.html

Also noted that in MySQL 5.6, Full-text Search function is available:
http://dev.mysql.com/doc/refman/5.6/en/fulltext-search.html

I am wondering if any one has tried this with MySQL 5.6 and RT 4.x?

I have RT 4.0.8 working on my test VM with MySQL 5.6.8, but need to confirm if I can use same Index as documented here: http://blog.bestpractical.com/2011/06/index.html

CREATE TABLE AttachmentsIndex (
id     INTEGER UNSIGNED NOT NULL,
weight INTEGER NOT NULL,
query  VARCHAR(3072) NOT NULL,
INDEX(query)
)


Thanks,

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20121212/024c2fa9/attachment.htm>