SQL Server Home
SQL Server Upgrade Advisor: Column aliases in ORDER BY clause cannot be prefixed by table alias
as Won't Fix
4/1/2010 12:25:58 AM
User(s) can reproduce this bug
"Column aliases in ORDER BY clause cannot be prefixed by table alias"
This issue is not detected and given in the report if this issue is in "View". It detects when it is in Stored Procedure.
SQL Server 2008 - Enterprise Edition
Windows XP Professional
Operating System Language
Steps to Reproduce
1. Create a View in SQL Server 2000 Northwind database.
create view view_vidya as
SELECT TOP 10 orderid oid, ord.customerid cid, CompanyName, ShipAddress, ShipCity
FROM orders ord LEFT OUTER JOIN customers cust
ORDER BY ord.oid, ord.cid
2. RUn the SQL Server 2008 upgrade advisor for this database
3. Check the report
"Column aliases in ORDER BY clause cannot be prefixed by table alias" issue is not shown in the report
It should have given this View as a object with Order by issue
to post a comment.
Please enter a comment.
on 5/27/2010 at 2:02 PM
Closing the bug as explained before.
on 5/26/2010 at 12:36 PM
After further investigation/analysis, the behavior change associated with this rule happened in SQL Server 2005. And since we will not be supporting upgrading from SQL Server 2000 to new version in the next major version of SQL Server, this rule will not exist in the new upgrade advisor. As to the current versions of Upgrade Advisor (2005/2008), this fix doesn't meet the bar for cumulative update so we cannot address it there also. Sorry for the trouble and we will update you if anything changes on our end.
on 5/6/2010 at 8:38 AM
I'm also interested in this. Any status yet?
on 5/4/2010 at 7:14 PM
Thanks for reporting the issue. We will investigate it and decide on how to address it best.
Umachandar, SQL Programmability Team
to post a workaround.
Please enter a workaround.
© 2013 Microsoft