This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
Hi guys...I have a left outer join query, and i noticed it returned too many results...
So now Im testing its logic by simplifying it.
I decided to do a control test, where the query returns 0 results.
I implemented this test by putting 1=0 as a criteria in the where clause (see below) ...
Anyways. My query is returning results !!! Why ? Shouldnt the 1=0 statement always evaluate to false, thus
making the only set of attributes which satisfy this criteria the null set (i.e. the empty set )?