Merge using cte with calculated column and output clause - EXCEPTION_ACCESS_VIOLATION - by DeeYu

Status : 

  Duplicate<br /><br />
		This item appears to be a duplicate of another existing Connect or internal item.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


8
0
Sign in
to vote
ID 788408 Comments
Status Closed Workarounds
Type Bug Repros 2
Opened 5/22/2013 10:29:51 AM
Access Restriction Public

Description

Tested on:
=======
Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64) 
	Dec 28 2012 20:23:12 
	Copyright (c) Microsoft Corporation
	Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)


Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (X64) 
	Oct 19 2012 13:38:57 
	Copyright (c) Microsoft Corporation
	Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

Microsoft SQL Server 2008 (SP3) - 10.0.5788.0 (X64)   Jun 29 2012 21:00:35   Copyright (c) 1988-2008 Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 6.0 <X64> (Build 6002: Service Pack 2) 

The statement crashes both on a VM virtualized clustered instance as well as stand alone developer instance.

The only way to get the script to work is to remove the output clause or to remove the derived column.
Sign in to post a comment.
Posted by Microsoft on 6/3/2013 at 9:49 AM
Hello,
Thank you for submitting this feedback. We are aware of this issue and is a duplicate of another Connect item. For more information see Connect item http://connect.microsoft.com/SQLServer/feedback/details/752088/sev20-from-merge-with-row-number-with-cte-and-output-clause

Thanks,
Ajay
Senior Program Manager.
Posted by Microsoft on 5/31/2013 at 6:23 PM
Hello,
Thank you for submitting this feedback. We are aware of this issue and is a duplicate of another Connect item.

Thanks,
Ajay
Senior Program Manager.