Home Dashboard Directory Help
Search

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


Status: 

Active


1
0
Sign in
to vote
Type: Bug
ID: 837380
Opened: 3/20/2014 9:05:31 AM
Access Restriction: Public
1
Workaround(s)
view
0
User(s) can reproduce this bug

Description

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
Details
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.
Sign in to post a workaround.
Posted by Dimaa on 3/21/2014 at 11:32 AM
Force serial plan
File Name Submitted By Submitted On File Size  
FullTextProblem-script.sql 3/20/2014 11 KB