l Message-
> From: Alex Keda [mailto:ad...@lissyara.su]
> Sent: Thursday, February 14, 2013 9:36 PM
> To: mysql@lists.mysql.com
> Subject: MySQL 5.1: incorrect arithmetic calculation
>
> bkp0# mysql h5000_bill
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Yo
From: "Alex Keda"
To: mysql@lists.mysql.com;
Sent: 6:37 Piątek 2013-02-15
Subject: MySQL 5.1: incorrect arithmetic calculation
( ... cut ...)
>
> but, my desktop calculator gives the result 548.60
>
1. your desktop calculator is wrong
2. correct result is 548.595, var
- Original Message -
> From: "Alex Keda"
> To: mysql@lists.mysql.com
> Sent: Friday, 15 February, 2013 12:16:18 PM
> Subject: Re: MySQL 5.1: incorrect arithmetic calculation
>
> sorry, I'm too many work... =)
Heh :-) I was thinking, why would that not
15.02.2013 14:43, Johan De Meersman пишет:
- Original Message -
From: "Alex Keda"
mysql> SELECT SUM(`Amount`*`Cost`*(1-`Discont`)) as `Summ` FROM
`WorksCompliteAgregate` WHERE (`ContractID` = 10369 AND `Month` = 497);
Based off the select you printed, this comes to EXACTLY 548.595 f
- Original Message -
> From: "Alex Keda"
>
> mysql> SELECT SUM(`Amount`*`Cost`*(1-`Discont`)) as `Summ` FROM
> `WorksCompliteAgregate` WHERE (`ContractID` = 10369 AND `Month` = 497);
Based off the select you printed, this comes to EXACTLY 548.595 for the first
row and 0 for the seco
15.02.2013 15:07, Alex Keda пишет:
OK. But, how about:
mysql> SELECT 365 * 1.67 * ( 1 - 0.10);
+--+
| 365 * 1.67 * ( 1 - 0.10) |
+--+
| 548.5950 |
+--+
1 row in set (0.00 sec)
mysql>
??
sorry, I'm too many
bkp0# mysql h5000_bill
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1643184
Server version: 5.1.68-log FreeBSD port: mysql-server-5.1.68
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracl
