[Datadude] T-SQL parser throws warnings for valid T-SQL - by Jamie Thomson

Status : 

  Deferred<br /><br />
		The product team has reviewed this issue and has deferred it for consideration at a later time.<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 624876 Comments
Status Closed Workarounds
Type Bug Repros 5
Opened 11/26/2010 2:50:13 AM
Access Restriction Public


The T-SQL parser is throwing warnings for what I believe to be perfectly good code. I know its good code because I have deployed it and it works fine.

I've attached all the source code form my datadude project. Please open, build, and you will see the same 8 warnings.
Sign in to post a comment.
Posted by Barclay [MSFT] on 12/21/2010 at 4:11 PM

Thank you for submitting this issue. We have reproduced this issue and have added it to our product backlog. It will be considered for a future release of Visual Studio.

We have a bug in our interpreter in which it gets confused with the aliases and nesting of sub queries in some CTEs. To work around it you can move this function to the post deployment script or simplify the CTE by using a table variable/temp table. For this specific example it would be simplifying the row source for "reportValuesCTE".

We appreciate you sending this in and will use it to validate our improvements.

Barclay Hill
Sr. Program Manager | Visual Studio Product Team (Data Tools) | Microsoft Corporation
Posted by Microsoft on 11/28/2010 at 5:52 PM
Thanks for your feedback.
We are routing this issue to the appropriate group within the Visual Studio Product Team for triage and resolution. These specialized experts will follow-up with your issue.
Posted by Microsoft on 11/26/2010 at 3:20 AM
Thank you for your feedback, we are currently reviewing the issue you have submitted. If this issue is urgent, please contact support directly(http://support.microsoft.com)