matrixone icon indicating copy to clipboard operation
matrixone copied to clipboard

[Bug]: Cast float32 to float64

Open zengyan1 opened this issue 1 year ago • 1 comments

Is there an existing issue for the same bug?

  • [X] I have checked the existing issues.

Branch Name

main

Commit ID

1dbb5cb7c276256f64bb9c5f8a17f8a6d9f56764

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

企业微信20241023-115453@2x

Expected Behavior

No response

Steps to Reproduce

create table t(a float);
insert into t values(1.05);
select sum(a) from t;

Additional information

No response

zengyan1 avatar Oct 23 '24 03:10 zengyan1

与Mysql一致 Postgresql和Sqlserver的结果是1.05

zengyan1 avatar Oct 23 '24 04:10 zengyan1

Not a bug.

fengttt avatar Dec 06 '24 06:12 fengttt