Assume that you have a table that has columnstore indexes in Microsoft SQL Server 2014 or 2016. When you execute a query plan that has a Nested Loop join between two Hash joins working in batch mode, an intra-query deadlock may occur.
Service pack informationThis issue was fixed in the SQL Server 2016 Service Pack 1 (SP1) . See the SQL Server 2016 build versions .
Cumulative update informationThis issue is fixed in the following cumulative update for SQL Server:
Cumulative Update 4 for SQL Server 2016
About cumulative updates for SQL Server
SQL Server 2016This issue is fixed in On-demand hotfix for SQL Server 2016 CU2 .
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Article ID: 3195825 - Last Review: 17 Jan 2017 - Revision: 3