Found GDR Bug: At least I think it is.



This is not isolated to GDR, but seams to exist in Data Dude as well. If you create the following SQL:


   1: CREATE VIEW [dbo].[v_SomeView] AS 
   2: SELECT    [BH].[Col1],
   3:         [BH].[Col2],
   4:         [BH].[Col3],
   5:         [BH].[Col4],
   6:         [BH].[Col5],
   7:         CASE WHEN [BHPP].[OtherCol1] IS NULL THEN -1 ELSE 1 END As [Col6],
   8:         CASE WHEN [BHPP].[OtherCol1] IS NULL THEN 'Not Applicable' ELSE 'PowerPack' END As [Col7],
   9:         CASE WHEN [BHPP].[OtherCol1] IS NULL THEN [BH].[Col5] ELSE [BHPP].[OtherCol2] END As [Col8]
  10: FROM    [dbo].[Table1] as [BH]
  11:         LEFT JOIN     (SELECT [OtherCol1], [OtherCol2], [OtherCol3]
  12:                     FROM    [$(CMD)].[dbo].[Table2]
  13:                     WHERE    [OtherCol1] <> -1) as [BHPP]
  14:             ON [BH].[Col2] = [BHPP].[Col2]


And add it to your Database project, but using proper table names 🙂 You will get the following error for every use of [BHPP]:

Error    13    SR0029 : Microsoft.Validation : View: [dbo].[v_SomeView] contains an unresolved reference to an object. Either the object does not exist or the reference is ambiguous because it could refer to any of the following objects:….

This is a show stopper for us as we can’t (without good cause) be creating more views just to do a derived table…

I have submitted a Bug, so vote as you like, but please vote…

Bug: GDR – derived tables

Technorati Tags:  

Create a conversation around this article

Share on Facebook
Share on Twitter
Share on Linkdin

Read more

Martin Hinshelwood
In organizational development and team dynamics, Agile (as the Agile Manifesto delineates) and Scrum (as the Scrum Guide outlines) guide teams not by solving their problems but by illuminating the issues that demand attention. These frameworks aim to identify and spotlight the challenges within a team or organization’s processes, effectively …
Martin Hinshelwood
This week, I participated in a Webinar hosted by Sabrina Love ( Product Owner) as well as my colleagues, Joanna Płaskonka, Ph.D. and Alex Ballarin to discuss the state of learning and how immersive learning is the future of training. You can watch the video below to hear what …
Martin Hinshelwood
For a long time now I have been searching for that perfect domain that epitomised the vision, the why, of what I am trying to achieve with my customers and the industry at large. Now I have found it in
Martin Hinshelwood
At the MVP Summit I was appalled by the number of people who asked questions about new features for supporting hierarchical tasks! I shared a disgusted look with Peter Provost and we had a quick (and I mean really quick) conversation that resulted in this post. it really comes down …