freetexttable bug

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Baldwin - 12 Oct 2007 16:15 GMT

Hi,

We've been using the catalog as part of our search engine for a year
now. We use freetexttable to search for keywords and it is fine until
now. For some reason the 'freetexttable' is inconsistent.

I tried this query and I got a lot of rows.
select * from tb_catalog
where content like '%AT&T%'

When I try this, I dont get anything.
select * from freetexttable(tb_catalog, *, 'AT&T')

But when I try this, I got rows.
select * from freetexttable(tb_catalog, *, 'SB&C')

So I thought it is just an ampersand issue but it worked in the last
query.

Any thoughts are really appreciated.

Great Thanks,
Baldwin
MISICompany

Reply to this Message

Hilary Cotter - 17 Oct 2007 03:47 GMT

I've repro'd this. It could be by design, I'll raise it internally and see
if it is a bug.

Signature

RelevantNoise.com - dedicated to mining blogs for business intelligence.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> Hi,
>
[quoted text clipped - 20 lines]
> Baldwin
> MISICompany

Reply to this Message

Hilary Cotter - 17 Oct 2007 12:27 GMT

duh silly me. You need to remove AT from your noise word list and then
rebuild your catalog.

Signature

> I've repro'd this. It could be by design, I'll raise it internally and see
> if it is a bug.
[quoted text clipped - 23 lines]
>> Baldwin
>> MISICompany

Reply to this Message

Baldwin - 17 Oct 2007 21:18 GMT

> duh silly me. You need to remove AT from your noise word list and then
> rebuild your catalog.
[quoted text clipped - 41 lines]
>
> - Show quoted text -

Thanks for the reply. But I dont think I want to do that. If I removed
the "AT" from the list of noise words, I can now search for "AT".

The other thing is, is the "&" was converted to space or something
that the search engine now is looking for "AT" and "T" but both are
considered as noise words thus not returning anything as oppose to
considering the AT&T as one word. take note that there is no space
between letters - "AT&T". is there a way we can use an escape
character for "&" so the search engine will consider AT&T as one word?

thanks really for the help.
Baldwin

Reply to this Message

Hilary Cotter - 18 Oct 2007 03:37 GMT

No, unfortunately not.

Signature

>> duh silly me. You need to remove AT from your noise word list and then
>> rebuild your catalog.
[quoted text clipped - 63 lines]
> thanks really for the help.
> Baldwin

Reply to this Message