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.


1
0
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

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.
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