Assume that you execute a query to select data from an Oracle linked server by using a merge join in Microsoft SQL Server 2012 or SQL Server 2014. When there is a NUMBER type column that does not have a defined precision in the Oracle linked server, the query executes successfully, but some rows are missing in the result.
Note This issue only occurs if the merge join is automatically selected by SQL Server.
The issue was first fixed in the following cumulative update of SQL Server.
Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server:
The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, about the performance or reliability of these products.
Article ID: 2993262 - Last Review: 21 Oct 2014 - Revision: 1
Microsoft SQL Server 2012 Service Pack 2, Microsoft SQL Server 2012 Developer, Microsoft SQL Server 2012 Enterprise, Microsoft SQL Server 2012 Standard, Microsoft SQL Server 2014 Developer, Microsoft SQL Server 2014 Developer, Microsoft SQL Server 2014 Enterprise, Microsoft SQL Server 2014 Enterprise, Microsoft SQL Server 2014 Standard, Microsoft SQL Server 2014 Standard