Home Dashboard Directory Help
Search

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


Status: 

Active


8
0
Sign in
to vote
Type: Bug
ID: 788408
Opened: 5/22/2013 10:29:51 AM
Access Restriction: Public
0
Workaround(s)
view
2
User(s) can reproduce this bug

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.
Details
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.
Sign in to post a workaround.