HI all:
As we know,when we shutdown the database cleanly,the database can
do a checkpoint.So we don't need redo log againg.In mysql(innodb),we can
restart normaly.But oracle database also need redo log group(current), why?
2014-12-17
I AM AN ORACLE FANS!
Skype:Frank.oracle
Email:xiangdo
On 16.12.2014 15:16, xiangdongzou wrote:
> Can anyone tell me why 531808.11 has been changed to 531808.12 ?
typical decimal->binary->decimal conversion/rounding error.
If you want exact decimals you need to stick with the
DECIMAL type which doesn't have this problem, at the
cost of slower cal
HI everyone:
I have created a table as flowing;
create table t1(c1 float(10,2), c3 decimal(10,2));
insert two records
insert into t1 values(531808.11, 9876543.12);
insert into t1 values(531808.81, 9876543.12);
the result is
mysql> select * from t1;
+---++
| c1
