Categories
Uncategorized

Comment: Remove Immediately Null Null!

I found this while looking through some code today…

I found this while looking through some code today:

This is just temporary….. Should be removed immediately

This was written by a consulting company we once used. I’m guessing the comment has been in there for the last few years…

The line under it, that I’m guessing should have been removed:

SELECT 
  * 
FROM 
  table1 
WHERE 
  field1 is null 
AND 
  field1 is not null

Now granted, I’m no SQL expert, but that query just doesn’t make sense to me…