blog

Found GDR Bug: At least I think it is.

Published on
1 minute read

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: ALM 

Code and Complexity Application Lifecycle Management blog Technical Debt Agile Software Development

Related blog posts

No related videos found.

Connect with Martin Hinshelwood

If you've made it this far, it's worth connecting with our principal consultant and coach, Martin Hinshelwood, for a 30-minute 'ask me anything' call.

Our Happy Clients​

We partner with businesses across diverse industries, including finance, insurance, healthcare, pharmaceuticals, technology, engineering, transportation, hospitality, entertainment, legal, government, and military sectors.​

ALS Life Sciences Logo
Akaditi Logo
Slaughter and May Logo
Emerson Process Management Logo
MacDonald Humfrey (Automation) Ltd. Logo
Alignment Healthcare Logo
YearUp.org Logo
Cognizant Microsoft Business Group (MBG) Logo
SuperControl Logo
Philips Logo

CR2

Freadom Logo
Schlumberger Logo
Sage Logo
Flowmaster (a Mentor Graphics Company) Logo
Workday Logo
Illumina Logo
Epic Games Logo
Washington Department of Transport Logo
Ghana Police Service Logo
Department of Work and Pensions (UK) Logo
Nottingham County Council Logo
Washington Department of Enterprise Services Logo
New Hampshire Supreme Court Logo
Flowmaster (a Mentor Graphics Company) Logo
Boeing Logo
Hubtel Ghana Logo
Schlumberger Logo
MacDonald Humfrey (Automation) Ltd. Logo
Ericson Logo