-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) |
, but maybe I'm doing something wrong.
Regards,
Julien
-Message d'origine-
De : Mark Matthews [mailto:[EMAIL PROTECTED]
Envoyé : lundi 21 février 2005 16:24
À : LAFONTAINE Julien - LYO
Cc : mysql@lists.mysql.com
Objet : Re: Problem with SUM and DECIMAL field
-BEGIN PGP
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
LAFONTAINE Julien - LYO wrote:
> Hi everyone,
>
> I've recentely upgarded my servers from MySQL 3.23.49 to MySQL 4.1.9.
>
> Now I have a problem when using the SUM operator on DECIMAL field.
>
> The value returned by the SUM operator when used with
Hell.
I think you should read comments at:
http://bugs.mysql.com/bug.php?id=1388
They are related to the ODBC connector, but may be it will
help you to solve problems with Connector/J.
LAFONTAINE Julien - LYO <[EMAIL PROTECTED]> wrote:
> Hi everyone,
>
> I've recentely upgar
Thanks, I'll do that.
-Original Message-
From: gerald_clark [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 03, 2003 4:52 PM
To: LeTortorec, Jean-Louis
Cc: '[EMAIL PROTECTED]'
Subject: Re: Problem with sum()
Because neither 0.7 nor 0.1 have an exact binary
Because you are using a float. There has been much discussion of this on
the list, search the archives. Floats aren't so good if you need your math
to be right.
http://www.mysql.com/doc/en/Column_types.html
> -Original Message-
> From: LeTortorec, Jean-Louis [mailto:[EMAIL PROTECTED]
>
Because neither 0.7 nor 0.1 have an exact binary floating point
reprsentation.
Use Decimal type instead.
LeTortorec, Jean-Louis wrote:
Hello every one,
I have a simple table, with a "float" field called quantity.
In this table, there are 2 records: 1 with quantity=0.7, and 1 with
quantity=0.1.
