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

Status : 

  Not Reproducible<br /><br />
		The product team could not reproduce this item with the description and steps provided.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 837380 Comments
Status Resolved 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.