Not to be the new guy here, but would someone be so good as to explain why no one else is panicking that the modulo operator is horrifically broken? In http://www.sqlite.org/lang_expr.html it just says: "The operator % outputs the value of its left operand modulo its right operand."
There's nothing in there that says anything about requirements for the operands to be integers or about quietly rounding the results on you etc. sqlite> select 1.4444 % .001; 1.4444 % .001 NULL Shouldn't that be .0004? sqlite> select 1.4444 % 2; 1.4444 % 2 1.0 Why is this not 1.4444? This is worse than the NULL by blatantly giving a wrong answer and letting you think it succeeded. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
