Re: [cobalt-users] MySQL

["Bjarke Alling" <bjarke@xxxxxxxx>]

Hm...


I can get the right values on a RaQ 2, running MySQL 3.22.21

This is what I did install two months ago.

glibc-*-2.0.7-29C2.mips.rpm
kernel-*-2.0.34-C49_SK.mips.rpm
modutils-2.1.121-1_C3.mips.rpm
MySQL-3.22.21-2C1.mips.rpm
MySQL-client-3.22.21-2C1.mips.rpm
MySQL-devel-3.22.21-2C1.mips.rpm


/Bjarke

> 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
> 


--------------------------------------------------------------
             Cobalt Networks Inc. in Denmark

   [LIGA] ApS - Faelledvej 16D - DK 2200 Copenhagen N
      Tel: +45 35 36 95 05  -  - bjarke@xxxxxxxx
              http://cobalt.liga.dk
--------------------------------------------------------------