SQLite Forum

STRICT tables and UNIQUE indices
Login
<code>NULL</code> values from different rows _are_ considered equal in <code>SELECT DISTINCT</code>.

This suggests yet another language extension: allow index and table constraint declarations to use the keyword <code>DISTINCT</code> instead of <code>UNIQUE</code> to specify that <code>NULL</code> values should be considered equal to each other.