On 6 May 2014, at 2:06am, Gene Connor <neothreeei...@hotmail.com> wrote:
> SELECT DISTINCT 2/4 AS RESULT FROM TABLE; > returns 0 Not a bug. By providing two integer operands you have asked for integer arithmetic, and will get an integer answer. It's something that happens in several different languages, even C ! Worse still, in some languages you get an integer answer if /either/ of the operands are integers. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users