Duplicates in result set

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Michael D. - 24 Jan 2005 22:41 GMT

I have a simple FT query

SELECT PK,TEXT_DATA
FROM TABLE
WHERE CONTAINSs(TEXT_DATA,'"search1" and "search2"')

I get duplicates in the result set, despite the fact that no duplicates of
the PK,TEXT_DATA exist in the table...

Is this an indication that the FT index is corrupt ???

Any insight will be of value.

Michael.

Reply to this Message

Hilary Cotter - 24 Jan 2005 22:48 GMT

well, it is unusual behavior.

Are you saying you will get two rows with the same pk returned from this
search?

>I have a simple FT query
>
[quoted text clipped - 10 lines]
>
> Michael.

Reply to this Message

John Kane - 25 Jan 2005 02:06 GMT

Michael,
Have you tried using the distinct keyword? For example,

SELECT DISTINCT PK, cast(TEXT_DATA as varchar(1000)) as Short_Description
FROM TABLE
WHERE Contains(TEXT_DATA,'"search1" and "search2"')

Regards,
John

Signature

SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/

> I have a simple FT query
>
[quoted text clipped - 10 lines]
>
> Michael.

Reply to this Message