Re: [cobalt-users] MySQL

["Robert G. Fisher" <rfisher@xxxxxxxxxxxxxxx>]

This has been covered several times -- look through the 
archives.  The issue is that MySQL doesn't support floating
point operations on the mips processor -- this means that
most mathematical operations in the db are not going to work.

pi(), sqrt(), div(), etc -- anything that uses non-integers
somewhere in the operation or result.  

On Wed, Nov 24, 1999 at 12:37:09PM -0500, Drew Nichols wrote:
> I spent a little bit of time trying to figure out
> what I was doing wrong with my SQL queries.  Then
> I tried simple functions directly out of the MySQL
> tutorial found at www.mysql.com.
> 
> I should be getting this:
> 
> mysql> select SQRT(4);
>              -> 2.000000
> 
> But I am currently getting this:
> 
> mysql> select SQRT(4);
> +----------+
> | SQRT(4)  |
> +----------+
> | 0.000000 |
> +----------+
> 
> I should be getting this:
> 
> mysql> select PI();
>              -> 3.141593
> 
> But i am getting this:
> 
> mysql> select PI();
> +---------------------------------------------------------------------------
> ----
> ----------------------------+
> | PI()
>                             |
> +---------------------------------------------------------------------------
> ----
> ----------------------------+
> |
> 861919951281538276623897189472890945116772092561332099642373187003009130824758
> 55805240843511529472.000000 |
> +---------------------------------------------------------------------------
> ----
> ----------------------------+
> 
> I can't do sum() or avg().  I cant do max() or min()  I can't mathematically
> calculate anything. :)  If you could look into it, I would appreciate it.
> 
> Thanks,
> Drew Nichols
> 
> ______________________________________________________
> Get Your Private, Free Email at http://www.hotmail.com
> 
> _______________________________________________
> cobalt-users mailing list
> cobalt-users@xxxxxxxxxxxxxxx
> http://list.cobalt.com/mailman/listinfo/cobalt-users

-- 
Robert G. Fisher		     NEOCOM Microspecialists Inc. 
System Administrator/Programmer      (540) 666-9533 x 116