Full text search (sql 2012) returns wrong results under stress with parallel plans - by Dimaa

Status : 


Sign in
to vote
ID 837380 Comments
Status Active Workarounds
Type Bug Repros 0
Opened 3/20/2014 9:05:31 AM
Access Restriction Public


Here is the query
SELECT @count=count(*) FROM Docs WHERE CONTAINS([text],'1')

If we have 600 000 + docs in a table and run the query above from 50+ concurrent connections (with random delay between execs 1000-1500 msec) exactly the same query sometimes returns 0 instead of actual number of records.

Problem exists only if SELECT uses parallel plan
Sign in to post a comment.
Posted by Dimaa on 4/2/2014 at 12:08 AM
Just checked with SQL Server 2014 RTM (Microsoft SQL Server 2014 - 12.0.2000.8 (X64) ). Problem is here.