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

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 650676 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 3/10/2011 10:12:16 AM
Access Restriction Public


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.


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.
Sign in to post a comment.
Posted by Umachandar [MSFT] 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 Umachandar [MSFT] 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