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

[Mike Gladysch]

Hi,

I expected that SQLite misbehaves in current versions. Since 3.8.4.3 (bundled 
with PHP 5.5.20 and PHP 5.6.4) all is still ok, but with next update of PHP 
there is SQLite 3.8.7.2 bundled.

Table:
6 colums including an primary on col1, an unique on col2 (not null), an unique 
on col3 nullable, col 4) and two more nullable colums.

Data:
1;1;null;test;null;null
2;2;null;test;null;null
3;3;null;test;null;null
4;4;something;test;null;null

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

Delivers different results:

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

Tested with Windows shell binaries.

Mike