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: [email protected]
[mailto:[email protected]] 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 <[email protected]> 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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
