<story><title>Null Values in SQL Queries</title><url>https://mitchum.blog/null-values-in-sql-queries/</url></story><parent_chain><item><author>SigmundA</author><text>No I am tired of this WHERE (a = b) or (a IS NULL AND b IS NULL)&lt;p&gt;Null should equal null like in every other programming language even SQL group by do null equals null which is even more inconsistent.</text></item><item><author>juped</author><text>&amp;gt;For example, Oracle database won’t allow you to have an empty string. Anytime Oracle database sees an empty string, it automatically converts the empty string into a NULL value.&lt;p&gt;Damn. This is how you do enterprise.&lt;p&gt;I might be the only person who likes SQL nulls. If you learn how they work up front, they&amp;#x27;re useful and not really that confusing. But if I ran into weird behaviors like this, I might hate them too.</text></item></parent_chain><comment><author>jeltz</author><text>It is quite wordy but the SQL solution for this is &amp;quot;WHERE a IS NOT DISTINCT FROM b&amp;quot;.&lt;p&gt;&lt;a href=&quot;https:&amp;#x2F;&amp;#x2F;modern-sql.com&amp;#x2F;feature&amp;#x2F;is-distinct-from&quot; rel=&quot;nofollow&quot;&gt;https:&amp;#x2F;&amp;#x2F;modern-sql.com&amp;#x2F;feature&amp;#x2F;is-distinct-from&lt;/a&gt;</text></comment>
<story><title>Null Values in SQL Queries</title><url>https://mitchum.blog/null-values-in-sql-queries/</url></story><parent_chain><item><author>SigmundA</author><text>No I am tired of this WHERE (a = b) or (a IS NULL AND b IS NULL)&lt;p&gt;Null should equal null like in every other programming language even SQL group by do null equals null which is even more inconsistent.</text></item><item><author>juped</author><text>&amp;gt;For example, Oracle database won’t allow you to have an empty string. Anytime Oracle database sees an empty string, it automatically converts the empty string into a NULL value.&lt;p&gt;Damn. This is how you do enterprise.&lt;p&gt;I might be the only person who likes SQL nulls. If you learn how they work up front, they&amp;#x27;re useful and not really that confusing. But if I ran into weird behaviors like this, I might hate them too.</text></item></parent_chain><comment><author>progval</author><text>&amp;gt; Null should equal null like in every other programming language&lt;p&gt;Think of SQL&amp;#x27;s NULL like it&amp;#x27;s a NaN.</text></comment>