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.


1
0
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

Description

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

SELECT *
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.