Search problem with RT 3.8.0

Hi all,

We’ve recently upgraded from version 3.6, and I’ve noticed problems with
search (though it may be that I’m just taking a harder look at the
functionality).

When searching for ‘fulltext:wsj’ using the Simple Search form, we get 3
hits. When searching using the ‘Edit Search’ with the following search
string ‘Content like “WSJ”’, we get 63 results. Many of the missing hits
from the first to the second search are from hits against the Subject
field of the ticket. I also couldn’t find a reference on the
wiki/documentation site for the Simple Search syntax.

Any help would be appreciated,

William

In 3.8.0 fulltext search on mysql is case sensitive and we can not do
anything about that at this point. We either have to use external
fulltext indexing service like Sphinx or by refactoring our DB to
split binary and text content and using MyISAM (not transactional)
table for text as mysql’s InnoDB engine doesn’t support fulltext
indexes.On Fri, Aug 8, 2008 at 8:28 PM, William Hayes William.Hayes@biogenidec.com wrote:

Hi all,

We’ve recently upgraded from version 3.6, and I’ve noticed problems with
search (though it may be that I’m just taking a harder look at the
functionality).

When searching for ‘fulltext:wsj’ using the Simple Search form, we get 3
hits. When searching using the ‘Edit Search’ with the following search
string ‘Content like “WSJ”’, we get 63 results. Many of the missing hits
from the first to the second search are from hits against the Subject field
of the ticket. I also couldn’t find a reference on the wiki/documentation
site for the Simple Search syntax.

Any help would be appreciated,

William


The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Best regards, Ruslan.