FIX: Some Full-Text Search Failures Do Not Set @@ERROR (287167)

MORE INFORMATION

To reproduce the problem, run the following statements in the SQL Server Query Analyzer. The output contains two errors. The first error does not set @@ERROR properly, but the second one does.

create database test
go

use test

if object_id('t1') is not null drop table t1
go
create table t1
(
  id int identity(1,1) primary key not null,
  col varchar(100)
)
go

create unique index tableindex on t1(ID)
go

exec sp_fulltext_database 'enable'
exec sp_fulltext_catalog 't1_catalog','create'
exec sp_fulltext_table 't1','create','t1_catalog','tableindex'
exec sp_fulltext_column 't1','col','add'
go

insert into t1 values('SQL Server 2000')
go
exec sp_fulltext_catalog 't1_catalog','start_full'
go
while ( fulltextcatalogproperty ('t1_catalog','populatestatus') <>  0 ) waitfor delay '0:00:05'
go

select * from t1
go

select col from t1 where contains(col,'very')
go
select @@error as 'The query fails but @@ERROR IS NOT set:'
go

select col from t1 where contains(col,'SQL Server')
go
select @@error as 'The query fails but @@ERROR IS set:'
go

exec sp_fulltext_table 't1','drop'
exec sp_fulltext_Catalog 't1_catalog','drop'
drop index t1.tableindex
drop table t1