truncate float incorrectly.

[siddontang]

create table t (float(8));
insert into t values (3.14);
select * from t;

we will get 3, not 3.14.

@shenli

[coocood]

Do you mean create table t (c1 float(0))?

[siddontang]

No, create table t (float(8)), 8 is for field length, no decimal here.

[coocood]

@siddontang but I can not execute this statement in mysql.

[coocood]

Misunderstood the issue, never mind.