On 6 May 2014, at 2:06am, Gene Connor <[email protected]> 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
