Sunday, September 21, 2008

Just say no to implicit cartesian joins

I want an option to prevent queries with unexpected cartesian joins from running. When enabled an error will be raised for this query:
select * from foo, bar
This query will continue to work:
select * from foo cross join bar
I read many more queries than I write and it is much easier to find missing join conditions in a query when ANSI join syntax is used.

0 comments:

Post a Comment