FIX: Incorrect result when you execute a full-text query with parallel execution plan in SQL Server 2012 or SQL Server 2014


Assume that you execute a full-text query that uses an execution plan that includes parallelism over full text operator. You set a condition that causes this query to execute serially at run time by using this execution plan. In this situation, the query result is incorrect.

For example, consider the following scenario:
  • You enable the Resource Governor in a Microsoft SQL Server 2012 instance.
  • You create a workload group and set the value of the Degree of Parallelism option to 1.
  • You execute a full-text query that uses a MAXDOP query hint that the value is larger than 1 through the given connection.
In this scenario, the query result may be incorrect.


Cumulative Update information

The issue was first fixed in the following cumulative update of SQL Server.
Recommendation: Install the latest cumulative update for SQL Server


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Article ID: 3074922 - Last Review: Aug 17, 2015 - Revision: 1