vliet (11/13/2013)
...For example, when using an INNER JOIN instead of a LEFT OUTER JOIN to list people with their skills, it might go easily unnoticed that you are missing someone without any registered skill, especially if nearly all of them do have registered skills. Even harder to track down are the small errors introduced in the values of SUMs or COUNTs when someone overlooked the sometimes unexpected behavior of NULLable columnsin JOIN and WHERE clauses...
Totally disagree. These are valid test cases that should be considered by the developer. These are similar types of scenarios to division by zero, null references, empty collections etc. They even have a term (or two): Edge Cases/Boundary Testing etc.
Gaz
-- Stop your grinnin' and drop your linen...they're everywhere!!!