Hi, I discovered a bug using sqlite 3.15.2. It is simple to reproduce. Try this SQL-s:
CREATE TABLE TEST( A integer primary key, B integer); -- insert some test data insert into TEST (A,B) values (1, 1); insert into TEST (A,B) values (2, null); -- check count(*) select count(*) from TEST where B is null and A > 3; -- bug sql using agg function (also with other functions: max, avg) select min(A) from TEST where B is null and A > 3; if you replace min(A) with * you get empty result set as expected but with min or max or avg you get one record Best Regards Radovan Antloga _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users