[sqlite] Select query becomes distinct on where matches unique with null value

[Clemens Ladisch]

Mike Gladysch wrote:
> Select col1, col2, col3, col4, col5, col6
> From table
> Where col3 is null and col4 ='test'

That is not valid SQL.

> 3.8.4.3: 3 rows (expected, ok)
> 3.8.7.2: 1 row (wrong)

How to reproduce:

  create table t(x, y, unique(x, y));
  insert into t values(null, 1);
  insert into t values(null, 1);
  select * from t where x is null and y = 1;
  |1


Regards,
Clemens