|
发现mysql 4.0.18 for nt 的sum函数的计算误差
mysql> create table ch3(ID char(32), V decimal(18,2));
Query OK, 0 rows affected (0.12 sec)
mysql> insert into ch3 select * from vc2;
Query OK, 8192 rows affected (1.24 sec)
Records: 8192 Duplicates: 0 Warnings: 0
mysql> select max(v) from ch3;
+-------------+
| max(v) |
+-------------+
| 99999999.99 |
+-------------+
1 row in set (1.17 sec)
mysql> select min(v) from ch3;
+-------------+
| min(v) |
+-------------+
| 99999999.99 |
+-------------+
1 row in set (1.17 sec)
mysql> select sum(v) from ch3;
+-----------------+
| sum(v) |
+-----------------+
| 819199999918.02 |
+-----------------+
1 row in set (0.08 sec)
mysql> update ch3 set v=100000000;
Query OK, 8192 rows affected (0.12 sec)
Rows matched: 8192 Changed: 8192 Warnings: 0
mysql> select sum(v) from ch3;
+-----------------+
| sum(v) |
+-----------------+
| 819200000000.00 |
+-----------------+
1 row in set (0.06 sec)
mysql> update ch3 set v=100000000-0.01;
Query OK, 8192 rows affected (0.25 sec)
Rows matched: 8192 Changed: 8192 Warnings: 0
mysql> select sum(v) from ch3;
+-----------------+
| sum(v) |
+-----------------+
| 819199999918.02 |
+-----------------+
1 row in set (0.08 sec)
mysql> update ch3 set v=100000000+0.01;
Query OK, 8192 rows affected (0.23 sec)
Rows matched: 8192 Changed: 8192 Warnings: 0
mysql> select sum(v) from ch3;
+-----------------+
| sum(v) |
+-----------------+
| 819200000081.98 |
+-----------------+
1 row in set (0.09 sec)
mysql> select 99999999.99*8192;
+------------------+
| 99999999.99*8192 |
+------------------+
| 819199999918.08 |
+------------------+
1 row in set (0.00 sec)
[办公软件]PowerPoint模板使用经验之谈 [办公软件]教你在Powerpoint中设置页眉页脚
[办公软件]在Powerpoint中如何插入Flash动画 [办公软件]如何在Powerpoint 中(实现)输入上标、下标
[办公软件]如何在PowerPoint同一张幻灯片中显示大量文字 [办公软件]这样来修改PowerPoint超级链接的文字颜色
[办公软件]PowerPoint小小操作技巧，让您工作更轻松 [办公软件]如何在office(PowerPoint,Word,Excel)中制作带圈的…
[办公软件]保留PowerPoint超链接,但是取消超链接的下划线 [办公软件]挖掘PowerPoint图片自动压缩功能在不失真的情况下…
| 
注：本站部分文章源于互联网，版权归原作者所有！如有侵权，请原作者与本站联系，本站将立即删除！ 本站文章除特别注明外均可转载，但需注明出处！ [MinTao学以致用网] 
