Home Dashboard Directory Help
Search

Access violation with synonym in CTE by Erland Sommarskog


Status: 

Closed
 as Fixed Help for as Fixed


6
0
Sign in
to vote
Type: Bug
ID: 785518
Opened: 4/24/2013 3:24:39 PM
Access Restriction: Public
0
Workaround(s)
view
2
User(s) can reproduce this bug

Description

This scenario is taken from http://social.Msdn.microsoft.com/Forums/en-US/transactsql/thread/ed99d33e-ad46-4bee-8173-ee7f62ed6840#ed99d33e-ad46-4bee-8173-ee7f62ed6840

You have a view, which in a CTE refers to a scalar UDF through a synonym. This results in an Access Violation on SQL 2012. It works on SQL 2008.
Details
Sign in to post a comment.
Posted by Vidar Nordnes on 10/10/2013 at 3:45 AM
I have two customers that would really appreciate getting this fix for 2012, so please port it to 2012 too
Posted by Microsoft on 6/12/2013 at 11:28 AM
Hello Erland,
We have now fixed the bug for the next major version of SQL Server. We will consider porting it to SQL Server 2012 based on feedback.

--
Umachandar, SQL Programmability Team
Posted by Microsoft on 5/10/2013 at 10:18 AM
Hello Erland,
Thanks for reporting the bug. We will investigate the problem & let you know what we find.

--
Umachandar, SQL Programmability Team
Sign in to post a workaround.