Query Designer masks join errors - by wBob

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.

Sign in
to vote
ID 795542 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 7/31/2013 9:15:14 AM
Access Restriction Public


Whilst looking at the Query Designer in Management Studio 2012 for a newsgroup post, I noticed it incorrectly translates bad joins, eg given the following query with a "bad" Cartesian join, the designer represents it as it should be, rather than correctly translating the text:

USE AdventureWorksDW

FROM dbo.FactInternetSales AS f 
	INNER JOIN dbo.DimProduct AS p ON f.ProductKey = p.ProductKey
	INNER JOIN dbo.DimCustomer AS c ON f.CustomerKey = f.CustomerKey
WHERE p.ListPrice > 50 
  AND c.Gender = 'M'

I was going to suggest to the OP they could use the GUI to help visualise bad queries / check for Cartesian products, but it looks like they can't.
Sign in to post a comment.