Home Dashboard Directory Help
Search

SQL 2008 Upgrade Advisor unable to detect a deprecated Feature by SIDDHARTH_MEHTA


Status: 

Closed
 as Won't Fix Help for as Won't Fix


1
0
Sign in
to vote
Type: Bug
ID: 650676
Opened: 3/10/2011 10:12:16 AM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

1.We have a stored procedure with group by clause in a sub query on a SQL 2005 database instance.
2.As per the following link the GROUP BY clause cannot contain a subquery in an expression that is used for the group by list. In earlier versions of SQL Server, this was allowed. In SQL Server 2008, error 144 is returned.

http://msdn.microsoft.com/en-us/library/ms143179.aspx

3.When we run SQL 2008 upgrade advisor it does not detect the or even give any warnings with respect to the above stored procedure.
Details
Sign in to post a comment.
Posted by Microsoft on 6/29/2011 at 3:07 PM
Hello Siddharth,
After investigating the issue a bit more, we have decided not to add support in Upgrade Advisor to detect this case. The sub-query in GROUP BY clause syntax has been disallowed for a long time in SQL Server. Based on my testing, it it not accepted from SQL Server 2000 (tested on SP4) onwards. There is not much value in adding a rule for this case so I am closing this issue as "Won't Fix".

--
Umachandar, SQL Programmability Team
Posted by Microsoft on 3/11/2011 at 5:48 PM
Hi Siddharth,
Thanks for reporting the issue. We will take a look at adding a rule in upgrade advisor to detect this breaking change.

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