MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Mark Matthews Date:February 24 2005 9:54pm
Subject:Re: Problem with SUM and DECIMAL field
View as plain text  
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

LAFONTAINE Julien - LYO wrote:
> Hi Mark,
> 
> Thank you for your help.
> 
> I have the same problem when I execute the query with the MySQL client on my
> AIX server :
> 
> mysql> select sum(AMFTPF) from DWH_AMF;
> 
> +-------------+
> | sum(AMFTPF) |
> +-------------+
> |    12000,00 |
> +-------------+
> 
> 1 row in set (0,03 sec)
> 
> The problem occurs only when I use an operator like SUM, AVG, MAX, MIN...
> 
> mysql> select AMFTPF from DWH_AMF LIMIT 1;
> 
> +--------+
> | AMFTPF |
> +--------+
> |  15.00 |
> +--------+
> 
> 1 row in set (0,01 sec)                     

Julien,

I went ahead and reported this as a bug, you can track it via
http://bugs.mysql.com/bug.php?id=8794
(You might want to comment on it, that way you will get e-mails as its
status changes).

	-Mark
- --
Mark Matthews
MySQL AB, Software Development Manager - Client Connectivity
www.mysql.com

MySQL User Conference (Santa Clara CA, 18-21 April 2005)
Early registration until February 28: http://www.mysqluc.com/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.6 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCHk0dtvXNTca6JD8RAoYBAJ4qTvbLE/1+HJbccqr7W8LEs2m4ygCfZW24
/mWAYntne1Gvv+K78DLgECY=
=guxR
-----END PGP SIGNATURE-----
Thread
Problem with SUM and DECIMAL fieldLAFONTAINE Julien - LYO17 Feb
  • Re: Problem with SUM and DECIMAL fieldGleb Paharenko21 Feb
  • Re: Problem with SUM and DECIMAL fieldMark Matthews21 Feb
RE: Problem with SUM and DECIMAL fieldLAFONTAINE Julien - LYO24 Feb
  • Re: Problem with SUM and DECIMAL fieldMark Matthews24 Feb