On Sep 17, 2012, at 5:09 PM, Simon Slavin <slav...@bigfraud.org> wrote:
> I suspect that this is what leads to different SQL engines implementing > count() in different ways. I suspect that you are indeed very confused :D The issue at hand is not whether or not count( * ) is implemented differently (it's not), but rather how null is handled: http://www.sqlite.org/nulls.html As far as, err, Oracle goes [1]: "Oracle Database currently treats a character value with a length of zero as null. However, this may not continue to be true in future releases, and Oracle recommends that you do not treat empty strings the same as nulls." [1] http://docs.oracle.com/cd/B28359_01/server.111/b28286/sql_elements005.htm _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users