Re:SELECT wat FROM sql
by sjwright on Monday April 27, 2020 @06:48PM
(#23001045)
Hard disagree. It should be impossible to make any truthful claim about a NULL with respect to any other value including NULL. Thus it is correct that both foo = bar is false and foo <> bar is false.
Were it any other way, joins wouldn’t work properly.
Were it any other way, joins wouldn’t work properly.