Sorry to post this to quick. I just checked this with Firebird and I get same result. I did not expect that.
Sorry once again !! Radovan Antloga je 06.02.2017 ob 18:34 napisal:
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
_______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users