Added that... Would appear it's not doing any casting to promote values but just promoting everything to float.
SQL> insert into numtypes values(1,2,21); 1 row created. SQL> select A/B*C from numtypes; A/B*C ---------- 12.5 13.5 11.5 10.5 -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin Sent: Monday, May 13, 2013 11:01 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Possible bug in type conversion prior to comparison On 13 May 2013, at 4:57pm, Michael Black <mdblac...@yahoo.com> wrote: > Oracle gives the right answer too for example(contrary to what somebody said > earlier). > > create table numtypes (A NUMERIC, B NUMERIC, C NUMERIC); > insert into numtypes values (1, 2, 25.23); > insert into numtypes values (1.0, 2, 27.17); > insert into numtypes values (1.1, 2, 22.92); > select A/B*C from numtypes; > > A/B*C > ---------- > 12.5 > 13.5 > 11.5 Please add to your INSERTs (1,2,21) and see whether Oracle is using integer arithmetic or not. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users