SELECT id
FROM CaseLaw c join containstable(CaseLaw,CaseText,'("crime and punishment")') ct on c.id = ct.[key]
WHERE (c.CaseType=1 OR c.CaseType=2)
We are using SQL Server 2000 full-text indexing and the script above isn't returning the result set we are expecting. Along with all terms containing "crime and punishment" we are also returning a record that has both terms in it, but they are not in a string "crime and punishment". The places in the record that have the terms crime or punishment are listed below. As you can see they are never together.
...(a) "grossly disproportionate to the severity of the crime" warranting punishment...
...does not purport to be punishment at all must involve more than ordinary...
...right to be free from cruel and unusual punishment. On this claim...
...Eighth Amendment's prohibition against cruel and unusual punishment. See Whitley v. Albers...
...Cruel and Unusual Punishment Clause)...
Has anyone encountered this error before, if so is there a workaround that fixes this issue?
Thanks,
Joy
FROM CaseLaw c join containstable(CaseLaw,CaseText,'("crime and punishment")') ct on c.id = ct.[key]
WHERE (c.CaseType=1 OR c.CaseType=2)
We are using SQL Server 2000 full-text indexing and the script above isn't returning the result set we are expecting. Along with all terms containing "crime and punishment" we are also returning a record that has both terms in it, but they are not in a string "crime and punishment". The places in the record that have the terms crime or punishment are listed below. As you can see they are never together.
...(a) "grossly disproportionate to the severity of the crime" warranting punishment...
...does not purport to be punishment at all must involve more than ordinary...
...right to be free from cruel and unusual punishment. On this claim...
...Eighth Amendment's prohibition against cruel and unusual punishment. See Whitley v. Albers...
...Cruel and Unusual Punishment Clause)...
Has anyone encountered this error before, if so is there a workaround that fixes this issue?
Thanks,
Joy