[es] - Fulltext search problem

nikola.s

Član broj: 4434
Poruke: 16
*.NBS.BG.AC.YU.

Profil

^{01.03.2006. u 15:23 - pre 225 meseci}

SQL Server 2000, tabela u kojoj je indeksirano 5 kolona
Zapis
Authors :<von Laer L><Hasler C>
Title: [Spontaneous corrections, growth disorders and post-traumatic deformities ...

Sa CONTAINS (*,'Spontaneous and corrections') - SQL SERVER vraca zapis kao rezultat
Sa CONTAINS (*,'Laer and Hasler' ) - SQL SERVER vraca zapis kao rezultat
Sa CONTAINS (*,'Laer and Spontaneous and corrections' ) - SQL SERVER ne vraca zapis

Cemu sluzi ova *?
Ili je problem u indeksiranju (tabela ima oko 16,000,000 redova).

Odgovor na temu

nikola.s

Član broj: 4434
Poruke: 16
*.ptt.yu.

Profil

Re: Fulltext search problem

^{01.03.2006. u 18:42 - pre 225 meseci}

I odgovor ...

Citat:

MSDN:Full-Text Search Queries with CONTAINS Clause Search Across Columns
...
For example, assume a table called ftstable with three columns: c1 as integer (the index column), and c2 and c3 as varchar columns that are full-text enabled. Also assume that a row contains "apples" in column c2 and "oranges" in columnn c3. In SQL Server 7.0 SP2 and earlier, the following query

select c1 from ftstable where contains(*,'"apples" and "oranges"')

is incorrectly interpreted as follows:

select c1 from ftstable where contains(*,'"apples"') AND contains(*,'"oranges"')

and the row is returned.

NOTE: The correct way to interpret the query is as follows:

select c1 from ftstable where contains(c2,'"apples" and "oranges"') OR contains(c3,'"apples" and "oranges"')

Ispravljeno u SQL serveru 7.0 Service pack 3.

Odgovor na temu