> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Thu 10/6/2005 10:14 AM > Subject: Re: [sqlite] Problem/Bug: "SELECT 5 / 2;" returns 2 > <[EMAIL PROTECTED]> wrote: > > Richard, I like to ask you, just to make sure; has the `order by` > > "bug"/issue, as result from automatic float->int conversion, been > > considered by you and if yes, do you plan any changes? > > > > > You have a simple workaround: Just add 0.0 to anything > that you definitely want to be floating point. > > I will continue to trying to figure out a reasonable method > of addressing your concerns.
In other databases the behavior in sqlite is the expected behavior. E.g. IBM db2udb, Ingres, Microsoft SQL Server. Oracle is different because of the wierd NUMBER datatype which is used to store both ints and decimal - I don't know about any others. In most databases the datatypes of the operands dictate the result type; which is the sqlite behavior. Chris