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