-----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----- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
