This problem is fixed on trunk. Thanks for the report. On 4/11/15, Mike Gladysch <mail at mike-gladysch.de> wrote: > 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 > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
-- D. Richard Hipp drh at sqlite.org